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 |
|
shifis
Posting Yak Master
157 Posts |
 Posted - 2008-07-14 : 16:32:45
|
| We are trying to run a scrip but in this line: ( this is in a create sp instruction)insert into SERVERMETLIFE3.[VL-0002DW].dbo.DimPeriodo values (3,2006,3,'Marzo') we receive the next error:The object name 'SERVERMETLIFE3.VL-0002DW.dbo.DimPeriodo' contains more than the maximum number of prefixes. The maximum is 2 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-14 : 16:36:04
|
| To answer your question though, run the insert statement on SERVERMETLIFE3 instead of through a linked server. You could try with OPENQUERY too.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
contains more than the maximum number of prefixes.