http://snipplr.com/users/edwinet/tags/sql Recent snippets posted on Snipplr.com en-us Tue, 21 May 2013 23:29:45 GMT http://snipplr.com/view/70886/using-spwho2/ Usage of sp_who2. To diagnose system slowdowns

]]> Tue, 23 Apr 2013 01:15:46 GMT http://snipplr.com/view/70886/using-spwho2/ http://snipplr.com/view/70885/viewing-trigger-order-first-and-last/ This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.

]]> Tue, 23 Apr 2013 01:11:25 GMT http://snipplr.com/view/70885/viewing-trigger-order-first-and-last/ http://snipplr.com/view/70318/auditing-sql-server-user-and-role-permissions-for-databases/ The sysprotects system table reports all of the permissions granted or denied in a given database. We'll need to join it with sysusers and sysobjects to get all the information we need. Here's an example query that only pulls information on objects (no CREATE TABLE permissions or anything else at the database level)

]]> Fri, 08 Mar 2013 01:47:47 GMT http://snipplr.com/view/70318/auditing-sql-server-user-and-role-permissions-for-databases/ http://snipplr.com/view/48258/sql-template--drop-column/ My Drop Column.sql This template drops a columns of the table.

]]> Wed, 02 Feb 2011 09:56:53 GMT http://snipplr.com/view/48258/sql-template--drop-column/ http://snipplr.com/view/48255/sql-template--add-column/ My Add Column Varchar.sql This template adds a new varchar column to the table.

]]> Wed, 02 Feb 2011 09:43:13 GMT http://snipplr.com/view/48255/sql-template--add-column/ http://snipplr.com/view/39060/get-record-count-for-a-specific-database/

]]> Sat, 14 Aug 2010 01:29:13 GMT http://snipplr.com/view/39060/get-record-count-for-a-specific-database/