i have installed MS SQL Server 2000, and in the manager i see all the defaults dbs like : master, model, msdb, northwind, pubs and tempdb
i copyed a data base of my own (a .mdf and a .ldf) in Data folder and i cannot see it
what is the problem? how can i see it?/?You must attach it first (make it known to the SQLServer).
Use EM, klick the server node, right-klick the "Databases" (Folder-like) node, point to "All tasks", point+click "attach database" + put the other stuff in. ...
Or RTFM the section about "sp_attach_db" if you would like to do it via SQL ...|||ill try that when i get home
thx mate :)|||You need to attach the database and when the file open window pop-up, choose the file you have copied.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment