If you're interested, I've posted an article on http://www.sqlservernation.com that might complement the comments posted by Brad. 🙂

http://sqlservernation.com/blogs/tipweek/archive/2009/05/27/introduction-to-sql-server-profiler.aspx

Tim Chapman

SQL Server MVP

Glad you liked the article. If you get a chance, check out our new site at www.sqlservernation.com.

Thanks Brian, I appreciate it.

Tim

Kind of off the topic here, but what kind of screen capture software do you use to create these videos?

Thanks,

Tim

Good article, thank you.

Tim

One thing that frustrates me about how SQL Server handles NULL within unqiue constraints is that it does only allow one NULL value (as the article does a nice job...

I wish we could either pass arrays or table variables as parameters. Doesn't it just make sense that if they call it a table VARIABLE that we could pass...

Maybe...but its probably negligible. If you use sys.sql_modules, you still have to go lookup the name of the object.

Tim

I haven't tried it for this scenario, but I would think that you could call the new 2005 function OBJECT_DEFINITION on the sysobjects table, and then query that function to...

Yep, its neat, and I wasn't aware of it.  Does anyone on here know if there is a way (other than using this), to extract the calling stored procedure in...

Yes, but you won't be able to insert another record until that trigger has finished firing, so that is a consideration.  I suggested using a SB program so that you...

I gotcha.  Didn't realize you were going to have an outside process perform some work on the dataset.  BTW...are you using SQL 2000, or 2005?  If you are using 2005,...

What about trigger tr2?

What if there are >1 record inserted?

From just looking at it, it seems a bit tricky.  Are you planning on recursive triggers?  Also,  not sure what happens in usp_Process, but it looks like you are only...