One of the easiest way is to use Performance Monitor and the SQL Server: General Stats >> User Connections counter.

There is also a way to get a value equivalent...

There is more flexibility in the Index Service that ships with Windows 2000, but it probably won't give you the control you are looking for. Here's a Q article...

I didn't think about the script area, but that makes a lot of sense. This works great! Now if we check back every so often, we can see...

I couldn't agree more. The error descriptions for ADO in general are likewise oh so fleshed out. We called Microsoft about one of those ADO error descriptions for...

Deuce,

Are you sure it instantiates an instance of Excel? Reason I ask is that you can install Office Server Extensions/Office Web Components without installing Office. Been there, done...

Oops. Thanks for the save, Steve.

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

Do you mean the SQL Server Error Log? If so, the errors reported in it should be found in your Books Online.

Index tab >> errors-SQL Server

If you scroll...

Here's a link that describes the structure of the format file. If you have Books Online installed on your system, it's the same as:

Index tab >> bcp utility >>...

Yes, and speaking from experience, some of those 3rd party tools leave a LOT to be desired. I do remember at some point reading an article where there were...

Maybe it's an issue because of changes being made to system tables? Though one would think Microsoft would have ensured this wouldn't have been an issue. Hrm. ...

The most important question: What all has the sysadmin done over the last few days (I'm assuming he's kept a change log)?

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

AOL has reported that it has fixed the vulnerability:

http://www.msnbc.com/news/680950.asp?0dm=C17KT

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

I saw this error with a SQL Server install that was completed enough for the engine to run, but mmc couldn't bring up the SQL Server plug-in.

SP2 includes...

The way the vulnerability works, it's like the ILOVEYOU virus... the ILOVEYOU virus mailed itself to everyone in your Personal Address book and Global Address list (if you were connected...

One of the things I can tack on to this is if I'm having to run queries manually to make changes to the data, I'll start a tran. After...