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