Joshua,

The issue is that the ”invoke the role” statement in the question is vague and I belive assumes that the @fCreateCookie and @cookie arguments were used.

-Kevin

Thanks guys. That is much clearer now.

Can someone explain to me what this means?

I see that the ANSI_NULLS database option is off on my databases and that in SQL Server Management Studio that ANSI_NULLS is on....

SSCrazy,

Understood.

I guess my first post was confusing. I was mearly trying to point out that the example in the article didn't work when I tried it. All green doesn't...

Rick Todd (2/11/2008)

---

cmcklw:

I'm doing my compare based on the Business Key of the table, as opposed to something I'm generating internally (like the Surrogate Keys I'm generating with an IDENTITY...

Hi Andy,

Thanks for a very informative article!

Some things I found while walking through this.

The Changed Rows detection condition expression failed for me. The error was that the expression returned...

Thanks Mohit. This sure saved me some time!

What's the point of this question?

Now I get it! Thanks for helping.

I think you meant to say

ISNULL(AT_Active, 'False') <> 'True'

Thanks for that link. Very informative read.

Thanks.

Seems strange that this syntax does not work...

select top @varname * from ...

and this one does

set rowcount @varname

Sometimes I feel like I am jumping through hoops e.g., dynamic query, etc..,...

Thanks. Worked great.

Thanks Steve. Great article. I have a question the might be slightly off topic. What would be the best way in sql server 2000 to write a stored proc...

I'm going to need a better dartboard. Mine's not working very well.