Viewing 15 posts - 1 through 15 (of 102 total)
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...
January 9, 2012 at 7:25 am
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...
February 19, 2010 at 9:25 am
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...
February 19, 2010 at 4:58 am
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...
June 17, 2009 at 7:00 am
David Benoit (5/27/2009)
Jonathan Kehayias (5/27/2009)
Brian Munier (5/27/2009)
May 27, 2009 at 6:40 am
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...
May 27, 2009 at 4:56 am
Thanks to all.
December 23, 2008 at 5:29 am
Thanks, I'll try it
December 19, 2008 at 6:50 am
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...
December 19, 2008 at 6:09 am
Interestingly enough, I did a search for purchasing habits right here on SQL Server Central.com and came up with this hit:
An article on SQL Server Statistical Functions and the...
September 16, 2008 at 7:15 am
Christopher Stobbs (9/16/2008)if your with is not the first line of code, then you need a ; before it
Christopher Stobbs (9/16/2008)
Ok, it worked. Thanks.
September 16, 2008 at 6:47 am
I went to check my guess and ran:
WITH DATA (Numbers) AS
(SELECT NULL UNION ALL
SELECT NULL UNION ALL
SELECT 1 UNION ALL
SELECT 2 UNION
September 16, 2008 at 6:22 am
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...
September 16, 2008 at 5:08 am
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...
July 30, 2008 at 12:39 pm
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...
July 30, 2008 at 12:37 pm