Let's take these in order:

1. Yes, using triggers you can enforce encryption on the fields without modifying the application. However, as Seth has pointed out, you get stuck trying to...

Denesh Naidoo (6/24/2010)

---

Hi All,

I have a SQL 2008 Enterprize Edition server on a Domain.

I have certain Doamin users that are added to the Local Administrator group on this server. When...

Nice Marmot (7/7/2010)

---

AFAIK when a computer joins a domain, the Domain Admins group is added to the <SERVERNAME>\Administrators group. So when a SQL Server is in a domain, this makes...

The issue that you're facing is something called ownership chaining. Normally it's a good thing because it means I can use a stored procedure to reference a base table and...

There is nothing specific at the database level which can be used to restrict such access. Within SQL Server (and only 2005 SP2 and up) you're limited to a LOGON...

I don't believe so from the server's perspective, but that doesn't mean some other process isn't.

I'd do this in development first:

- Use file permissions to block access to osql

-...

This is a name resolution issue (networking configuration related). Give him the IP address and have him try to connect via IP,port. If he's able to do so, then he...

No.

When the connection is made to SQL Server, based on the way the login packet is structured, only the SQL Server login information is passed. There's no support for...

Do you have a PKI infrastructure within your organization? If not, what might be a better option is to use an IPSEC policy to configure a secure channel on the...

Try this... create a SQL login that has access to both databases. Give it specific access to what it needs in both database #1 and database #2. You can even...

Credentials are a better solution in SQL Server 2005/2008. They can be tightened down per actual login.

What was tried?

If your account is a member of the sysadmin fixed server role, here are the execution contexts:

- Stored procedure run from SSMS -> your user context

- Stored procedure run by...

box4garbage (5/11/2010)

---

It looks like any meeting is just a waste of time. I can hardly imagine a problem or theme for meeting which is impossible to solve via messenger/email or...

The securityadmin fixed server role only has the ability to grant permissions at the database level, which roughly corresponds to CONNECT DATABASE and the like. Assigning users to roles is...