In the Microsoft SQL Server 2000 Operations Guide - which can be downlaoded from this URI: http://www.microsoft.com/TechNet/prodtechnol/sql/2000/maintain - there is a suggestion for a baseline in chapter 5...

I don't think using DSN is a good idea: It's based on ODBC, and MS has stated in the MDAC SDK that "You are strongly encouraged to use one of...

There's the property TcpFlag of the Registry2 object in DMO.

Use i.e. a WSH script to set the value { True | False }, and remember to restart the SQL Server...

Great article!

One thing I spend a lot of time doing is connectivity; ADO, OLE DB, ODBC, connection strings etc. Being an issue with scripting and programming, is might be a...

Hi!

I have set up a log recycle every night at 23:59:30 so that the day is shown nicely i EM. The number of logs is raised to 35, so I...

I'm using VBScript (WSH), but at my new job there are a lot Perl people so I'm warming up to look into Perl to be able to understand what they...

Beside Kalen Delaney I'm using Ken Henderson's Guru's Guide box a lot.

Hi.

I've used the OLE DB provider (IBMDADB2) that comes with DB2 Connect or DB2 client. One of these you have to install on the machine where the DTS package is executed. When...

Generally speaking, a carriage return in VBScript i vbCrLf, ex.:

WScript.Echo "Hello" & vbCrLf & "World"

displays

Hello

World

I do hope this very short and general answer is somehow usefull.