Clean up default constraints

The script scrapes out all default constraints (optional for particular column, table or script generation for the whole db) in SQL Server 2005 manner. Based on: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00a11.asp

2007-09-03 (first published: )

568 reads

Blogs

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

I’m Speaking at #SQLSatSpokane

By

I am super excited to announce that I have been selected to speak at...

Common commands and tasks to make dealing with Windows Core easier.

By

I don’t know how many of you are working with Windows Core these days...

Read the latest Blogs

Forums

Help with SQL query

By rocky_498

Hi Guys, Here is my "Sample" source data. ID,DKey,SKey,InvType ,PID,PAmount,CAmount,AAmount 1 ,123 ,456 ,Write-Off,789,$505...

SSAS processing Cubes using DTExec vs. SSDT 2017 tools?

By datsun

Hello We have Analysis Server cubes on SQL 2016/Windows 2019 environment. Using dtexec to...

Dynamic Connection String for Dataflow Task

By oogibah

Hey Guys, I've been tasked with doing a task where I connect to a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers