I have a Devnet SQL Server which handles a SQL Login name O'Brian and it automatically replaces it like this O''Brian.
However, the same is not happening in the production environment SQL Server. When an application is accessed, the Sql Login is passed as O'Brian which throws as error.
What could be the difference in the Sql server settings in Devnet environment which handles apostrophe correctly?
Need Help !!