MSSQLTips

Need logic to implement, export of data from different tables to their respective files in a single batch.. No joins, merge, nothing... just a file containing 'increment' extract of the table. a daily batch.

Shrry8, You could name both instances the same, but the server names would have to be different if they are in the same domain which is a function of Windows not SQL Server. For example this is possible: ServerA\THI-SQL ServerB\THI-SQL Thank you, The MSSQLTIps.com Team