Count and display number of rows in all tables
This script can be used to display the number of rows of all the tables in a database.
2003-01-02
299 reads
Script to get tables which have primary key
There isn't a convenient sp or tool in sql server to find out all the tables in a database which have primary keys. This script can help you to list all the tables with primary keys.
2002-10-21
430 reads
Blogs
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...
All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
This is the first in a series of posts about gatekeeping in Information Technology...
None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
Forums
full text search
Trying to understand why when I search for numerics in full text, contains does...
New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012?
MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...
SSIS Package/Agent Job Not Failing!!!
I have a package running in SQL 2016 using Project Deployment. One of the...
Ask SSC