How do I attach a database to a SQL Server?

Very simple.

 You can do it in the SQL Server Management Studio (SSMS) or use System Stored Procedures.

You can see a step by step method at this link here.
http://hodentekmsss.blogspot.com/2010/05/using-sample-databases-with-sql-server.html

Moving from SQL Server 2000 to 2005 read here:
http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/3/ [about 0.5 million page views]

Pure Microsoft SQL Servers

I have started a new blog exclusively covering topics that interested me (off /On) related to Microsoft SQL Servers. I also plan on posting links to my older articles on this subject.


I am a busy guy, you will also find new stuff that may help you in your learning experience.

Well, Hodentek is all about learning.

http://hodentekmsss.blogspot.com/

Welcome to the new blog.

Jay