Hello Jacob, Yes you are correct, Is it something you are saying changing the ISOLATION Leve to READ COMMITED SNAPSHOT for that particular user with loggon trigger ? Because, I can not change the default isolation level of database to READ COMMIT...

Hi Mark, Users are not chaging ISOLATION Level, we queries executed by defaulted with given Isolation level when any one is using that DB user. Regards, Chirag...

Requirement is that "we have created ODC Connection for Users to run Pivor during Day time to run on warehouse server. We have created specific user for this ODC. Now when users are running queries through this ODC connection it generates lockwait on D...

Hi All, We have a requirement of binding Transaction ISOLATION Level with Database User. Kindly let me know if there is any way to bind DB User with Isolation level so that whenver some one runs query with that particular user it runs with specific Iso...

Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup: Always run this report with the most recent data, Do not cache temporary c...

I like the integration of SSIS and DQS. It's a great way to automate cleansing of data. while exploring further, I learned that currently, DQS does not expose matching functionality for SSIS to use but I guess I'll have to try Fuzzy Grouping Transfor...

I like the integration of SSIS and DQS. It's a great way to automate cleansing of data. while exploring further, I learned that currently, DQS does not expose matching functionality for SSIS to use but I guess I'll have to try Fuzzy Grouping Transfor...

SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say –...

SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say –...

Hi Alpesh, Can you provide more information on option 3 and 4 ? So, that if some one wants to utlize that option it would be easy for him/her. Thanks, Chirag...