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 derfloh 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
Joined
Aug 6, 2003
Messages
30
Location
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