“IDENTITY_INSERT is already ON for table X” When Applied to Multiple Tables August 22, 2013Munir HusseiniNo Comments Today, I needed to insert data into multiple tables in SQL Server and write to the tables’ identity columns. My…
Automatically Re-Create Stored Procedures In SQL Server May 22, 2013Munir HusseiniNo Comments One day I discovered that the system table sysdepends in my database was not valid. I know that dropping and…
Listing Objects Used in Stored Procedures (MS SQL) May 21, 2013Munir HusseiniNo Comments Recently, I had to clean up a large data base. Some of the tables in that database were obsolete and…