Viewing 15 posts - 151 through 165 (of 588 total)
Got it figured out!
Not enough space for the profile for the new account was the cause. I looked at the space and saw 400 mb available, didn't think space...
May 6, 2008 at 9:59 am
I've tried it both ways, first using the configuration manager, then from Services, same problem either way.
One thing I did notice after original post. Whenever SQL tries to start...
May 6, 2008 at 6:39 am
Trace out the flow of begin transactions and commits/rollbacks, or take away the while loop and write it all out as one long series.
May 6, 2008 at 6:34 am
Bug in the code =) Transactions for ID's between 1 and 5 never get rolled back.
Need to add the following lines
else
rollback trans
This would make the complete...
May 6, 2008 at 5:17 am
The place I work now use XML, a LOT. And a lot of the time in the wrong ways. Luckily we have finally agreed on a standard: Relational...
May 5, 2008 at 11:49 am
Steve Jones - Editor (4/25/2008)
Anders, great point in compatibility, but if this is a sticking point, would it not make some sense to force the change before you can upgrade...
April 25, 2008 at 11:06 am
Steve Jones - Editor (4/25/2008)
Keith,I think you're right, but that's why we have compatibility mode. If it's < 10 or 11, then allow them, but in new versions don't.
But that...
April 25, 2008 at 8:45 am
Actually there are a few (very specialized) reasons for allowing duplicate indexes to be allowed.
In one place I worked there was a lot of embedded SQL in the application...
April 25, 2008 at 6:12 am
I can dismiss it out of hand! It helps that my application architect and I (Database Architect) both agrees on it =)
Jack,
I agree, if the options are dynamic SQL...
April 22, 2008 at 12:20 pm
Horrible idea in my opinion.
Who cares if a developer saves 10%-20% (the numbers I have heard bandied aroud) by using LINQ during development time? How much time in man...
April 22, 2008 at 6:29 am
Without couting them all up.... there are 150 Nvarchars, so the answer has to be somewhere above 300 bytes....
April 8, 2008 at 9:05 pm
Good one!
But...
Wasn't this sort of how SQL 6 and 6.5 worked? At least if I remember correctly those two (and I assume 4.2) bypassed the OS for IO functions...
April 1, 2008 at 4:44 pm
I accidentally rebooted my main production SQL Server because of this a few weeks back. In the middle of the day. One of the patches we had applied...
March 26, 2008 at 6:33 am
I've never had a contract, but these are issues I have learned to discuss with my boss before I take a job:
If I work after midnight, I come in late...
March 25, 2008 at 10:38 am
I restore from prod and make it the developers responsiblity to keep scripts to get THEIR changes back on after restores.... Amazingly enough after the first time you over...
March 25, 2008 at 10:18 am
Viewing 15 posts - 151 through 165 (of 588 total)