I'm gonna check it out to see it's of use

This is really my biggest pet peeve too. I've looked into...

Leo.Miller (8/9/2011)

---

This is one of the possibilities...

Leo.Miller (8/8/2011)

---

Did you ever find anything causing this? I've got a client of a partner company with the same problem, also on a NAV database.

One question though, since it's the...

I've got the DDL Trigger set up and tested so I'll know when and who executes the drop user command. I work for a small company with a 3rd...

That's what I'm looking for Lowell and the DDL trigger looks like it will work to monitor.

Thanks,

T

The server is a production server, SQL 2008 R2 Standard 10.50.1600 (no Auditing)

I'm setting up a DDL Trigger (in dev first) on the DROP_USER event that will log the user...

Thanks Jason, I guess I just got too used to using Idera's auditing tool. Looking to set this up on a dev box today.

I'm looking at setting up auditing now, any good references?

There was no database restore. When I say mapping, under user mapping on the Login properties the map field was unchecked. This is alos a MS NAV database...

Long Work = Code, Network, or Spreadsheet Monkeys

Thanks, I was looking for a way to make Detail View the default.

Heck Yeah, straight DB administration is boring as far as I'm concerned....

I think I just found it.

http://technet.microsoft.com/en-us/library/ms143724.aspx

The error is "Unable to Read Document" and it's only Excel files generated from SSRS 2008 R2 when reading the attachment in email.

These are all work phones.