How do I disable SQLPrompt to test error 102?

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

How do I disable SQLPrompt to test error 102?

Postby cwchilders » Wed Jun 05, 2013 6:28 pm

I can connect with sqlcmd successfully. In SSMS with SQLPrompt5,
connecting over VPN to remote SQL2008R2--Microsoft SQL Server, Error: 102.
The ??? marks are reported as 'extended characters' in the SSMS error message. I suspect this is a SQLProfiler select query--Is that your code in the PROFILE CAPTURE below?

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Incorrect syntax near 'W??'.
Incorrect syntax near 'SmoEnabled'.
Unclosed quotation mark after the character string '
END'. (Microsoft SQL Server, Error: 102)

IF (@@microsoftversion / 0x01000000) >= 9 AND ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1
SELECT se.is_admin_endpoint AS N'AdminConnection',

(SELECT CAST(cfg.value AS bit) AS [ConfigValue]


sys.configurations AS cfg WHERE configuration_id=16387)
AS N'SmoEnabled'
FROM sys.endpoints se
INNER JOIN sys.dm_exec_connections dmc ON dmc.endpoint_id = se.endpoint_id
W????????????????????? dmc.session_id = @@spid[/img]
Posts: 3
Joined: Thu Jul 12, 2007 9:00 pm

Error Image capture

Postby cwchilders » Wed Jun 05, 2013 6:30 pm

Posts: 3
Joined: Thu Jul 12, 2007 9:00 pm

Postby Manfred.Castro » Thu Jun 06, 2013 9:05 pm

If you don't want to uninstall the tool, you can try renaming the addin file located in:
C:\\ProgramData\\Microsoft\\SQL Server Management Studio\\11.0\\Addins

You can just append the extension with something like .old.
That should remove the addin from SSMS
Manfred Castro
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests