how to make the contets of tables, case sensitive?

hi

the contents of sql server tables, aren't case sensitive.
and datas in them , are the same , whether they contains normal or caps letter.
for example Test = test=teST , and sql can't recogize the difference between them.

how can i make it sensitive?

thank u for your attention

Case-sensitivity is controlled by the collation that's being used by the server in the context of the query you're executing. I believe you can set the collation at the server, database or column level in SQL Server 2005. For more information, see the "Working with Collations" topic in Books Online.

Also, please post relational database engine questions to the SQL Database Engine forum (http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=93) where you're likely to get more prompt and accurate replies.

Raman Iyer
SQL Server Data Mining

sql

how to make the contents of tables, case sensitive?

hi

the contents of sql server tables, aren't case sensitive.
and datas in them , are the same , whether they contains normal or caps letter.
for example Test = test=teST , and sql can't recogize the difference between them.

how can i make it sensitive?

thank u for your attention

Case-sensitivity is controlled by the collation that's being used by the server in the context of the query you're executing. I believe you can set the collation at the server, database or column level in SQL Server 2005. For more information, see the "Working with Collations" topic in Books Online.

Also, please post relational database engine questions to the SQL Database Engine forum (http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=93) where you're likely to get more prompt and accurate replies.

Raman Iyer
SQL Server Data Mining

how to make the contents of sqlserver tables, case sensitive?

hi

the contents of sql server tables, aren't case sensitive.
and datas in them , are the same , whether they contains normal or caps letter.
for example Test = test=teST , and sql can't recogize the difference between them.

how can i make it sensitive?

thank u for your attention

Hi,
you may create a database with a case sesitive Collation and this will make the whole database case sestive including table names i.e.
select * from SYSOBJECTS will give you an error

how to make sensitive data encrypted in tables

Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.Encryption is available in SQL server 2005.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.|||See if this helps:
http://www.sqlsecurity.com/FAQs/SQL...55/Default.aspx
Which version of SQL Server are you using?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.|||We are using SQL Server 2000.
Thanks for the responses.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23B%23XkILiGHA.1276@.TK2MSFTNGP03.phx.gbl...
> See if this helps:
> http://www.sqlsecurity.com/FAQs/SQL...55/Default.aspx
> Which version of SQL Server are you using?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
> Any idea how to make sensitive data encrypted and make it readable for
> applications which uses it. I mean like password in syslogins table. Is
> there a way to do it in sql server or do i need to use any third party
> tools. Can you please list out if there are any tools.
> Thanks,
> Subbu.
>
>|||Then you'll have to encrypt the data before storing it in SQL Server. Check
out:
http://msdn.microsoft.com/library/d...ction-dpapi.asp
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:O0y$STLiGHA.2220@.TK2MSFTNGP05.phx.gbl...
We are using SQL Server 2000.
Thanks for the responses.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23B%23XkILiGHA.1276@.TK2MSFTNGP03.phx.gbl...
> See if this helps:
> http://www.sqlsecurity.com/FAQs/SQL...55/Default.aspx
> Which version of SQL Server are you using?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
> Any idea how to make sensitive data encrypted and make it readable for
> applications which uses it. I mean like password in syslogins table. Is
> there a way to do it in sql server or do i need to use any third party
> tools. Can you please list out if there are any tools.
> Thanks,
> Subbu.
>
>

how to make sensitive data encrypted in tables

Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.Encryption is available in SQL server 2005.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.|||See if this helps:
http://www.sqlsecurity.com/FAQs/SQLServerFAQ/tabid/55/Default.aspx
Which version of SQL Server are you using?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.|||We are using SQL Server 2000.
Thanks for the responses.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23B%23XkILiGHA.1276@.TK2MSFTNGP03.phx.gbl...
> See if this helps:
> http://www.sqlsecurity.com/FAQs/SQLServerFAQ/tabid/55/Default.aspx
> Which version of SQL Server are you using?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
> Any idea how to make sensitive data encrypted and make it readable for
> applications which uses it. I mean like password in syslogins table. Is
> there a way to do it in sql server or do i need to use any third party
> tools. Can you please list out if there are any tools.
> Thanks,
> Subbu.
>
>|||Then you'll have to encrypt the data before storing it in SQL Server. Check
out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsecure/html/windataprotection-dpapi.asp
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:O0y$STLiGHA.2220@.TK2MSFTNGP05.phx.gbl...
We are using SQL Server 2000.
Thanks for the responses.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23B%23XkILiGHA.1276@.TK2MSFTNGP03.phx.gbl...
> See if this helps:
> http://www.sqlsecurity.com/FAQs/SQLServerFAQ/tabid/55/Default.aspx
> Which version of SQL Server are you using?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
> Any idea how to make sensitive data encrypted and make it readable for
> applications which uses it. I mean like password in syslogins table. Is
> there a way to do it in sql server or do i need to use any third party
> tools. Can you please list out if there are any tools.
> Thanks,
> Subbu.
>
>

how to make password field case sensitive in sql server 2005

Hi,

SELECT UserID, UserName, Password, PublisherID, Currency
FROM [User]
WHERE (Password = 'Anitha') I am using the above mentioned it is working but int the password field i had given it as anitha. Now the querry is retriving the record for anitha, it shouldnot happen. The querry should retrive the record of anitha only for where condition anitha and not for Anitha or ANITHA etc..

Thanks

Vishwanath

Convert the password field and password value to varbinary and compare if they are equal.

Here is the code:

select

*from userswhere UserName='Nilesh'Andcast(passwordasvarbinary(20))=cast(N'password'asvarbinary(20))

The usename is not case sensitive but password is.

|||

hi Vishwanath,

its good practise to store passwords in encoded/encrypted format. what i do is use a custom encryption function which uses our own logic to encrypt each character and store it.

to add what Nilesh has mentioned read this linkhttp://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

Hope it helps.

regards,

Satish.

|||

Hi satish,

now its working fine, but when i choose the collation property from that password field and changed it to bin format then at that it gave some warning message saying that some of the data will be lost, but when i choose yes i couldnt experience any such loss of data. Everything is working fine..

Thnaks

Vishwanath

|||

ohk sounds cool.

please mark the post which helped you as answered, it will give credit to answerer and post will be resolved.

thanks,

satish.