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,127 reads
Where_Am_I
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)
649 reads
Script to DB Schema
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
Blogs
Creating an Empty Repo in GitHub–#SQLNewBlogger
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
Product Review: DataVeil
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
The Last Price Bump for the Data Community Summit
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Forums
Weekly sales report
I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate...
Copying an old database to a new database
Hi All, I've got a write a program to copy the data from one...
Transaction log full due to LOG_BACKUP
1 of my production database's transaction log file is full due to some backup...
Ask SSC