How to identify IDENTITY columns tables in a database

Here is a nifty query that will display all the tables and columns set as IDENTITY in a given database:

Views –…

Read More

Enabling and Disabling SQL Logins

Here is some simple T-SQL to enable or disable a SQL login account:

Views – 1650

Read More

The the most blocked queries

Views – 1635

Read More