>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
You can attach the database with SQL sp_attach_db stored procedure (you can also do this via SQL Server Enterprise Manager.)
Also, you can use backup/restore to copy one DB from one server to another.
Additionally, you can use Data Transformation Services to do stuff like this, but if you need everything in the database I would suggest one of the other 2 techniques that I mentioned above.
Hector Correa