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

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
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]

Comments

Sign In or Register to comment.