Is the EM client you are using 7.0?  In the 7.x version of the client tools, the server shows what looks like a red lightening bolt next to the server. ...

Okay....Subject says Question of the day for 2/24, but the posted date is for 2/18?    Curious to see what the date on my...

I agree with Phil in that it sounds like your network conneciton is being dropped at some point.  I saw this error a couple of years ago with a Sybase...

Thanks for the reply RD,

They've been playing with SUS lately.  And although no changes were 'supposed' to have been pushed out this weenend and we are 'supposed' to have a...

There's another discussion on this here:  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=131125

Basically, the recovery model of MSDB is going to revert to simple on each restart so you have to have some mechanism in...

AFAIK, there's no way to rename a SQL Server instance.  You either have to re-install, or install a new instance with the desired name.  Once that's done, you could move...

Microsoft has a link to a free utility for stress testing SQL Server installations here: 

http://support.microsoft.com/default.aspx?scid=kb;en-us;231619

You can also create a trace using Profiler while your application is running, capture...

I've seen similar issues with some of out servers, particularly with NT4/SQL7 but once in a while with SQL 2000.  We use Legato's Networker and SQL Business Suite for our...

Fair enough, Farrell.  I too am quite skeptical everytime I hear that 'the xyz worm caused a bazillion dollars worth of damage to the industry' or whenever I hear whatever...

It doesn't have to be dumpster diving either.  Last year we were flying out of the country and I gave my credit card info over the phone to an well...

This from to Books On Line:

Oops again...dyslexia kicking in.  The number is 32767. 

I was going to ask the version next.  SQL Server 7 was licensed 'per server' and 'per seat'.  Not sure if this is the best way, but one way to...

Umm...reminds me of the guy with the wireless laptop who complained when his battery died.  When asked if he had the a/c cord that came with the laptop the response...

Oops...hit 'post' before I attempted to answer your second question.  AFAIK, there's no way to change the licensing method without re-installing SQL Server.