blocks|key|147302|text|正确的由四部分组成的表名是server.database.schema.tablename+-你有一些多余的部分。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|147303|看起来表名是OPC.WriteRequests？如果是，则必须使用方括号：SQL05.ManufacturingPortal.dbo.[OPC.WriteRequests]|offset|length|style|CODE|147304|但也许你只是名字的某一部分是错误的？|147305|entityMap^0|0|11|1D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

Correct four-part table name is server.database.schema.tablename - you have some excess parts there.

Looks like table name is OPC.WriteRequests? If yes, then you have to use brackets: <code>SQL05.ManufacturingPortal.dbo.[OPC.WriteRequests]</code>

But maybe you just have some part of name incorrect?

blocks|key|150024|text|在我的例子中，它实际上希望在INTO表所在的服务器上运行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|150025|SELECT+*+
INTO+[database].[schema].[table]+
FROM+[server].[database].[schema].[table]|code-block|syntax|javascript|150026|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In my case, it actually wanted to be run on the server where the INTO table would live:

<pre><code>SELECT * 
INTO [database].[schema].[table] 
FROM [server].[database].[schema].[table]
</code></pre>

blocks|key|145979|text|您收到该错误的原因是因为您使用的名称无效。您似乎引用了两个架构：dbo和OPC。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|145980|有效语法为server_name.database_name.schema_name.object_name，与INSERT的MSDN+article上引用的语法相同。|145981|删除不正确的架构，然后重试。|145982|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms174335.aspx^0|W|3|10|3|0|5|1D|1K|6|1R|C|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|H|3|I|5|6|7|14|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

The reason you are receiving the error is because you are not using a valid name. You appear to be referencing two schemata, <code>dbo</code> and <code>OPC</code>.

The valid syntax is <code>server_name.database_name.schema_name.object_name</code> as referenced on the <a href="http://msdn.microsoft.com/en-us/library/ms174335.aspx" rel="noreferrer">MSDN article</a> for <code>INSERT</code>.

Remove the incorrect schema and try again.

blocks|key|148505|text|我使用的一切都是正确的，但问题仍然存在。我的命令如下|type|unstyled|depth|inlineStyleRanges|entityRanges|data|148506|select+*+into+server.database.schema.table+from+table2|code-block|syntax|javascript|148507|我首先在服务器中创建表，然后使用insert+into语句解决了这个问题，该语句的执行没有任何问题|148508|Create+Table...........
Insert+into+server.database.schema.table++select+*+from+table2|148509|谢谢，Sree|148510|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I was using everything correct still the issue persisted. My command was like below

<pre><code>select * into server.database.schema.table from table2
</code></pre>

I resolved it by creating the table in the server first and then used the insert into statement which executed without issues

<pre><code>Create Table...........
Insert into server.database.schema.table select * from table2
</code></pre>

Thanks,
Sree

blocks|key|2726916|text|与braket+"[]“一起使用作为名称和远程数据库服务器，如下所示。87.247.678.80,1666.danesfe.admin1.homefarsi|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2726917|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

use with braket "[]" for name and remote database server like this.
[87.247.678.80,1666].[danesfe].[admin1].[homefarsi]

blocks|key|146002|text|当我尝试执行下面的代码(Make+table)时，我也遇到了类似的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|146003|"into+SalesCube_temp.SalesCube_temp.dbo.ALL_SUPPLIER_SALES_METRICS_I"|offset|length|style|CODE|146004|然后我意识到我使用了不正确的语法，然后将其更正为|146005|"into+SalesCube_temp.dbo.ALL_SUPPLIER_SALES_METRICS_I"|146006|成功了，我的故事结束了。但我花了将近10到15分钟|146007|希望它能帮助到一些人。|146008|entityMap^0|0|0|1X|0|0|0|1I|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@$D|X|E|Y|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|Z|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|10|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|Q|$]]

I had similar issues where I was getting the message when I was trying to execute the following code(make table)

<code>"into SalesCube_temp.SalesCube_temp.dbo.ALL_SUPPLIER_SALES_METRICS_I"</code>

I then Realized that I was using the incorrect Syntax and then rectified as 

<code>"into SalesCube_temp.dbo.ALL_SUPPLIER_SALES_METRICS_I"</code>

IT WORKED, END OF MY STORY. But I spent nearly 10 to 15 minutes tr

Hope it will help somebody.

blocks|key|148607|text|我的(继承的)代码使用string.Format并传递服务器名称，例如|type|unstyled|depth|inlineStyleRanges|entityRanges|data|148608|string.Format("Select+*+from+{0}.AwesomeDB.dbo.EpicTable",+WebConfigurationManager.AppSettings["MuhServerName"]);|code-block|syntax|javascript|148609|但是在配置中，"MuhServerName“是"MyServer.MyDomain.com/MyInstance"，所以它被加载为|148610|Select+*+from+MyServer.MyDomain.com/MyInstance.AwesomeDB.dbo.EpicTable|148611|而不是|148612|Select+*+from+[MyServer.MyDomain.com/MyInstance].AwesomeDB.dbo.EpicTable|148613|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

My (inherited) code was using string.Format and passing the server name, eg
<pre><code>string.Format(&quot;Select * from {0}.AwesomeDB.dbo.EpicTable&quot;, WebConfigurationManager.AppSettings[&quot;MuhServerName&quot;]);
</code></pre>
but in the config, &quot;MuhServerName&quot; was &quot;MyServer.MyDomain.com/MyInstance&quot;, so it was loaded as
<pre><code>Select * from MyServer.MyDomain.com/MyInstance.AwesomeDB.dbo.EpicTable
</code></pre>
instead of
<pre><code>Select * from [MyServer.MyDomain.com/MyInstance].AwesomeDB.dbo.EpicTable
</code></pre>

blocks|key|148615|text|我基本上解决了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|148616|CREATE+VIEW+view_LINKSERVERTABLE+AS+++
SELECT+*+FROM+LINKSERVERNAME.DBNAME.DBO.TABLENAME|code-block|syntax|javascript|148617|然后|148618|++INSERT+INTO+view_LINKSERVERTABLE+SELECT+*+FROM+database|148619|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I resolved basicly.
<pre><code>CREATE VIEW view_LINKSERVERTABLE AS 
SELECT * FROM LINKSERVERNAME.DBNAME.DBO.TABLENAME
</code></pre>
and then
<pre><code> INSERT INTO view_LINKSERVERTABLE SELECT * FROM database
</code></pre>

blocks|key|147320|text|请从头开始更换表格，并尝试以正常方式插入|type|unstyled|depth|inlineStyleRanges|entityRanges|data|147321|Use+ManufacturingPortal+

IF+@Builds+>+0

+++BEGIN

+++++++SET+@DPU+=+@Failures+/+@Builds

+++++++INSERT+INTO+OPC.WriteRequests+(ID,+RegisterID,+Value,+RequestedDate,+IsCompleted)
+++++++VALUES(@PLCID,+'F8:10'+,+CAST(@DPU+AS+NUMERIC(10,2)),+GETDATE(),+0)++++

+++END+|code-block|syntax|javascript|147322|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Please change the tables from the start and try to insert with the normal way

<pre><code>Use ManufacturingPortal 

IF @Builds &gt; 0

 BEGIN

 SET @DPU = @Failures / @Builds

 INSERT INTO OPC.WriteRequests (ID, RegisterID, Value, RequestedDate, IsCompleted)
 VALUES(@PLCID, 'F8:10' , CAST(@DPU AS NUMERIC(10,2)), GETDATE(), 0) 

 END 
</code></pre>

blocks|key|2939235|text|我也有同样的问题。问题是由于以下错误造成的:我没有将textbox1.text作为参数传递给从代码隐藏调用的查询，而是传递了textbox1。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2939236|希望能有所帮助|2939237|entityMap^0|Q|D|1Q|8|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

I had the same issue.
The problem was due to the following mistake: instead of passing <code>textbox1.text</code> as argument to the query being called from code-behind i passed <code>textbox1</code>.

Hope it helps

My stored procedure is trying to write a record in to a database on another Server. The statement is here:
<pre><code>IF @Builds &gt; 0
 BEGIN
 SET @DPU = @Failures / @Builds
 INSERT INTO SQL05.ManufacturingPortal.dbo.OPC.WriteRequests (ID, RegisterID, Value, RequestedDate, IsCompleted)
 VALUES(@PLCID, 'F8:10' , CAST(@DPU AS NUMERIC(10,2)), GETDATE(), 0) 
 END 
</code></pre>
However when I try to create the stored procedure - I get the following error:
<blockquote>
The object name 'SQL05.ManufacturingPortal.dbo.OPC.WriteRequests' contains more than the maximum number of prefixes. The maximum is 3.
</blockquote>
I have tried creating an alias of Server.DB.DBO to shorten the number of prefixes however seem to be implementing this wrong.
I cannot change my database schema on the target database. Any suggestions on how I can get around this?
Thanks

The object name contains more than the maximum number of prefixes. The maximum is 3

我的存储过程正在尝试将一条记录写入另一台服务器上的数据库。声明如下：IF @Builds > 0   BEGIN        SET @DPU = @Failures / @Builds        INSERT INTO SQL05.ManufacturingPortal.dbo.OPC.WriteRequests (ID, RegisterID, Value, RequestedDate,

问对象名称包含的前缀超过了最大数量。最大值为3
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问对象名称包含的前缀超过了最大数量。最大值为3EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问对象名称包含的前缀超过了最大数量。最大值为3
EN