Is there a method in pymssql (or _mssql) that queries instance information from a connection, similar to the ODBC getinfo method?
For example, using pyodbc, I can query the server name property via conn.getinfo(pyodbc.SQL_SERVER_NAME), useful when the the SQL Server name differs from the server network name, after the box is renamed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is there a method in pymssql (or _mssql) that queries instance information from a connection, similar to the ODBC getinfo method?
For example, using pyodbc, I can query the server name property via conn.getinfo(pyodbc.SQL_SERVER_NAME), useful when the the SQL Server name differs from the server network name, after the box is renamed.
SELECT @@SERVERNAME may help.
http://msdn.microsoft.com/en-us/library/ms187944.aspx