puterkrazy
Programmer
I need to create a table on a database on a linked server...
I get the following error when specifying the server:
create table server.db.dbo.test_table
(
col_test char(10)
)
Server: Msg 117, Level 15, State 1, Line 2
The object name 'server.db.dbo.' contains more than the maximum number of prefixes. The maximum is 2.
how can I create a table while specifying the server? thanks in advance!
I get the following error when specifying the server:
create table server.db.dbo.test_table
(
col_test char(10)
)
Server: Msg 117, Level 15, State 1, Line 2
The object name 'server.db.dbo.' contains more than the maximum number of prefixes. The maximum is 2.
how can I create a table while specifying the server? thanks in advance!