Testing all procs before upgrading to Compatibility Level 90
You can use this script to check if any procs will break under compatibility level 90.
2012-03-08 (first published: 2008-01-29)
4,144 reads
Luiz Barros
Find and Replace a String in the Whole Database
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database.
2011-10-27 (first published: 2008-02-08)
3,401 reads
Change column type on constrained columns
Use this proc if you need to alter a column that is part of a primery key
2008-02-04 (first published: 2007-12-10)
1,099 reads
Blogs
Storage Field Day 23 – SIOS
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the...
Daily Coping 17 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SSRS permissions basics
Is it possible via a query, specific to 'SSRS' (SQL Server Reporting Services) to...
Azure SQL Database Differential Backup Frequency
Comments posted to this topic are about the item Azure SQL Database Differential Backup...
The General Database Platform
Comments posted to this topic are about the item The General Database Platform
Ask SSC