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,119 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,399 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
Daily Coping 24 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Introducing ScriptDOM
I’ve been meaning to get a series of blog posts started on this topic....
Daily Coping 21 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Auditing Missing Records
Dear Friends, I have configured auditing to track successful logins on my SQL Server....
How to delete records selected from another table in stored procedure
CREATE PROCEDURE usp_DeleteEmployeeRcord ( @days Int ) AS BEGIN DELETE [dbo].[EmpMainTable] Where created <...
Ask SSC