Replace a SQL Server query with another before execution
- by Kiranu
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