Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Database Copy

Author  Topic 

nshankar
Starting Member

9 Posts
Posted - 2009-03-30 : 01:15:06
Hi All,

i need to copy the whole database to another with triggers,stored procedures,constraints...etc all to a new database name using T-SQL

Suggestions will be quite helpful
Thanks
Shankar.N

heavymind
Posting Yak Master

115 Posts
Posted - 2009-03-30 : 02:26:29
does not backup/restore fit you?
see how to move database article
http://db-staff.com/index.php/microsoft-sql-server/83-how-to-move-database

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site