I believe you can have a DDL trigger fire on a logout event. You'd have to check to see if there were any others in with elevated rights (which you...

How does he map into the database? Do any of those mappings give him db_owner or db_ddladmin? Who is the database owned by? If it's owned by him, he maps...

Jack Corbett (8/13/2008)

---

When everything is in the same schema ownership chaining rules apply, so if I have schema1.proc1 and access schema1.table1 then all my user/role needs is exec permissions on...

JJ B (8/13/2008)

---

K. Brian Kelley (8/13/2008)

Ah, you mean delete all the data from the table.

I see the...

Your mail admins should be able to add additional SMTP addresses which correspond to your user accounts.

If you're seeing it in the Application event log (and you'll see it in the SQL Server error log), that means it is indeed a SQL Server-based login attempt. That's...

SQL Server hands off any Windows authentication to the SSPI. Unless there is a GPO to prevent cached credentials or it's set explicitly in the local security policy, the OS...

Jeffrey Williams (8/13/2008)

---

Andy Warren (8/13/2008)

---

Jeffrey, the schema idea is interesting, it's just felt like it was worth doing to me, all too often users need to cross schemas to get...

figaro (8/13/2008)

---

Andy Warren

...For applications I prefer that the connection be done using a single service account (unless we need a separate one that will be for read only) and I...

JJ B (8/13/2008)

---

In smaller organizations where you have the opportunity to know the people, this can certainly work. However, there's always the possibility in a small shop where the boss'...

The following KB article tells how to transfer logins between servers (or re-synching after a backup):

http://support.microsoft.com/kb/918992

The key to matching up logins and users is to ensure the SID matches up....

Gé Brander (6/6/2006)

---

Can you drop users when they are connected to a schema?

Can you drop a schema that owns objects?

To both questions the answer was 'No' for what I know....

That approach won't work because at the root of it all you're doing a backup from one server and restoring to another in a continuous fashion. If you want the...

Transfer the login according to the following:

How to transfer the logins and the passwords between instances of SQL Server 2005

This will ensure that the SIDs match up. The login will...

crever (8/5/2008)

---

You can write a logon trigger that checks the app signature. Only instead of checking for apps they're not supposed to be connecting with just check for yours...