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 2000 Forums
 SQL Server Administration (2000)
 can sql server client attach local db?

Author  Topic 

automicgina
Starting Member

25 Posts

Posted - 2003-03-25 : 10:11:06

Hi,

My computer is running sql server client. I use that to connect to the server db. I now have a local db in my computer I want to connect to, can I run the query analyzer to attach the local db? Do I login to my server to do that? Will the sql server allow me to attach the local db?

Thank you very much!


chadmat
The Chadinator

1974 Posts

Posted - 2003-03-25 : 11:42:36
Yes. As long as the version of the client tools is compatible. If you have 2000 Client tools, you can connect to any 2000 or 7.0 SQL Server that you have access to. If you have 7.0 Client tools, you can only connect to 7.0 Servers.

-Chad

Go to Top of Page

automicgina
Starting Member

25 Posts

Posted - 2003-03-25 : 12:13:17

Thanks, Chad!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-25 : 12:24:15
When you say that you want to attach the local database, do you mean that you have the mdf file that you want to attach to your server? If so, did you install the server part of SQL Server and not just the client tools?

Tara
Go to Top of Page
   

- Advertisement -