What are the challenges you face when working across database platforms? Take the survey

How do I disable SQLPrompt to test error 102?

cwchilderscwchilders Posts: 4
edited June 6, 2013 4:05PM in SQL Prompt Previous Versions
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)

@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


Sign In or Register to comment.