A CTE is very local. In fact, it's only available to the SQL query that immediately follows it, although it can be used multiple times within that query. so you...

Posting homework is bad enough. Cross-posting homework is getting a bit over the line. See my response on the other thread.

Clearly, obviously homework. You even posted the question numbers.

For help of this kind, you have to show what you tried that didn't work rather than have any of us do...

Sorry I wasn't clear. We collect both BatchComplete & RPCComplete because, depending on the app, the calls are made in different ways and we want to see both (most are...

Talking about which tool is better can be a pretty slippery slope. I've been using ERStudio for years. I used to use ERWin and the company I'm currently at was...

The one approach that occurs to me is to use SMO to walk your procedures, identify the parameters, and alter the CATCH statements with an additional insert to a log...

What about using the OUTPUT clause. That will capture the generated fields. This script assumes the ID field in the t1 table is

CREATE TABLE #temptable

(id INT, val VARCHAR(50))

INSERT INTO t1

(val)

OUTPUT...

I'm still not sure you found a bug. I use scripts to capture profiler traces all the time and the two events we capture are RPC complete and Batch complete....

The only events you're seeing are Trace Start and Trace Stop. TextData is not available for these events. If you make sure that it generates events, you can see them....

OK. Well, first, you need to identify logical seperations between the data. Each logical seperation can become a table. Once you establish a table, you have to identify a primary...

One table has a primary key, column or columns that identifies it uniquely. You can define this in SQL Server as a primary key constraint. A table that this table...

If you click on "Show all columns" it doesn't appear way off to the right on the screen? If I turn off TextData for the event, then the column becomes...

Go into the Properties to the Events Selection tab and be sure that you've got the TextData column selected for the event you're viewing. I see that you've got Column...

You should post this question in the 2000 forum because you may start getting 2005 solutions to the problem that will not work in 2000. For example, I think I...

How about right clicking in SSMS and then selecting "Script Job as" and "Create to" to arrive at a script that completely replicates the job, schedule and all.