Under management, (make sure your agent is running)expand SQL Server Agent, click on jobs and look for the red circle with the white x. This will show what task...

First, you should know that IBM and MS do not play nicely together. I have attempted to set up the Notes/MSSQL configuration. Best info is located in Notes...

when you installed SS2K was tcp/ip and named pipes enabled/selected?

In EM - Right click on db, select Properties, under Options tab - Access check Read Only box.

Oh boy, it's never easy is it? Backup all system and user databases (except tempdb), schedule your prod server downtime and reinstall and restore all (some will have to...

Reinstall - That's all... whoever set it up must have excluded SQL Server Agent. You've got to have it!

Right click on My Computer, select Manage, select Services. Or, open Control Panel and click on Services. Do you see SQLSERVERAGENT in the list of services?

That's what I forgot to do! Thanks!!

I Hate Mondays

I've got the Updated-SP3 BOL and mine is behaving itself - index search works fine.

Guess it's time to reinstall 🙁

I tried mine and everything looks ok. What should I look for?

Knock 'em off!! Then do an alter database dbname set single_user with termination!

/* This procedure will kill all current system process id's (spids)

Within the database named.

To execute this...

Backup and restore. change db name in restore and select from device. change physical file name/location in options tab.

I'm experienceing similar problems (i.e. Unable to connect to server '(local)'; SQLServerAgent cannot start)

How did you rebuild registry? Straight from OS install CD?

/*sp_who will return:

spid (system process id)

where spid 0 - 50 = MSSQL Reserved spid's

and spid >= 51 = User/application spid's

ecid (execution...

Perhaps I don't fully understand the issue, but I do know that creating SQL Server instances is not possible without SQL Server 2000, Enterprise Edition.