From Query Analyzer, run this:

select serverproperty ('LicenseType')

It will either return Per-Processor or Per-Seat depending on the type that was originally chosen.  Hope this helps.

This is off topic I suppose...but lately I am even more annoyed with the amount of junk 'snail mail' that I get than I am about Spam.  When we first bought our house...

It had me baffled for a while.  It's kind of like 'Oh my God!' or 'Oy Vey!' or 'Not This Again' - definitely an expression of exasperation.

Hope this helps....

It promises to get worse before it gets better as spammers have figured out how to bypass filtering.  Check out:  http://www.newsfactor.com/story.xhtml?story_title=Spammers_Develop_Troubling_New_Strategy&story_id=30254#story-start

It's been a while but this might be expected behavior when you're restoring master.  According to BOL:

"After restoring master, the instance of SQL Server is stopped automatically. If you need...

Just by means of an update (and to bump my original thread )we're still seeing this daily and users are nearly ready to boil...

Thanks but that doesn't look to be our issue.  The clients are not running SP2 yet and we're resolving by server name not IP address.  Per one of the vendor's...

The clients aren't running XP SP2 yet but the fix would worth taking a look at.  Do you have a KB number for this?  Thanks a lot.

For SQL Server 2000 this is the default setting I believe.  You can change this to increment by a percentage or set number of megabytes on the fly and you...

When you created the Maintenance plan, if you had the 'Attempt to repair any minor problems' box checked on the Integrity Checks tab AND you have set the option to...

If I've read the (very confusing) EULA correctly, you would not need a separate license to install EM or Client Connectivity Tools provided that your servers are licensed on a...

Version 8.00.194 is the RTM or Original Release of SQL Server which is an indication that SP3a did not apply properly.  Try re-applying SP3a and output the results to a log...

If you subscribe to the SQL Server Magazine weekly e-mail newsletter there's an article this week that explains the SQL Server Agent behavior during the DST time change and this...

Is this MSDE?  I had the same issue with a vendor installed MSDE instance when I attempted to load SP3a.  Investigation revealed that they had not set an 'sa' password...

I'm assuming that this machine is Windows 2000 or higher?

Attempting to uninstall MDAC can be problematic at best.  A large part of this is due to the fact that all...