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
434 reads
Blogs
Pluralsight Free April
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
Forums
Developer Edition
I am proposing to the business that we use SQL 2019 Developer in our...
SQL server agent stop working (the server threw an exception [0x80010105])
Hi, I have cluster SQL (2008) running under windows server 2008. The cluster is...
change data capture errors cdc_errors
The cdc capture job ran into errors on our prod server. The error reporting...
Ask SSC