1
Recently I moved to SQL Server 2012 from SQL Server 2005. Current scenario worked without any problem in SQL Server 2005.
1)Connect to server A
2)Open table X
3)Copy 3 columns(Clicking on Arrow in the designer and copy)
4)Connect to server B
5)Open table X in server B
6)Paste the columns (default values, descriptions and other things are transferred automatically)-again clicking on the arrow
On SQL Server 2012 I can copy columns between tables only in the current server.
How can I achieve it between different servers? Is there any setting or something?
I'm really annoyed by this one. I worked for years like this and became a habit of mine.
EDIT: I'm trying to copy columns definitions.