4.1 Detaching and Attaching a Database in SQL Server 2005 Express

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
9,881
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jul 9, 2008

Detaching your Database from the SQL Server Management Environment so it can be accessed by programming languages

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (Firchild)

  • Misleading! Detaching a database removes it completely from SQL's database engine (not just SSMS), and therefore removes the ability to query the database. If you want to connect to a SQL database from a progam via ADO or similar, the database needs to be attached to an instance of SQL server or you're going to get nowhere fast. Detaching a database is used to move databases between instances or the same instance of SQL server without having to do a backup/restore.

  • @ChrisMCITP Thanks for the input, and you're right, but this is designed for GCSE (14-16 year olds), so we kind simplify it

see all

All Comments (5)

Sign In or Sign Up now to post a comment!
  • Thank ya

  • Good One m8 ;)

  • Thanxxxxxxxx :)

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more