Viewing 15 posts - 331 through 345 (of 832 total)
The only thing I can find about this says the backup can be resumed from where it was interrupted, but it doesn't actually say how you do this:
http://msdn.microsoft.com/en-us/library/aa213840%28v=sql.80%29
May 30, 2012 at 2:10 am
You can't install the Enterprise Edition of SQL server on a desktop OS, no. If you want a full-featured version of SQL Server that *will* run on a desktop, you...
May 25, 2012 at 4:58 am
He did say he felt SQL Agent is more robust than Windows task scheduler, but it would be interesting to know why he feels that...I've rarely run into issues with...
May 25, 2012 at 4:46 am
Seemed obvious to me there could only be one, given the syntax of the CREATE MASTER KEY statement doesn't provide a table parameter; how would the database determine which master...
May 25, 2012 at 4:39 am
lbrigham (5/24/2012)
Add me to this list too. I answered OR having higher precedent than AND because it doesn't matter what the evaluation of one side of the OR is...
May 25, 2012 at 1:03 am
IgorMi (5/24/2012)
I get you, but for e.g. "OR has precedence over NOT" in T-SQL is not a fact. That was my comment about the QotD.
Sorry...my post wasn't intended to be...
May 24, 2012 at 6:43 am
This is something I pretty much never bother to remember, because if there's any ambiguity I always add parentheses...makes it easier for humans to understand that way.
May 24, 2012 at 6:36 am
I haven't had a chance to look at it...the question was mostly asked out of curiosity, because I find it incredible that something as unimportant and easily rebuilt as a...
May 18, 2012 at 4:09 am
bitbucket-25253 (5/17/2012)When pressing the F5 key for SSMS (2008R2) .. and again using SSMS checked after the error message and what do you know ... what was shown did NOT...
May 18, 2012 at 2:14 am
I think Scott is thinking along the lines of doing this for all tables because the original question asked if there was an internal timestamp in SQL server that tracked...
May 15, 2012 at 3:16 am
I wish I still was a programmer (what's all this "software engineering" stuff anyway? :-D) sometimes...I don't think my sideways career move into sysadmin was a good choice in the...
May 14, 2012 at 1:37 am
Directory lookup for the file "<redacted>" failed with the operating system error 3 (the system cannot find the path specified).
May 10, 2012 at 1:45 am
I'm not particularly familiar with the CLR--does processing stuff via RegEx in this way effectively mean you're using RBAR, or is it a bit cleverer than that?
May 8, 2012 at 6:48 am
In that case, surely you're not going to be exposing the SQL server anyway? The web application will talk to the SQL server, and it'll be the Web application which...
May 1, 2012 at 2:16 am
Hugo Kornelis (5/1/2012)
Don't be too hard on yourself. I had looked over that page a few times already without seeing the footnote before I saw Paul's comment. And even after...
May 1, 2012 at 1:45 am
Viewing 15 posts - 331 through 345 (of 832 total)