Hi,

The DDL Trigger itself solved my issue. I didnot go for the minmal rights.

Thanks,

Balaji.

Hi,

The DDL Trigger itself solved my issue. I didnot go for the minmal rights.

Thanks,

Balaji.

Thanx ALZDBA, Its working fine.

Thanks,

Balaji.

Thanks for your inputs Brian and ALZDBA.

I will check these options and revert back.

Thanks,

Balaji.

Hi,

I dont have any specific reason to use Matrix. I thought we cannot acheive this using Tables as "Gross Sales, Net Sales and Tax are common for an Item but...

Hi,

I want to deny few users from droppring/deleting the triggers in SQL Server 2005.

Any help is appreciated....

Thanks,

Balaji

Hi,

We hope your suggestion will help to us to resolve the issue. We will try to implement and update you.

Thanks,

Balaji.

Hi,

We tried with "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE" and still any no. of users are able to read the same record from the table.

Here is our Business requirement:

We have...

Rathina,

Can you please be bit elaborate with your point. Am not able to understand about the SQL entry which you are saying...

Thanks,

Balaji.

Rathina,

I have checked the authentication mode, both Windows and SQL Server Authentication mode is enabled. Also we are able to connect with the server if we add the domain accounts...

Hi,

Thanks for the response. Actually the users or user group was not newly added. It was already exisitng and it was working fine till 2 days back. We got into...

Thanks for your suggestions. Your assumption is correct and i will try to implement the report as per your suggestions...

Thanks,

Balaji.