随笔分类 -  SQL

摘要:Link: http://www.essentialsql.com/what-is-a-database-trigger/ Copy... What is a Database Trigger? A database trigger is special stored procedure that 阅读全文
posted @ 2016-06-29 19:45 鱼悠游 阅读(332) 评论(0) 推荐(0)
摘要:When use SQL Server Profiler, on the Events Selection tab, check Show all events; Find the Store Procedures event, checkSP:StmtStarting and/or SP:Stmt... 阅读全文
posted @ 2015-12-04 11:01 鱼悠游 阅读(119) 评论(0) 推荐(0)
摘要:In Object Explorer, connect to an instance ofDatabase Engineand then expand that instance.ExpandDatabases, expand the database in which the procedure ... 阅读全文
posted @ 2015-11-27 11:54 鱼悠游 阅读(184) 评论(0) 推荐(0)
摘要:Error:when click "New Database Diagram", a error popped up and said "Attempted to read or write protected memory. This is often an indication that oth... 阅读全文
posted @ 2014-11-04 13:07 鱼悠游 阅读(339) 评论(0) 推荐(0)
摘要:Link:http://sudeeptaganguly.wordpress.com/2010/04/20/how-to-enable-sa-account-in-sql-server/引用:When you install the SQL Server using Windows Authentic... 阅读全文
posted @ 2014-10-16 14:19 鱼悠游 阅读(640) 评论(0) 推荐(0)