The approach is commonly referred to as "row-level security" when dealing with SQL Server and unfortunately, unlike Oracle, it requires a home grown solution.

The standard way is to create a...

The way this can be done is to use something called cross-database ownership chaining. It's a security "feature" which is turned off by default because of the risk if one...

As previously mentioned, you can't block Windows based logins from inside SQL Server. SQL Server-based logins can be blocked, but not Windows-basde ones.

The rule in SQL Server is if security...

Lynn,

which version is installed on the respective servers? McAfee, Symantec, Trend Micro, other?

Unless you are crossing domains when crossing servers, Windows SIDs should map just fine, provided the logins were created previously on the new servers. A good thing to do is...

And if it's a domain account, you'll need to use a tool like Active Directory Domain Users and Computers (usually abbreviated ADUC).

I'm not aware of any product out there that scans BLOBs. You can force most virus scanners to scan a particular file, however, so if you can have it written...

The sa account shouldn't be used for an application. However, Greg is spot on as to the two reasons it could be.

Full Disclosure: I am a "Friend of Red Gate" and I've been a VIP for ApexSQL, meaning I've gotten the versions I have for free.

I use both Red Gate...

You need to be connected via the DAC. As to the exact means, I'd suggest you Google for it. No offense, but that's not something I'd post in a forum....

Another reason to be cautious with triggers is that any errors or rollbacks that occur in a trigger affect the entire transaction. Therefore, if your trigger is poorly written and...

Yes, you can restore master and get it back without restoring the other databases. The catch is what else changed since that backup?

Another option would be to try and...

The group ensures that any member of that group can connect to the server. Typically groups will then be used to grant access into the database. However, it doesn't have...

Agreed. When I was writing all the time on security, my later articles started including a section called references. My point for including those links was to give folks more...

Are there any interesting events in either the SQL Server error log or the system's application event log?