Thanks the sp_attach_dp worked
Does anyone know what could cause the SQL Manager to run real slow. just
right click on a table , it takes almost 2 mins for the menu to appear.
then it takes a few mins for the table to display (design).
SQL manager seems to be the only program affected.
again thanks for the link help
-----Original Message-----
From: Marlon Moyer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 3:14 PM
To: CF-Talk
Subject: Re: OT:SQL linking to old database
from query analyzer use
sp_attach_db 'dbname', 'dbdatafilewithpath', 'dblogfilewithpath'
----- Original Message -----
From: "Bruce, Rodney" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 4:51 PM
Subject: OT:SQL linking to old database
> Hello all
>
> I need some help with SQL 7, on NT4.0.
>
> I am not very familiar with SQL at all. I just reloaded it on to
> the server and want to connect to the existing databases. But I can only
> find in SQL to import data, copy it into a now set of tables. How can I
> just reconnect SQL to the already existing tables with out having to copy
> them into a new database. These tables were connected to SQL before the
> reload and were running fine.
>
> Thanks for any help
> Rodney
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
