Microsoft SQL Server
Thursday, 1 September 2011

Copying And Moving SQL Server Logins

›
----------- copying-and-moving-sql-server-logins ------------------- --- STEP : 1 EXEC sp_helplogins ------------------------------...

BACKUP Details

›
BACKUP Details ---Full & Differential Backup Details DECLARE @dbname sysname SET @dbname = NULL --set this to be whatever dbna...

Collation

›
Collation -- Script that returns all available collations select * from fn_helpcollations() -- Script that returns all your databases...

Comma Seperater

›
Comma Seperater --- Create Function CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1)) returns @temptable TABLE (ite...

All about space Details

›
--- To Get Drive Space --use master --go --CREATE PROCEDURE sp_diskspace --AS --SET NOCOUNT ON DECLARE @hr int DECLARE @fso int DE...
›
Home
View web version
Powered by Blogger.