Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating table in different db

Status
Not open for further replies.

puterkrazy

Programmer
Aug 6, 2003
30
0
0
US
I am trying to create a table in another database, why am i getting this error and how can I avoid it? Thanks!

create table dbsrv.db.dbo.table_name
(
col_test char(10)
)

The object name 'dbsrv.db.dbo.table_name.' contains more than the maximum number of prefixes. The maximum is 2.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top