Here's another way:

This is the approach I always use

The coalesce function allows the first non-null value so if we don't add a value it won't filter.

Like so:

Where col1 = coalesce...

Thanks man! I had forgotten about this! I was wondering why it was working on some servers but not others!

Same question....

/*

You could use a variation of the article found here: http://support.microsoft.com/kb/246133 to script out the permissions then place the generated logon for the sa account in your script.

Here's...