Her name is loner.  Old hand is a nickname given based on the number of posts the person wrote.

Can't fully answer this one for a lack of time.

But you need to have a team table and a TeamSalesMan Table.

You then join the sale tables to TeamSalesMan to teams...

What I'm understanding is that you can afford to lose a full day's worth of data.  If this is the case then you can switch to simple recovery and that...

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?