I had the same problem except that one database out of job with 12 restores and multiple other jobs with a total around 250 restores would fail.

While the job is...

Divya Agrawal (2/19/2010)

---

May i know ur datefirst setting?

Just try running "SELECT @@DATEFIRST"

This will give which day is considered as the first day of the week..

And according to that the script...

davidgr144 (2/19/2010)

---

This is a great tip. Thanks.

Can I raise a question regarding it though?

Maybe I'm misreading but if the date you pick is Saturday (instead of Thursday in the...

Without reading all of the past comments, I am going to post what I believe is a valid reason to use NOLOCK.

We have multiple database servers, support one database per...

David Benoit (5/27/2009)

---

Jonathan Kehayias (5/27/2009)

---

Brian Munier (5/27/2009)

---

Interesting article, thank you. My question is if detach/attach is going away, and I want to move a database from one server to...

Interesting article, thank you. My question is if detach/attach is going away, and I want to move a database from one server to another server does that mean I...

Thanks to all.

Thanks, I'll try it

Yeah, I know that your method is ideal.

Unfortunately we do full restores of over 100 database from 8 servers to 1 server for reporting and they get upset when I...

Interestingly enough, I did a search for purchasing habits right here on SQL Server Central.com and came up with this hit:

http://www.sqlservercentral.com/articles/Miscellaneous/sqlserverstatisticalfunctions/1255/

An article on SQL Server Statistical Functions and the...

Ok, it worked. Thanks.

I went to check my guess and ran:

WITH DATA (Numbers) AS

(SELECT NULL UNION ALL

SELECT NULL UNION ALL

SELECT NULL UNION ALL

SELECT 1 UNION ALL

SELECT 2 UNION

SELECT 3)

SELECT COUNT(ALL...

I just finished reading my copy of Broken window.

I too am concerned by what could be out there.:hehe:

I agree that there probably are companies compliling all the results...

FYI, It appears to have worked and I was able to insert the missing data from a restored to a different database copy of the master tables.

It probably wouldn't have...

bfarley (7/30/2008)

---

Appreciate your input, Brian.

It sounds as though the options may be limited to (1) encrypting as you described, or (2) the user accomplishing the tasks without Enterprise Mgr as...