How do you recover in the middle of the day without having the logs in full recovery?

Need a reply to what message?  Can you post a link?

I think I'd go for the ride and accept the challenge (just for myself).  No need to burn bridges right then and there.  Maybe they are just evaluating how you...

For those of you who figured it out with 3 lights.  Now try to figure it out with 4 lights.

You have 2 minutes this time around

Little on the extreme side, but are you able to drop and recreate the objects with the correct username :

Create table wyantetest.tblname...

Are you sure you are running this on the correct database, on the correct server?

Yes it will.  However one of the best practices states that it is best to set the DB file size to the max size you think it will ever need. ...

Just to finish this off.

Brian, what would you want done if someone posted this "use x software and have your mother killed"? (ok a little more to the extreme but still...)  Especially...

begin tran

select count(*) from table_name

del from table_name

where item_id = 23

select count(*) from table_name

rollback tran

Run once like this, then if everything looks fine, then just run the delete by itself.  Also...

There's a workaround on this one... but it comes with a cost :

CREATE VIEW dbo.vwTblNameForceUnique

WITH SCHEMABINDING

AS

SELECT PrimaryKey, UniqueCol

FROM dbo.TblName

WHERE UniqueCol IS NOT NULL

GO

--Create clustered index for the view

GO

CREATE UNIQUE...

Well everyone has the right to his own opinion.

Can you take 5 minutes of your time and write an article that will "correct" the situation and share it with the...

What's the 5th question?

You can put those sps in model.  So when the new dbs are created they will include those sps.

Giving them access to master might not be the best idea if...

Ya that's the quick and dirty way.  However even my search method willeventually come to that point where you backup and test a delete.  So it might be a little...

A bit extreme... but as long as it works .

BTW rebooting clears the proccache and the data in memory... so maybe that would have...