DBCC DBINFO (s)DBCC DBINFO (master)DBCC DBTABLE (st)DBCC HELP ( 'CHECKIDENT')DBCC IND ('xlis_ods', 'SBSB', 0)EXEC master..sp_MSgetversionSELECT@@versionEXEC master..xp_subdirs 'C:\Documents and Settings\skeerthi\Desktop'go
EXEC master..xp_dirtree 'C:\Documents and Settings\skeerthi\Desktop'EXEC master..xp_getnetnameEXEC master..xp_fileexist 'C:\Documents and Settings\skeerthi\Desktop\Create script for Sproc from VSS dwh\sp_Build_Member_Span_Step1.sql'EXEC master..xp_fileexist 'C:\Documents and Settings\skeerthi\Desktop\Create script for Sproc from VSS dwh\sp_Build_Member_Span_Step9.sql'EXEC master..xp_enumgroupsEXEC master..xp_enumerrorlogs
EXEC master..xp_enum_oledb_providerssp_MSforeachdb
sp_MSforeachtableexec sp_MShelpcolumns 'Sbsb'exec sp_MShelpindex 'Sbsb'execsp_MSdependencies 'CLM_HOSP_COND_CD'EXEC sp_MShelptype -- returns data typessp_MSindexspace 'CLM_HOSP_COND_CD'sp_MStablespace 'chkpoints1'
EXEC master..xp_dirtree 'C:\Documents and Settings\skeerthi\Desktop'EXEC master..xp_getnetnameEXEC master..xp_fileexist 'C:\Documents and Settings\skeerthi\Desktop\Create script for Sproc from VSS dwh\sp_Build_Member_Span_Step1.sql'EXEC master..xp_fileexist 'C:\Documents and Settings\skeerthi\Desktop\Create script for Sproc from VSS dwh\sp_Build_Member_Span_Step9.sql'EXEC master..xp_enumgroupsEXEC master..xp_enumerrorlogs
EXEC master..xp_enum_oledb_providerssp_MSforeachdb
sp_MSforeachtableexec sp_MShelpcolumns 'Sbsb'exec sp_MShelpindex 'Sbsb'execsp_MSdependencies 'CLM_HOSP_COND_CD'EXEC sp_MShelptype -- returns data typessp_MSindexspace 'CLM_HOSP_COND_CD'sp_MStablespace 'chkpoints1'
No comments:
Post a Comment