Snipplr

(SQL) Viewing Trigger Order (First and Last) - edwinet

Tue, 23 Apr 2013 01:11:25 UTC

This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.

(SQL) Auditing SQL Server User and Role Permissions for Databases - edwinet

Fri, 08 Mar 2013 01:47:47 UTC

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)

(SQL) Maps an existing database user to a SQL Server login. - edwinet

Fri, 04 Nov 2011 07:47:25 UTC

(SQL) Get last run time - edwinet

Mon, 04 Apr 2011 02:11:29 UTC

(SQL) SQL Template - Drop Column - edwinet

Wed, 02 Feb 2011 09:56:53 UTC

My Drop Column.sql This template drops a columns of the table.

(SQL) SQL Template - Add Column - edwinet

Wed, 02 Feb 2011 09:43:13 UTC

My Add Column Varchar.sql This template adds a new varchar column to the table.

(SQL) Get record count for a specific database - edwinet

Sat, 14 Aug 2010 01:29:13 UTC