SQL-Server: Get Server – Edition – Instance Name with T-SQL
The following t-sql statement returns the server name, server instance, instance, edition & version of the running SQL-Server.
I.T. minded
The following t-sql statement returns the server name, server instance, instance, edition & version of the running SQL-Server.
When tracing with SQL profiler, it returned a query using ‘sp_cursorprepexec’. When executing the same query within SSMS, it failed with: sp_cursorprepexec: The value of the parameter XX is invalid. I managed to solve this by adding ‘+ 0x1000’ to…