Changing a SQL database name
USE master; alter database DB1_DEV set SINGLE_USER with rollback immediate go ALTER DATABASE DB1_DEV Modify Name =...
Creating a link between two SQL servers
To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures....
Manually adding a mail account to SQL2005/2008
I was having trouble adding configuring Database Mail on a SQL2005 server today. I followed the wizard just...
Simple script to backup all SQL Server databases
DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) --...
How to list all the databases on a SQL server
You can list all the databases on a SQL server by running the following query. SQL> select name...
Creating a link between two SQL servers
To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures....
Manually adding a mail account to SQL2005/2008
I was having trouble adding configuring Database Mail on a SQL2005 server today. I followed the wizard just...
Simple script to backup all SQL Server databases
[draft] DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for backup files DECLARE @fileName VARCHAR(256)...
How to list all the databases on a SQL server
You can list all the databases on a SQL server by running the following query. SQL> select name...
Renaming a SQL Server instance.
SQL> sp_dropserver 'oldservername'; SQL> sp_addserver 'newservername'; don’t run in same batch. the two statements must be executed separately....