Search results for query: *

Sorry forgot the syntax bit for using the "linked" server. Check the online help for SQL Server for setting this up, make sure you got your security settings setup correctly. The syntax of the query would pretty much look like any other query except that when referencing table on server b you...

You will need to setup linked servers though in order to do this. Linked server will allow you to access table on another server and perform querries, i.e. copying data over from table on server b to server a. Of course it largely depends on whether you wanted to perform this at any point in...

If I understand correctly, only one particular user can access the stored procedure at a time. If a user access the SP then he/she can modify the tables a and b, other users would only be able to read the tables. Am I correct ? If so then you could perform this my modifying the security on...

What error message are you getting ? I presume that you are trying to schedule this task in SQL Agent to run automatically ? Or are you placing this in a DTS package ? An alternative is to use the bcp command and output the query directly to a flat file with semi colon or tab delimitation...