<div>
Try terminating the line before this statement with a semi colon (;). Sometimes it is the case. 
</div>


Try terminating the line before this statement with a semi colon (;). Sometimes it is the case.

<div>
As previously indicated the &quot;EXEC&quot; is required (no point please)
</div>


As previously indicated the "EXEC" is required (no point please)

<div>
<div class="content wysiwyg-content">
In SQL Server 2008, I hae the following line just before adding the linked server back:<br />
<br />
sp_dropserver 'SvrExcel', 'droplogins'<br />
<br />
I realize I could check for the existence of SvrExcel, but this named server always exists for me because whenever I do one of many small data manipulation jobs, I overwrite it with the next one. &nbsp;I get the following message when I run it by executing the whole sql query, and also when I use the debug feature. &nbsp;<br />
<br />
Msg 102, Level 15, State 1, Line 19<br />
Incorrect syntax near 'sp_dropserver'.<br />
<br />
However, I do not get the error message, and the command is successful, when I merely select the line and execute the one line.<br />
<br />
Any clue as to why it would be showing an error while executing the whole query but not when executing the one line?<br />
<br />
TIA<br />
<br />
jr
</div>
</div>


In SQL Server 2008, I hae the following line just before adding the linked server back:

sp_dropserver 'SvrExcel', 'droplogins'

I realize I could check for the existence of SvrExcel, but this named server always exists for me because whenever I do one of many small data manipulation jobs, I overwrite it with the next one.  I get the following message when I run it by executing the whole sql query, and also when I use the debug feature.  

Msg 102, Level 15, State 1, Line 19
Incorrect syntax near 'sp_dropserver'.

However, I do not get the error message, and the command is successful, when I merely select the line and execute the one line.

Any clue as to why it would be showing an error while executing the whole query but not when executing the one line?

TIA

jr

sql error on sp_dropserver while running whole query or debugging, but not when executing the individual line

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.