Posted by Erland Sommarskog on 03/01/06 00:55

(sarahlin@yahoo.com) writes:
> YES I am!! I was indeed looking into a different database.
> One quick follow up question, is there any tool that I can use to make
> sure that the restored database is "completely" identicial? say,
> premission, or data.

I guess Red Gate's SQL Compare could do the job. But I have not used
it myself, so I don't know how far it goes.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Reasonable to assemble FullName W/ A UDF
• Prev in forum: Re: Converting Traceid issue
• Thread view: Re: restore sql 7db to sql2000

[Reply to this message]