No, my previous comment will only a like against the first predicate.

You'll need to add a LIKE to each OR comparison, from the code you added earlier it appeared you...

Easiest way is going to probably be to just wrap it up in a bunch of OR statements, horrible performance, but from the looks of it you're just trying to...

Do you not want this user adding users or logins? Users are only at the database level, whereas logins are at the instance level. It sounds like you...

As with any kind of compression, expect to see a larger amount of CPU time when manipulating this data or doing any kind of re-indexing. Take a look at...

sp_helplogins should tell you this, look in the DefDBName, but will require elevated priviliges to run. Otherwise you can go to a database the user has been added to...