Question on Apostrophe (') in a SQL Login

  • Hi,

    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 !!

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply