<div>
try [servername].[databasename<wbr />].[dbo].[t<wbr />ablename]
</div>


try [servername].[databasename].[dbo].[tablename]

<div>
<div class="content wysiwyg-content">
<br />
I get the error &quot;The object name 'txtsrv...test#txt' contains more than the maximum number of prefixes. The maximum is 2&quot; when i run the following:-<br />
<br />
DECLARE @table nvarchar(1000)<br />
DECLARE @SQL nvarchar (1000)<br />
SELECT @SQL = ' txtsrv...[test#txt]'<br />
SELECT @table = 'DROP TABLE' + @SQL <br />
EXEC sp_executeSQL @table<br />
<br />
What do I need to change in order to delete the file?<br />
<br />
Thanks!
</div>
</div>



I get the error "The object name 'txtsrv...test#txt' contains more than the maximum number of prefixes. The maximum is 2" when i run the following:-

DECLARE @table nvarchar(1000)
DECLARE @SQL nvarchar (1000)
SELECT @SQL = ' txtsrv...[test#txt]'
SELECT @table = 'DROP TABLE' + @SQL 
EXEC sp_executeSQL @table

What do I need to change in order to delete the file?

Thanks!

Linked Server - Drop Table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.