That's a shocker Gus, and not a nice feeling when you have to start thinking about the future of the company you work for.

My choice is having several tools that does their job pretty well.

I thought this many times about the SSMS, especially when the Activity Monitor opens one window for each...

Congratulation Gail !, on breaking the 15000 score. 🙂

Post the DDL, sample Data and the desired output as per the article below

http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Sorry I realized that you wanted answers also.

The answer is SQL Server Reporting Server. 🙂

My first question

What is SSRS?

In the SSMS, under the Security Node expand the Logins, select the user, right click choose properties. The properties dialog is displayed and change the password by typing the...

What about Indexing?

One thing is for sure, Backup of SQL 2008 Database will not restore in SQL 2000.

Believe both. The SP info in the result of @@Version is actually for Windows Server so it is Windows Server SP2.

Where as serverproperty('ProductLevel') is for SQL Server.

What are the errors you got when you ran consistency check and what steps did you peform?

Post them here.

You are welcome ! 🙂

It displays the SQL Server information along with Windows Server Information and people get confused when they see the "Service Pack 2" at the end of that message.

Use this command

select...

What command are you using to kick off the maintenance plan?

It must have been down. I didn't Google since yesterday. 🙂