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.

I agree.

Logically you're defining the join criteria in the ON clause. Based on that criteria, looking at the code, your left join worked perfectly. If you wish to filter...

Physically, yes. The operate side by side with no issues. Licensing, you need a license for each, you have to trade one license in, or you have to get the...

I've never heard of anything that'll help. You'll either have to modify the procedure to disable the PRINT statements or you have to modify the code so that it can...

Nah, we're still aspiring to reach sewer rat. I'm thinking this will get us from cockroach to water...

One way:

SELECT t.A1

FROMtest t

JOIN test t2

ON t.A1 = t2.A1

WHERE t.A2 = 1

AND t2.A2 = 4

That will make...