Use the obscure and hard-to-find-out-about sp_change_users_login procedure. Check in BOL for details; here's the template I use when I need it (which is often):

-- Check over scrambled SIDs

EXECUTE...

It depends upon how the database is being used. If you have applications or users currently using the database who are gaining their access rights via the permissions assigned to...

Definitely. Alas, I am just the Operations DBA, and have no control over what the application's actually doing in there. By and large, neither do the developers; Hibernate is...

[All of this applies to SQL 2000, and 7.0 too, I think. Don't know about 2005 yet...

You cannot disable or drop the public role. However, you can revoke...

Thanks for the info, this points me in the right direction.

One question, where did you learn that "Object ID of zero is the database object"? I hit BOL, Google,...

I don't know how much this will help, but here's a query I wrote long ago to do a quick informational dump on all jobs on an instance. For...

I really wish you'd written this article a few months ago. Our system was performing poorly, and I only stumbled across the "...N'stringValue' queries leading into skipped indexes and...

I did a google check on this, and it looks like Jorge posted his question on any number of sites back when. Looks like the general consensus is: you...

Hey, add me to the list on this one too. (At two years and counting, it might be a bit of a wait...)

Philip

It also sounds like you're having login configuration problems. This is a bit of a complex situation, and this is only a rudimentary explanation; check out BOL for the...

David,

Thanks, that was useful. They imply that corruption may be the cause (I have run DBCC CHECKDB, it found no problems), and (re)creating a clustered index might fix it,...

2.5 cents, 2.5 years late:

First off, Don Becker would appear to be right--hard to tell without the detailed system requirements.

Assuming that it's like you said, sounds like type/exclusive subtype. For...

Got a bit more time now to do a quick scan.

Steve Jones discussed several auditing techniques in a series of articles (here's the last--for obvious reasons, these articles never link...

More clues: Restored a copy of the database from last week, and the statistics are there. Restore it from this week, and they're not.

Messing around with both restored databases,...

Addenda: I created some indexes on individual columns, and statistics were there. It did partial sampling, and didn't like the resulting selectivity on one column, so I ran sp_updatestats......