Hi

This is sravani . I have a doubt .. What is MSSQL server case sensitive and MSSQL server case insensitive . I have to run installation shied on above two combinations of MSSQL server. Is it requires 2 times to instal the MSSQL server software seperately for case sensitive and case insensitiveExample: If have a Customers table and a record has last_name = "Bob", then:
Select * from customers where last_name = 'bob'
will return that record if it's case-insensitive, otherwise not.|||

Quote:

Originally Posted by sravani1227

This is sravani . I have a doubt .. What is MSSQL server case sensitive and MSSQL server case insensitive . I have to run installation shied on above two combinations of MSSQL server. Is it requires 2 times to instal the MSSQL server software seperately for case sensitive and case insensitive

Hi,
You don't need to install MSSQL server two times intead you have to change
default collation of your databse .
you will use COLLATE SQL_Latin1_General_CP1_CS_AS to make your search case sensitive.

HelpSQL Agent Security

We have sensitive data that requires the builtin\administrators group be removed so domain admins are unable to see data. When we do this, SQL can continue to run under the local system account, but the SQL Agent cannot.

Does anyone else have a solution that will lockout NT admins (both local and domain) and allow both SQL and the SQL AGENT to run properly?

TIA

Ryan HuntDid you give the new domain account sysadmin rights?

And configure it to start with that account?|||Thanks for the response. I ended up just creating a local admin account for the agent with specific SA rights to the server. Then, had the only department allowed to have access to the data change the password. This seems like the best choice...

Thanks