Steve, is this an undocumented function? I don't see anything in BOL. I'll play around with it. Thanks for the tip.

I didn't think re-installing was the best option. Here are the results.

LoginName                                    SID                                                                                                                                                                          DefDBName                DefLangName          AUser ARemote

-------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------ -------------------- ----- -------

BUILTIN\Administrators                      ...

Unfortunately it was with SQL authentication. I'm tempted to try reinstalling SQL but I'm not sure of the ramifications.

I followed the advice from TMP and found it was a service running that was no longer needed. Thanks for the advice.

There were definitely no threads into the database. What I did was to fix this was shut down the services, copied the .mdf and.ldf from the production box and restarted...

What type of load will profiler add to the system?

The easiest thing I do is simply install SQL on the new server, backup the database on the old server and restore to the new server. You can do the...

Absolutely. And upgrading from SQL 7.0 to 2000 is easy as well.

I'm assuming your not running SQL 2000? Even if you're not, you should be able to run your current version of SQL on Windows 2000 without issues. However, if you...

I have a server where there was a default instance that I couldn't use because it was in use by NetManage (per our network admins). We added a new instance to...

Phil,

When I tried this on a table here, I received the following message:

"Cannot use a CONTAINS or FREETEXT predicate on table 'NAMES' because it is not full-text indexed." What does this...

Aaron,

Stupid question of the day! How do you get the showplan to appear in text format?

We've been using it for about 18 months and have had no issues regarding restores. Our database is about 170 gb and it compresses it down to about 21 gb.

The service was on so I stopped/restarted it and get the same results. Any additional thoughts?

Linda,

When I do select serverproperty('licensetype'), it returns disabled. When I do select serverproperty('numlicenses') it returns NULL. What does that mean? It's definitely an active SQL server.