Technical Article

Update Foreign Key References

This script updates all foreign key references for the specified table. Useful if you need to delete a row. The follow example would update all uses of TableA.IDENTITYCOL where the value is 1 to the value of 2. Example usage: EXEC usp_updateFK 'TableA', 1, 2

You rated this post out of 5. Change rating

2001-11-03

1,453 reads

Blogs

Speaking at the NYC Lunch and Learn DevOps Devour Hour

By

This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

Read the latest Blogs

Forums

Script-Drop Orphan users from SQL Server Database

By Srinivas Merugu

Comments posted to this topic are about the item Script-Drop Orphan users from SQL...

The Hidden Cost of Ignoring Software Bugs

By danishtariq1

Every expert knows you can't make perfect software that never crashes or has bugs....

Building Flame Diagram for MSSQL stored procedures

By tzimie

I wanted to share with you tools from my personal toolbox. If your code...

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers