What if you put it all in a single batch:

ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

go

DBCC CHECKDB ( 'dbName' ?? REPAIR_ALLOW_DATA_LOSS  | REPAIR_FAST  | REPAIR_REBUILD )

    WITH   ALL_ERRORMSGS

are you the onlyone working on that issue ?

Check your db-status again ! (sp_helpdb)

When putting a db in single-user , I suggest...

I cannot find anything tricky in the query, so I guess it's a data-problem.

It contains only INNER-joins. Are you sure the data always...

check the pros and cons:

Breaking your recovery model can have its consequences !

If I breake it, I go from FULL to BULK, but rarely to simple.

I have some databases of...

aha, ownership-chaining-problems

Who didn't stumble into that.

It may also be e.g. the query is build dynamic or run dynamic

like

create proc owner1.myproc

as

set nocount...

You can also make the backups using SQL-devices.

So from within you sql-backup-job you can see zip , but your backup-device will point to an...

I'll be flying in on 24 sept. 

Brussels - Chicago - Dallas

I hope to be awake by Monday morning

if I'm correct Log P.I. can do such action.

SQLServer itself cannot, unless you do a full restore to point in time.

also keep in mind this user can be databaseowner.

check out sp_changedbowner @loginame = 'sa' ,@map = 'true'

- http://www.sqlservercentral.com/scripts/contributions/1502.asp

- http://www.sqlservercentral.com/scripts/contributions/500.asp

- You just need sqlserver backups to be able to restore. The  backup-history is just a help-set for EM to determine a gui for restore. You can restore on another...

ooh it must have been realy early in the morning ....

this inline select performs only a sum, so no duplicates

btw, suppose your in-line-select returns more than one result ?

Wich one to pick ?

just a first idea, early in the morning :

SELECT @ProjectID, CSPD.EventID, E1.LeadTime

, isnull(( SELECT DATEADD( d, -SUM( E2.LeadTime ), @CustomerShipDate )

     FROM CompanySeasonProductTemplate AS CSPD2, Event AS E2

    ...

Thank you Scott for the assistance

All Italics-characters are copied from books online. The coloring was just to emphasise the pittfalls.

... When a database is deleted, the default database for any associated users is supposed to be set to Master. Looking at the sysxlogins table, this appears to have happened....