Pleasure. Its a common issue.

Thanks for the feedback, happy christmas. 🙂

The database userid is becoming orphaned from the login.

the user and login are mapped together using a SID (Server ID) value. When you failover the database the SID value for...

The PHYSICAL order of data is only guaranteed to match the clustered index just after it is created or rebuilt. In this case the index is created and the data...

duplicate post, answers to

http://www.sqlservercentral.com/Forums/Topic1036985-148-1.aspx

please

sssshhhh! Don't tell managers, they'll want it installed over christmas, 'whilst its quite' 🙂

and it is just in the context of that query window. so no it is not server wide and you don't need to turn it on again

The sp_help_revlogin script for SQL2005 does include the default database for the logins.

but anyway this would script them out for you as well (SQL2000 syntax but will work)

set quoted_identifier off

select...

This is certainly possible.

working from memory here on the event names but under TSQL look for SQLStmtStarting and SQLStmtCompleted.

Beware you are likely to get a lot of output compared to...

We use blackberrys on which we receive emails. Might receive a call if its something monitored by the operators.

home connectivity is either via citrix on my home PC or vpn...

IIS is only a pre-req for reporting services. If you are not installing that ignore the warning, if you are, stop the setup and install IIS.

<sigh>. I know what I did. I was doing the investigations on the failover server, the database has a different dbid there!

thankyou Gail for confirming the value I should be checking..

I have gone back and revisited it and got a hit on the objid this time. I don't have the original...

It should be removed from maintenance plan options as it has no place in day to day database maintenance.

I can just about see a case for autoshrink in dev environments,...

The above proc would also be run if you use the history cleanup task in a maintenance plan and select Backup and restore history

select count(*) from msdb..backupset where database_name = 'yourdb' and type = 'D'

However older backup history can be purged from this table by cleanup operations so unless you never run this...