Technical Article

Rename Foreign Key Constraints

This script will rename all FK constraint names in your database.  It will give them a user friendly name that can be used in error messages, etc. The FK contraint names will be formatted as FK_ChildTableName_ParentTableName_soid. Note: You first need to enable 'Allow modifications to be made directly to the system catalogs'. This can be […]

2003-09-19

1,149 reads

Blogs

Resources for Architecting Zero Downtime Deployments

By

I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...

Daily Coping 23 Mar 2023

By

Today’s coping tip is to focus your attention on the good things you take...

SQL Bits 2023 Recap

By

I had an amazing time adventuring to Wales with other members of the data...

Read the latest Blogs

Forums

Converting To/From User Friendly Trigesimal Geocodes

By Todd M. Owens

Comments posted to this topic are about the item Converting To/From User Friendly Trigesimal...

AG listener error

By roshanbi

Dear Support,   could you please advise why error below prevents me from adding...

Email using msdb..sp_send_dbmail

By rjjh78

Hello,   I have a data export process using msdb..sp_send_dbmail.  Most fields come out...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers