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

DBCC command list

DBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)…

Read More