If the trace is running on server dd2 then the trace file is being created on that server so it does not exists on dd1. You could set the...

Bah! Mangers!

The code you are writing should work. I created the following in AdventureWorks and it works fine:

Trigger

[font="Courier New"]

CREATE TRIGGER HumanResources.Department_Upd

   ON  HumanResources.Department

   AFTER UPDATE

AS

BEGIN

  ...

The Senior DBA only needed to grant ALTER TRACE rights.

What is the hardware (CPU, RAM, Disk Setup)?

Sure execute sp_helptext [proc name]. It will really be a pain to try to parse that result to find column names since there can be n selects in...

I don't think that there is a way to tell what SQL was executed to cause a trigger to fire. The best way to maintain that table is to...

There is nothing in the Information_Schema unless you want to parse the text of the sp. You could just send in criteria, if there are any, that you know...

I don't think that there is a builtin way to restrict the # of users that run a report concurrently. I think you will have to go with checking...

Has the production database been setup yet? If not you can do a backup of the QA database and restore it on the production server and now it is...

Could be blocking. What version of SQL Server are you running? If it is MSDE it could be that you need to get a pay version as MSDE...

I'm with you on that. That's why I try to post regularly. So I can learn something.

From SQL Server 2000 BOL sp_start_job:

"Permissions

Execute permissions default to the public role in the msdb database. A user who can execute this procedure and is a member of the sysadmin...

In your test data there is no way to do a single update because any criteria you use will update all the aa with a distinct bb value. I...

When setting up a database mail profile you only setup 1 account as the FROM account. I think what you want is to set up an Operator to email...

Grant,

Good question. I found the chapter of the book on MSDN on-line and here is the paragraph:

"The file provider is designed with a guarantee that no event data...