Show_Locks
Shows database, table names which are locked, the user who locks them, the command which is executed
2005-01-28 (first published: 2005-01-06)
1,122 reads
Shows database, table names which are locked, the user who locks them, the command which is executed
2005-01-28 (first published: 2005-01-06)
1,122 reads
This SP takes a string to be searched as input parameter, loops through all tables, views, Sp-s in the database andreturns the name of the object it was found and number of occurences
2004-12-10 (first published: 2004-08-18)
639 reads
This SP gets all the table names with the column names and data types, datalength. All the existing constrains on the table and column levels along with the Primary and foreign keys and table references
2004-06-01
225 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I have a SqlAgentJob calling a stored proc. that loops through a list of...
I know that there is a query you can run in SQL to search...
Hi all, 99% sure the answer to this question is "it is not possible",...