Changing the Path for the Master Database

We as DBAs, changing or migrating databases to a new path is important part of admin’s world. This article helps you with the steps involved to move the Critical 'master' database.

Restoring the SQL Server Master Database Even Without a Backup

Many DBAs back up their user databases, but not their system databases. Whatever the reason for the lack of a backup, John Grover explains how to save yourself (mostly) should you ever find yourself with no viable master database and no good backup.

Rebuilding Master Database in SQL Server 2005

search every database on server from a single sp

i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works

RE: drop primary key

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 […]

RE: xp_cmdshell

is it possible to start a program (with parameters)from a stored procedure or a trigger. and the program should run out of process .i mean not using the same memory of sql server??rgdsramesh

RE: HELP!!

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

RE: Job restart on condition

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 […]