edwinet

Member since 08/14/2010

6 snippets

3128 profile views

0 Comment(s) Posted

View their favorites

their Tags

sql table template security query

Profile

Achievement

edwinet's Recent Snippets

All /

« Prev 1 Next »

SQL 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.

query
sql

0 1367 posted 12 years ago by edwinet

SQL 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 (...

0 1493 posted 12 years ago by edwinet

SQL Maps an existing database user to a SQL Server login.

security

0 1479 posted 14 years ago by edwinet

SQL SQL Template - Drop Column

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

0 1009 posted 14 years ago by edwinet

SQL SQL Template - Add Column

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

0 1130 posted 14 years ago by edwinet

SQL Get record count for a specific database

1 1301 posted 15 years ago by edwinet