Master Database

Technical Article

RE: drop primary key

  • Reply

Well, the problem with that is when the table is created, I do a create table(TableIdCol...primaryKey(TableIdCol))So, now you've got a good reason to care for the names of your object yourself. There are more than one way to skin that cat. You can use one of the above orsp_helpconstraint orUSE NORTHWIND SELECT  T1.TABLE_NAME  , T2.CONSTRAINT_NAME FROM […]


Technical Article


  • Reply

Does the UPDATEXT function actually overwrite whats in the column? What would be the syntax on that? Sorry if these are ignorant questions.


Technical Article

RE: Job restart on condition

  • Reply

2Jeremy Kemp: The procedure I call from the job does a number of backups in a cycle: set @backup_command = 'BACKUP DATABASE ' + @db_name + ' TO DISK=''' + @full_backup_path + @db_name + '\' + @db_name + '.BAK''' + ' with INIT' exec(@backup_command) -- if backup is successfull, it updates the LastBackup field in […]



Daily Coping 26 Jan 2023


Today’s coping tip is to focus on what’s good, even if today feels tough....

Working With Tags in FlashArray using PowerShell


Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...

Using SQL Data Compare from the Command Line with a Project


SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Read the latest Blogs


Visual Studio Code - SQL Server (mssql) Version 1.17.0 - Encryption By Default

By o.schoen

Microsoft is warning of a "BREAKING CHANGE" and indeed this little update took my...

SQL Table Issue

By Jobs90312

Hi everyone, In below code I am creating a table and inserting some english...

what does the backup log init do?

By vpmaciel

what does the backup log init do?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers