It's probably even more complicated for most of us, in that the scripts we write or re-use end up being the property of the company we work for! I guess...

Either join the sys.trace_events in 2005 or above or you can create the following temp table to join to.

CREATE TABLE #EventClass (EventClass INT NOT NULL, EventName VARCHAR(255) NOT NULL)

INSERT INTO...

If you are doing this on sql 2000 (some of us still use this). This script creates a temp table with the eventclass ids and names in. Left Join your...

Many of you seem to be missing the point! The cloud is not for companies who effectively have their own cloud! Why would it be! A small start up business...

Hi Manie,

It sounds like you have two separate tables for what are effectively the same entity. Why not have one table and use a flag to indicate whether it is...