This script uses the extended stored procedure xp_instance_regread to read a value from the registry
DECLARE @retvalue int, @data_dir varchar(500) EXECUTE @retvalue = master.dbo.xp_instance_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\MSSQLServer\Setup', 'SQLDataRoot', @param = @data_dir OUTPUT PRINT 'SQL Server Data Path: '+ @data_dir
This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000.
2002-07-11
642 reads
An Improved version of GetFileInfo that now includes the space utilization of each datafile. Provides more detail per file. Predict when your files are going to grow!! Both data and log files. This script organizes information about the database files on the server. A cursor is used to get the information from each database. The […]
2002-06-28
544 reads
This script organizes information about the database files on the server. A cursor is used to get the information from each database. The information is reported in Megabytes, including the next allocation from disk. No bells and whistles...and if I can find how dbcc showfilestats works I will add the amount of space used in […]
2002-06-24
1,074 reads
This stored procedure loops through each trigger and performs an action on that trigger , like disabling or printing it. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. Shortened version of the usage (there are a lot more parameters […]
2002-06-14
658 reads
This stored procedure loops through each user defined Foreign Key and performs an action on that FK, like disabling them or printing its name. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. .Shortened version of the usage (there are […]
2002-06-14
656 reads
