Found it!
 Open the toolbox from the menu, then right-click in the toolbox and select "Show All".

Thanks for your help!

Bump

Thanks Eugene!

Well said Jason.

I've had that meeting with our respective boss' - the underpinning is a political game that I can't win necessarily. However, I've played this game before and religiously...

Thanks Stuart, my sentiments exactly. It's not the presidency, if you forfiet your title here, it's gone for good!

Thanks Vedran!

The certificate works like a charm!

dwg

It's a former DBA that hates me because unlike him, I take my job seriously and won't give him sa permissions. He thinks because...

Thank you everyone!

SQLX - both great ideas, I'm going to try the first one... um... first.

DWG

Well since I was only looking for 'sp_revokedbaccess' in the text data, I let the trace run all night and this morning the permissions are gone and theres no usable...

No restores, no dropping tables, etc. This is a fixed database that only experiences regular add/update/deletes to the data, and a daily full backup.

I currently have a trace running looking...

Has anyone found a resolution to this problem? I'm having the same issue.

SQL 2000 SP4

Windows 2003 SP2

I add a domain user and grant db access with db_datareader permissions. The next...

I may be late in the game on this, but in my experience (and I just tested this to be sure) you can pretty much ignore the login failed message...