edwinet

Member since 08/14/2010

6 snippets

1966 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 918 posted 11 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 1006 posted 11 years ago by edwinet

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

security

0 1027 posted 13 years ago by edwinet

SQL SQL Template - Drop Column

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

0 642 posted 13 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 712 posted 13 years ago by edwinet

SQL Get record count for a specific database

1 805 posted 14 years ago by edwinet