This got to do a lot with the requirement, data storage and Db design.... do not create indexes cluster/non-cluster just for the sake of creating indexes. We ran into trouble...

You got to check BOL for maximum limit under "Data Types" "CREATE INDEX" "Creating an Index"

I had this issue with our sandbox, but I opted for a clean install of 2005.

Not sure if you had a look at this link already - might help...

Guess the DAC option would have been good to add...

You may wanna check the below articles, which gives you more details to determine-

http://support.microsoft.com/kb/873235

http://support.microsoft.com/kb/317375

http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=1956

Yes n No. It also depends on the appropriate fillfactor[FF] levels. FF amount will depend on how read or write intensive your tables are and the more write intensive the...

Sree, I guess this is pretty common scenario...you can grab your MS book or BOL to find othe details... search for 'index'.. ATB..

As its told, dont try to remove sa...pbly go with the other option of securing with strong password..and leave that aside..

If you've the backup tool like veritas or sql litespeed or redgate ..its much easier to do this in one shot...

Run -->cmd :

mstsc /V:servername /console

also look up for the win version that you run..

you mite as well need to check the logs on both the server and see if you can hit something there...

Have a look at these links:

http://www.sqlservercentral.com/columnists/ckempster/datamigrationoverview.asp

http://www.sqlservercentral.com/columnists/sMaganti/microsoftsqlservermigrationassistant.asp

http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp

http://www.sqlservercentral.com/columnists/gFritchey/migrationtoproduction.asp

http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/

That's exactly what was asked by Microsoft.

WHY is the limitation ??? There should be some LOGIC....

Hope to get more clue on to it....

By the way... I already got into the...

Gallan, am afraid is this your signature [Wrong forum, this is the Notification Services forum.] or your answers for any questions. ?

I've seen all your replies are just the same...