Hmm I just tried all show up fine without issue for me; all though it seems a bit slow comparing to 2005.

Did you try doing restore/backup using T-SQL to see...

Or your database that your building index in doesn't have enough space to reorganize the index; that was the case for me when it was failing. I would look...

Index fragmentation can be high because the fillfactor is set to 100% correct?

I had dealt with system where they have very wide cluster keys (I am not allowed to change...

I was working with someone on DTS and Linked server on MS newsgroup.. maybe this will help you, link.

Thanks.

Another option you have is catching trace log from your database and running it through the SQL Server Upgrade Advisor :).

In some cases actually that is needed if you have...

You will have to use OSQL to export data directly to a file; or dts packages.

Since I am taking a guess this is one off I would recommend OSQL :).

Thanks.

I don't know if that is possible Nate...

But... isn't 1222 only isn't enough? They both return full information; only thing is 1222 returns information in XML format.

1204:...

I would start with ...

http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/

If you need more help after this ask away I am sure someone here could answer your questions :D.

Thanks.

Mohit.

No!

In SQL Server 2005 the account does not need to be part of Local Admin group. If you configure the SQL Server services using SQL Server Configuration manager it...

I have used both formats; I usually don't notice on the servers. But most of my servers are pretty powerful; but I have shown both those syntax to developers.

And most...

Same as .. Link; being answered there it be :).

As Steve said the decision to visualize comes from the usage; look at some the the Key Performance Indicators to see how SQL Server is working under workload.

If nothing jumps...

What I am shocked at is these quries taking such long time to run; so if we can get row number for the dbo.EmpAdmin table. Also what does the...

Hi Mike,

How many rows are are in "dbo.EmpAdmin" table? I am concerned about the time it is taking you to complete this; and how it is...

I don't know if it is anything wrong .. what version are you doing this on? I am using RC0 .. maybe try reinstalling?

Mohit.