Hi all,
we have restored a database, and then by runing an upgrade utility we
have upgrated the database.

Now , we need to test the upgrated database i.e all old tables are
present in the correct scema...space used in the current
database..blah..blah..blah..

Would u pls suggest some approach...means any sp that can help
us.....sp is expected to return all the related info regarding
database.....we need very detailed information about tables,database
structure,spaced used and anythig else that are required for the given
task.

Am I clear about my requirement?If so, pls help...

Thanks in advance

Try the new Visual Studio for Database Professionals, it will cover
most of the features you need. Currently its in the CTP version
available online.

http://www.microsoft.com/downloads/details.aspx?FamilyID=c2ffa0e9-b68e-4411-9c90-14697ac8fb95&displaylang=en


HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---

random select a row based a weight column.
Timeout expire
Optimize this query
store results over network
dynamic SQL versus a huge IF structure