Enable/Disable a table to be read only on the fly
Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?
2013-07-30
9,115 reads
Steven Rao
Dynamically Truncate a Partitioned Table
Wouldn't be great if you could truncate any partition of a partitioned table with one T-SQL statement? This article shows you how.
2013-07-11
4,624 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