Home Forums SQL Server 7,2000 T-SQL create a table on a 2nd SQL server via linked server RE: create a table on a 2nd SQL server via linked server

  • I'd thought of that but you're only allowed a maximum of 2 prefixes, i'd need 3-4 [linkedserver].database.owner.table.

    Unless I can get away with just using linkedserver.table and set up the linked server with the right default DB and owner etc, i'll give it a try