I have used the XML approach to do some integration between databases. I would pass to an SP in a different database a set of reference numbers as an...

First, I'm in no way affiliated with SafeNet. But yesterday I watched a webinar about their Luna SA product that may do what you want. At this this...

Security is expensive, period. And to what degree you implement security to protect your data and systems determines the amount you spend and how well you are protected. ...

Rupashri, thanks for the reply. If I understand you correctly, this would yield a trusted sub-system model, which is not what we are after. We need a delegation...

If you deal with senestive data, the cost could be huge if a breach or release of that data occurs. The problem is companies don't want to pay for...

Another tool to look at. They offer a 30-day eval and it looks to be a promising product. I played with it today and developing the rule sets...

Thanks for the link to the videos.

Good work Brian. This explanation helps not only in the SQL Server world, but anywhere where Kerberos is required. At first glance and try, Kerberos is a pain...

I see this as a way to better ensure auditing of data changes. In the past, we have had to build "history" tables and implement triggers on the base...

Lenny, you are right on. I found this post about this problem. I dropped the syn and added it back using a script without the server name and...

Did that, doesn't help.

Thanks for the quick reply.

In my case, I have Database #1 with the proc. Database #2 is on the same server and is going to use #1's proc. ...

I would like to get a feel from the author and others about a different type of logging. One requirement I have seen is that because of privacy issues,...

Could this trigger be scoped at a database level rather than at the server level?

Thank you for the idea. We will give that a try! Have a good weekend.