it returns zero rows as expected.

thanks a lot for your time and help.

Very strange i'm running it on SQL (SP1) - 10.0.2757.0(x64) -

and also when I run it from (No SP) - 10.0.1600.22 (Intel X86).

I'm a little confused as to why it's...

Thanks for the reply,

This code gives me the same result. It's trying to put an empty result set into a table, so you'd expect it to return no...

thanks for the reply, ended up getting result I wanted using dynamic sql.

Thanks for the reply, That would option would be great, however I've now been told I need to audit all changes made to exsiting and new logins created on the...