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,128 reads

Blogs

T-SQL Tuesday Retrospective #006: What about blob?

By

I am revisiting old T-SQL Tuesday invitations from the very beginning of the project....

Daily Coping 2 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Database Corruption, how to investigate root cause?

By

Introduction: In this article, we will discuss the MS SQL Server database corruption.  So, first, we...

Read the latest Blogs

Forums

vbs failing

By Sailor

This vbscript for Excel that opens a pipe delimited file  is failing srccsvfile =...

SQL Server Load

By narayanamoorthy.a

Hi, The application team is pushing more than 7 lakhs records per day to...

Converting minutes to hh:mm:ss

By DaveBriCam

I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers