Hi,
I am new to SQL Server...and need to write a simple SQL store procedure.
There is a Table1 exported from Server1 to Server2. I need to schedule a procedure to run every month to replace Server2.Table1 with Server1.Table1...so I'll have the most current copy of a Table1 on my Server2.
Please give me any example for me to start off.
Thanks
I am new to SQL Server...and need to write a simple SQL store procedure.
There is a Table1 exported from Server1 to Server2. I need to schedule a procedure to run every month to replace Server2.Table1 with Server1.Table1...so I'll have the most current copy of a Table1 on my Server2.
Please give me any example for me to start off.
Thanks