For what it's worth, this just showed up in my latest MSDN Flash, dated June 10, 2002!
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546&SD=MSKB - "HOW TO: Move Databases Between Computers that are Running SQL Server (Q314546)".
Rick
>Hi All:
> I am going to transfer data from one sal server 7.0 to another sql server 7.0. I want to transfer all of my stored procedures, views as well as all the users rights and securities. Is there a way that would allow me to do just that without great deal of effort from me?
>Thanks