connecting problems (how do i...?)

Results 1 to 2 of 2

Thread: connecting problems (how do i...?)

  1. #1
    Join Date
    Dec 1969

    Default connecting problems (how do i...?)

    i have sql server 2k on the host, and i want to connect my copy to the one on the host&#039;s server. that way, i can use DDL and DML on my copy and upload the changes to the server directly.<BR><BR>how do i do it? any walkthroughs or articles?

  2. #2
    Join Date
    Dec 1969

    Default I *believe*...

    ...that you can DETACH the database on your machine, upload the file that results, and then ATTACH that file on both your machine and the server.<BR><BR>Look at the system stored procedures "sp_attach_db" and "sp_detach_db".<BR><BR>I&#039;ve never done this to upload to a remote server, but I&#039;ve done it across a LAN.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts