SQL 2005 - List Primary Key Columns
Will list Table Name, Constraint name and Primary Key Column Name.
2012-06-29 (first published: 2008-03-20)
2,470 reads
Sandeep Saretha
SQL 2005 - List value of 'Not For Replication'
Script will list all identity columns with valus of 'Not for Replication'
2008-05-13 (first published: 2008-03-20)
731 reads
2008-03-19 (first published: 2008-01-24)
3,545 reads
Blogs
Power BI Meets Programmability – TOM, XMLA, and C#
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Do Full Backups Break Log Shipping?
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
Daily Coping 15 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Disabling all access to the server
Hello everyone! We have a small group of users (4) using MS Access 2000...
How to remove data and index fragmentation in a table
The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...
Database Recovery but DB is 7GB and log file is almost 3
I have had a server crash and although I was able to recover the...
Ask SSC