mpdillon (9/27/2016)
Update. It does not seem to be a permissions issue. I believe it is a syntax issue.Truncate Table [FS-JirEMSQL].JIREM10.dbo.JIRABConcentration Fails
But
Truncate Table JIREM10.dbo.JIRABConcentration is successful.
It seems to dislike the full qualification of the connection. Does anyone have an idea what is the correct way to fully qualify the table, including the Server name?
Thanks.
When using 4 part naming the first value is NOT the server name, it is the name of the link server. If this is on the same server there is no benefit of using the link server name. And if it is on the same database there is no need to specify the database name (although it is fine). And of course if you have already truncated the table why is there is a need to truncate it again?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/