Ocean10000
msg:4478970 | 5:21 am on Jul 26, 2012 (gmt 0) |
I have never tried it but SQL Server Integration Services [en.wikipedia.org] might due what your looking for.
[msdn.microsoft.com...]
|
Ocean10000
msg:4478974 | 5:28 am on Jul 26, 2012 (gmt 0) |
Scratch the previous post. I think I found a much much better way for you to do this ("OpenDataSource").
[msdn.microsoft.com...]
Example:
SELECT *
FROM OPENDATASOURCE('SQLNCLI',
'Data Source=London\Payroll;Integrated Security=SSPI')
.AdventureWorks2012.HumanResources.Employee
|
andrewsmd
msg:4479090 | 2:02 pm on Jul 26, 2012 (gmt 0) |
Yes, I was actually going to post back today, that's exactly what I used. I just had to create a stored procedure because I needed to truncate tables. So create the sp to truncate the tables on the actual database, and then from the other server EXEC OPENDATASOURCE('SQLNCLI','Data Source=SERVER\INSTANCE;Initial Catalog=dbName;User Id=user;Password=pass').[dbName].dbo.spName
|
|
