Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
soorajtnpki
Posting Yak Master
231 Posts |
 Posted - 2008-12-09 : 23:38:15
|
| hi alli run the query select * into [ma-as-3].test.dbo.tabl23 from tbl_employeesand got following error The object name 'ma-as-3.test.dbo.tabl23' contains more than the maximum number of prefixes. The maximum is 2.why this errortanx in advance... |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-12-10 : 00:29:16
|
| the fully qualified format is [database name].[owner].[object]Is the database name [ma-as-3-test] perhaps?Nathan Skerl |
 |
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2008-12-10 : 01:01:42
|
| no it is[ma-as-3] is server name [ma-as-3].test.dbo.tabl23 server.database.user.table ok |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-12-10 : 01:17:06
|
| oh, my mistake. i read your post too fast. Is ma-as-3 a linked server? I dont believe you can use select into through a linked server. You will have to create the destination table first then use insert into [server].[database].[owner].[table]Nathan Skerl |
|
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2008-12-10 : 01:18:38
|
| ys it is a linked one. |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-12-10 : 01:29:44
|
| or use select into from the ma-as-3 server and "pull" the data from the source through a linked server in the opposite direction.Nathan Skerl |
|
|
|
|
|
|
query doubt