You can not do that !
Create a linked server to the target SQL database server. Search SQL Books Online for "sp_addlinkedserver".
One that is done, use the following DDL according to your need:
create table linkedservername.targetdatabasename.dbo.test(
id int,name char(20)) .....
________________________________________________________________________________
If you do not like change, get out of the IT business...