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,125 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)
646 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
231 reads
Blogs
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
VMware & SQL Server 823-824 alerts
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
Forums
Failed to build the OLAP cubes
Hi, We installed default standalone SSAS in tabulator mode (SQL 2017 license). When they...
Exporting the Database Encryption Key
Comments posted to this topic are about the item Exporting the Database Encryption Key
SQL Duplicate remove Query
Hi Guys, I want to remove duplicates from the table. The duplicate is a...
Ask SSC