How do I disable SQLPrompt to test error 102?

cwchilders

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
END'. (Microsoft SQL Server, Error: 102)
PROFILER CAPTURE:

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

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

FROM

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
@spid[/img]

cwchilders

http://social.msdn.microsoft.com/Forums/getfile/292718

Manfred.Castro

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