Radjammin2
Active Member
Ok This isn't the hardest question but I guess for me it just never came up. I need to copy a table from 1 productions SQL server to another. Now I have done DTS Database copys but that grabs all the tables, and I have done insert into select * from source table.
But What about a single table from one SQL server to another? So simple it's hard? I know I could use R98403
but I guess I just wanted to know the SQL solution for my own Edification..!
But What about a single table from one SQL server to another? So simple it's hard? I know I could use R98403
but I guess I just wanted to know the SQL solution for my own Edification..!