You can use BCP if the servers cannot see each other or DTS if they can.

I actually need to write something about this, but here's what I know.

1. This has happened for years in the US. But not to other countries, to lower cost US...

I agree with Denny. Opening 1433 to the Internet is a bad idea. At least redirect it, but preferebly limit this to VPN access only.

Yes, each can use 2GB, but you need to save some for the OS, I'd say 500MB or so, so really 1.7GB or so per instance.

And you should set the...

And what kind of monitoring do you need? Have you looked at Profiler?

load from file: EM, right click DTS, select "open"

Tried 2GB and 4GB total. Not sure about anything in between. Having 1GB for the OS is a nice cushion for paging, swapping, drivers, etc. Not sure if 4 is...

What if you had 3 rows for the civic? Or are you just looking for the lat two rows?

select  max(date)

  , car, type

 from tableA

 group by car, type

will give you the...

I wish I had an answer, but I don't. The client access linked server from SQL has been flaky for me in the past as well.

DTS should be fine if the server names are the same.

sp_help_revlogin is available on MSDN (msdn.microsoft.com).

The above advice should work for you, but practice a few times.

select

    case when version = 'sql2k' then srvname

 end 'sql2k'

,

    case when version = 'sql70' then srvname

 end 'sql70'

,

    case when version = 'sql65' then srvname

 end 'sql65'

http://www.winnetmag.com/Article/ArticleID/21176/21176.html

There must be something else. There is no reason that a user needs SysAdmin to write to a table. Have you checked that there are not overriding "DENY" permissions somewhere...

It's some internal error. If this is a critical server then call MS

Agree. You'd ideally separate OS, pagefile, data, log, and tempdb. If you can't, then separate put OS and pagefile together. IF you still can't do that, put tempdb with data...