execute
2015-11-04
3,106 reads
shazza-933300,
2009-09-08 (first published: 2009-08-31)
execute
--This script pulls all data and log files --associated with any user db's BEGIN CREATE TABLE #FILEINFO (DatabaseName VARCHAR(100), PhysicalFileName NVARCHAR(520), FileSizeMB INT, Growth VARCHAR(100)) DECLARE @command VARCHAR(5000) SELECT @command = 'Use [' + '?' + '] select ' + '''' + '?' + '''' + ' AS DatabaseName, sysfiles.filename AS PhysicalFileName, CAST(sysfiles.size/128.0 AS int) AS FileSize, CASE WHEN status & 0x100000 = 0 THEN convert(varchar,ceiling((growth * 8192.0)/(1024.0*1024.0))) + '' MB'' ELSE STR(growth) + '' %'' END growth FROM dbo.sysfiles' INSERT #FILEINFO EXEC sp_MSForEachDB @command SELECT * FROM #FILEINFO order by DatabaseName, PhysicalFileName DROP TABLE #FILEINFO END GO
2015-11-04
3,106 reads
This article describes a way by which we could use the feature of database mail in SQL Server 2000 itself which is a lot easier than SQL Mail.
will create jobs script for backup or DR purposes to install on another server.
2012-01-18 (first published: 2011-12-15)
2,032 reads
The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.
2010-07-06
11,853 reads
Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005
2011-02-18 (first published: 2009-09-15)
52,979 reads