They were put there because the develpers were too lazy to change the import from the default build from excel. I have been working with the team for months to...

In the case I am working on all are SQL2005 databases, some were migrated from 2000, some were created on 2005. The issue I am trying to resolve is removing...

at the top of of the script add

USE

go

or within query analyzier change from master to the database you wish to run this against

The other issue to consider is how fast will the moving of the bak vs mdf and ldf to new server will take place. If the bak is smaller it...

Thanks for your help. The script Joel supplied gives me closer to what I need. I just will have to play with it to sort the data by tables and...

that was laptop thinking with out me! I do apologize and tryed to delete the extra post and rebooted machine. 😀

With our databases, I have 30+ to check with many tables each with sometimes 100+ columns in the table. The script I wrote shows the column length, and the max...

In our envirornment I am the DBA with full access to the database except for cc nums which are encrypted, our security adminstrator has access to the encryption and decryption...

Nope, never found a solution.

That is the "nicest" thing we can tell them isn't it?

Create a blank database on the 2000 box. Script out the tables etc from the 2005 box and run that on the 2000 box. If that works then you can...

Please state what steps and options you are selecting in the restore steps. Specifics help in diagnosing issues :):)

When I did the install to our Dev system and defaulted all to the alternate E Application drive, Microsoft still insisted on installing files on the C drive. If any...

Sorry, The best you can do is uninstall and reinstall in that situation.

Try this resource

http://msdn2.microsoft.com/en-us/library/ms144245.aspx