If I'm looking at it right, this eliminates the need to set a variable and tell it to BREAK. It just doesn't run if the date is not in...

How does this code look? I created a table JobrunCal with the dates of the Monday holidays.

DECLARE @countVar int

set @countVar=1

While @countVar=1

begin

if getdate() in (select * from JobrunCal)

break

else

--the Job...

Great. Worked perfectly. Thanks for your help!

Yes, there are several other DB's that they do not need access to.

They need access to 2 databases, 'Test' and 'Production', but they need full access to both. By full access I mean they need to be able to access (read/Write)...

Thanks! But, I'm not a SQL Admin, I'm a developer. My Admin is not here this week and I need to give this access as soon as possible. ...

I need to give them full access to everything.

Gotcha, too late now, but I'll remember it for next time. Thanks again for your help.

I actually tried that. After the above didn't work, I shut down SQL, logged back in and used the code:

USE MASTER

GO

DROP DATABASE db

GO

Received the same error about the DB...

This is the code that I used:

ALTER DATABASE DB

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

GO

DROP DATABASE db

GO

and the error that I got:

Msg 5064, Level 16, State 1, Line 1

Changes to the state...

FYI...In my case it was an sa login that was connected? I put it in single_user mode and still couldn't delete the DB. Also, it wouldn't let me...

Yes, I understand. This is an old DB that hasn't been used in years.

Thanks! Killing the process worked.

Well, you called it Matt. I did import these tables twice. I imported these 3 last week and then when I imported the rest yesterday, I forgot to...

Here is the data I'm getting with most of the columns deleted. Too much to put in here: If you look at the Item_Num there are only 2...