Home » 2012 (Page 14)
Yearly Archives: 2012
Make Your Objects System Objects
In SQL Server 2000 we have to set the system marking to on with master.dbo.sp_MS_upd_sysobj_category. In SQL Server 2005 we have the sys.sp_MS_marksystemobject stored procedure that does the trick. SQL Server 2000: USE master — This turns the 2000’s system marking on EXEC master.dbo.sp_MS_upd_sysobj_category 1 go CREATE PROC SP_TestProc AS SELECT * FROM information_schema.tables — … Continue reading
VBS Script to Check DLL Version
Set fso = CreateObject(“Scripting.FileSystemObject”) Set objShell = CreateObject(“Shell.Application”) Set f = fso.GetFolder(“c:\windows\system32”) ‘change directory name Set fc = f.Files For Each fs In fc If fso.GetExtensionName(fs) = “dll” then WScript.Echo fs.Name, fs.DateLastModified, fso.GetFileVersion(fs) End if Next Save script with a vbs extension and run from the command line as cscript scriptname.vbs
Hello world!
This is my first post in my first blog site in this blogging world. I am having experience of around 5 years on MSSQL server. I will like to share my experince & take new learning from your contribution. – Rohit Garg