As has been previously said, I'd look at a 3rd party product like Red Gate SQL Backup (full disclosure, I'm a Friend of Red Gate) because you can encrypt the...

If the users aren't getting in via another security group, here's my recommendation:

1) remove the security group with the DENY. SQL Server is based on an explicit permission model. In...

This can be done with proper use of cross-database ownership chaining. It's one of the few times you actually want to consider such an option. However, this isn't a simple...

If your Windows domain already blocks re-use of the last three passwords, simply enable password policy enforcement on the logins. You'll accomplish the same thing without having to build anything....

Also, SQL Server 2005 and above will honor the password policies that the OS has. It can't set its own. You can configure a SQL login to use these password...

Syslogin is not a real table. Just want to make that clear before we go forward. It doesn't affect anything, but if you're talking SQL Server 2005, you should be...

Can you detail the login security you set up for the linked server connections?

I believe this wording first showed up in the 2005 version of SQL Server. It may have to do with how the permissions work with respect to the schema securables.

MS DTC doesn't play into this, so that configuration is completely coincidental.

How are the two domains related? Same forest? Different forests? Parent-child domain?

apat (3/16/2012)

---

And there is is selected on Deny for all the permissions for all the users. And this is because we did not want to give permission for any user...

Is there a DENY at the database or schema level where the table is?

I'm not following here. You shouldn't never lose the database master key. You should be protecting it in accordance with the guidance in Books Online (BACKUP MASTER KEY). In this...

You're going to need to use SQL Server authentication as you don't have a trusted relationship between the two systems. More here:

Books Online: Replication Security Best Practices

IP addressing is really...

I'm adding on to what has already been said.

The key here is they have the ability to alter the stored procedure. In production, no developer should ever have the ability...

Agreed, Denny's is the most recent in the field.