Hi
  I want to transfer The Sql database from one sql server to another sql server along with data

Please Help

Is there any version difference between these servers ?

Are both servers accessible to you ? (This means, you should have access to the enterprise manager of both servers)

If answer to forst one is no and answer to second one is yes, then

1) you can take backup of the full database from one server through Enterprise mgr.

2) copy the .bak file to second server

3) restore through enterprise mgr of second server.

In addition to madhukp suggestions, you should also moved your user accounts and security, dts. etc. since you will have a different master database on your new server the accounts will not be mapped to the correct logins (sids)

See SQL Server Books Online to get more information about the sp_change_users_login stored procedure.

http://support.microsoft.com/kb/246133

Jaime E. Maccou

Check out my article on detaching/attaching a database :: http://www.sswug.org/see/17226

If at all you don't have access to that article, google for sp_attach_db and sp_detach_db.

For your reference: http://databasejournal.com/features/...le.php/2224361

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com