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,126 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,126 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)
648 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
232 reads
By Steve Jones
I have been experimenting a bit with graph databases, trying to learn more about...
By Steve Jones
Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
Comments posted to this topic are about the item How to Connect SQL Server...
Comments posted to this topic are about the item Adjusting DOP based on Feedback
Comments posted to this topic are about the item How Important is Zero Downtime?