I modified the code in the script to fix this oversight. Steve just needs to release the updated code. Here it is here as well:

SELECT

...

Vitali Lisau (2/9/2009)

---

The code is nice, but it actually shows only the records from the last trace file (SQL Srv 2005 Ent , SP2 and SP3).

select * from sys.traces ...

How many user databases on each server? Do the users really NEED this level of permissions? I think this would violate least permissions.

Let me agree with Bruce. I'm not sure why you need the data in 2 places. You either store the parent in the roles table and walk the...

Check out QuoteName in BOL.

Are the different boxes on the same service pack? Are you doing 32-bit and then moving to a 64-bit?

Could you post some structures and some test data (see the links in my signature)?

Also can you verify that you are using SQL Server 2000? That definitely...

If your temp table and your real table are in the same database or on the same server you should use an Execute SQL Task to do this. Your...

Duplicate post. Please answer here

Are you sure the column is vend_num?

I would say that is means the version of SQL Server you are using does not include that component.

Apparently this can also be due to different service pack levels...

As the author I think this article is a good starting point for triggers, http://www.sqlservercentral.com/articles/Triggers/64214/. Beyond that shameless plug, I also think BOL is under utilized resource for these...

Bob Hovious (2/6/2009)

---

Give this a try at least. It runs faster with your test data.

I use glue tables all the time too... but always in this...

You may see some performance gain by running on the server.

When you installed/configured Reporting Services you configured it to use SharePoint Integrated mode and you do not have SharePoint installed. You can change this in the Reporting Services Configuration...