How to copy..........

I have 2 files with its same name (at folder C:\a\ and C:\b\, both Name
files is SData.mdf). I wanna access the files in enterprise manager at the
time. Can I do it? Because I wanna copy a object (table, store procedure,
etc) from C:\a\Sdata.mdf to C:\b\Sdata.mdf.
How to do it efficiently?Hi
You cannot 'access/open' them . Its data files SQL Server used for. RESTORE
DATABASE with a different names and make your copies
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:eLt2paOTGHA.4384@.tk2msftngp13.phx.gbl...
>I have 2 files with its same name (at folder C:\a\ and C:\b\, both Name
> files is SData.mdf). I wanna access the files in enterprise manager at the
> time. Can I do it? Because I wanna copy a object (table, store procedure,
> etc) from C:\a\Sdata.mdf to C:\b\Sdata.mdf.
> How to do it efficiently?
>

How to copy record from a table in a server to a diffrent server.

Hi all,

I have server1 and server2 having the same tables. I wanna copy tbl1 records in server1 to tbl1 table in server2. How can I accomplish this task?

Thank you in advance,

Use a query. This assumes you have permissions to both servers.

Code Snippet

INSERT INTO tbl1
SELECT
Col1,
Col2,
Col3,
etc
FROM Server2.MyDatabase.dbo.tbl1
WHERE {criteria}