Chris Morris (7/25/2008)

---

The recommended method which Jack posted (where are ya, Jack?) will always run fast because the column in the WHERE clause on which it operates isn't subjected to...

Can you attach the rdl file to the thread so I can see how you are trying to do the report? Are you sure your report data source is...

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...