Are SQL Server 2008 case-sensitive?

Question

Post reply

Are SQL Server 2008 case-sensitive?

tale103108

SSC Enthusiast

Points: 118
More actions
February 13, 2012 at 12:56 pm

#264503

OS: Windows Server 2008 R2 (64-bit)
DB: SQL Server 2008 (64-bit)
I know that passwords are case-senstive. But are SQL Server 2008 logins case-sensitive (using SQL Server Authentification)?
Cheers!

Viewing 6 posts - 1 through 6 (of 6 total)

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

Sean Lange SSC Guru Points: 286609 More actions · Answer 1

The UserName is not case sensitive. By far the quickest and easiest way to answer this is to simply try connecting. 😀

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Sean Lange SSC Guru Points: 286609 More actions · Answer 2

Then again...I am not sure if the server collation comes into play here. Not using or even having case sensitive instance I can't test that as easily.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jared SSC Guru Points: 61793 More actions · Answer 3

tale103108 (2/13/2012)
OS: Windows Server 2008 R2 (64-bit)
DB: SQL Server 2008 (64-bit)
I know that passwords are case-senstive. But are SQL Server 2008 logins case-sensitive (using SQL Server Authentification)?
Cheers!

It depends on the collation chosen during installation of the instance. By default, they are not case-sensitive.

Jared
CE - Microsoft

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

To determine Server collation and/or other collation setting try this:

--Server collation

SELECT SERVERPROPERTY ('collation') AS 'Server collation'

--Database collation

SELECT DATABASEPROPERTYEX('Northwind', 'Collation') DB_SQLCollation;

--Collations used in tables

SELECT OBJECT_NAME(Object_Id) AS 'Table Name',name AS 'Column name', collation_name

FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID

FROM sys.objects WHERE type = 'U')

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

tale103108 SSC Enthusiast Points: 118 More actions · Answer 5

I have verified that -- at least in my environment -- the logins are case-insensitive. Cheers!:-)