Posted by Hugo Kornelis on 04/18/07 19:18

On 18 Apr 2007 11:57:53 -0700, pbd22 wrote:

(snip)
>MY final question is - why don't I get any data returned with the
>query? Shouldn't I be seeing results with the column headers? Or, is
>this just to show that the query works in debug mode? Sorry - still
>trying to learn my way around stored procedures.

Hi Peter,

You're probably going to hate me for this, but my best guess is that
your tables simply don't contain any data that matches the criteria in
the trigger. I already hinted at this in my previous reply (though I
left a back door open for the possibilty that one of the queries
contained a copy/paste error).

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]