sqlserver的日常检查脚本归结

--sqlserver  日常检查脚本

print '----------------------------'

print ' 0.sqlserver all information  '

print '----------------------------'

print '                             '

print '*********************************'

--Step 1: Setting NULLs and quoted identifiers to ON and checking the version of SQL Server 

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'prodver') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)                        

drop table prodver

create table prodver ([index] int, Name nvarchar(50),Internal_value int, Charcater_Value nvarchar(50))

insert into prodver exec xp_msver 'ProductVersion'

if (select substring(Charcater_Value,1,1)from prodver)!=8

begin

-- Step 2: This code will be used if the instance is Not SQL Server 2000 

Declare @image_path nvarchar(100)                        

Declare @startup_type int                        

Declare @startuptype nvarchar(100)                        

Declare @start_username nvarchar(100)                        

Declare @instance_name nvarchar(100)                        

Declare @system_instance_name nvarchar(100)                        

Declare @log_directory nvarchar(100)                        

Declare @key nvarchar(1000)                        

Declare @registry_key nvarchar(100)                        

Declare @registry_key1 nvarchar(300)                        

Declare @registry_key2 nvarchar(300)                        

Declare @IpAddress nvarchar(20)                        

Declare @domain nvarchar(50)                        

Declare @cluster int