Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- begin distributed tran
- begin try
- insert into [aliservername].[dbname].[dbo].[mytable] select col1, col2 from mytable;
- commit
- end try
- begin catch
- print 'fail'
- rollback tran
- end catch
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement