Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question on Apostrophe (') in a SQL Login Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 8:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, May 12, 2014 1:53 PM
Points: 69, Visits: 187
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 !!
Post #1496922
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse