Actually, that may not be the case. Some of the tools, can be run even without a full client installation, if they are copied over or accessed from a network...

In Books Online there is the CREATE TRIGGER topic. You'll be wanting the AFTER triggers (which fire after the query operation and do not interrupt it, unless you rollback everything...

Malcolm Daughtree (11/21/2007)

---

Ummmm seeing as you can't detach system databases you can't do it to Master. And if you are trying or needing to you are in a...

Nothing at all. However, if you can script out the logins and recreate them with identical SIDs, that saves you a tremendous amount of...

Yup. Steve dumped some high-quality chum into the shark tank today. But...

Yes, via a trigger. However, the trigger is considered part of that transaction so if the trigger fails and is rolled back, so is the original query.

If the permissions are assigned to an app role, that app role must be activated via sp_setapprole. However, doing so causes the user's security context to become the app role...

Have you built in any objects, such as stored procedures in the master database? If not, and all you have to move is the users, there are ways to do...

The Permissions topic lists all the potential permissions in a useful chart. It includes permissions like ALTER TRACE (object: server, as previously mentioned) which you won't find in the Permissions...

Unfortunately, no. When you go the linked server route because you've got to cross servers, you're going to have to use the four part naming convention.

EDIT: Actually, create a database...

1) Does the SQL Server service account match the SQL Server Agent service account?

2) If so, have you followed the steps in Books Online under the section, "Configuring Mail...

In the security arena we have a concept called Defense in Depth. It's a rather simple idea: have several layers of protection against a potential compromise.

For instance, having the...

aureolin (11/19/2007)

---

And one place it can be helpful is if you have a system where you enter in an address. The system auto looks up using Full Text or some...

Take a look at the EncryptByPassPhrase and DecryptByPassPhrase functions. The Books Online links (which have examples):

EncryptByPassPhrase()

DecryptByPassPhrase()

Make sure whoever you want to be the owner of the database doesn't already exist as a user of the database. If so, you'll have to delete the user mapping....