Thanks for the reply CELKO!. How do you troubleshoot the following error message

Msg 8672, Level 16, State 1, Line 1

The MERGE statement attempted to UPDATE or DELETE the same...

Thanks everyone....Joe, thanks for the insight.

What i mean is IF you had to set up your application,such that it passes a user&password to AD which in turn is set up as a User access to...

ok john, i have a question for you. what would you give in your connection string(windows application) if your application was set up as a user on the AD and...

Why don't u invest in a DBA? Take my advice, make your life simple, hire a DBA.

As for the solution, two options:

1. create an application role.

2. create a user on...

Thats a good question, Anybody that can throw some light on this !!??