Replace a SQL Server query with another before execution

Posted by Kiranu on Server Fault See other posts from Server Fault or by Kiranu
Published on 2012-08-31T15:24:22Z Indexed on 2012/08/31 15:41 UTC
Read the original article Hit count: 224

Filed under:

I am trying to work with a legacy application in SQL Server which at some point does the following query

SELECT serverproperty('EngineEdition') as sqledition

The server replies with 2 (which is the correct edition), but the application closes since the app demands to be run over SQL Server Express which is 4. We don't have access to the code and the developer is long gone.

Is there a way to configure SQL Server so that when this query is received it simply returns 4 and not the value of the property?

Thanks

© Server Fault or respective owner

Related posts about sql-server