Viewing 15 posts - 1,501 through 1,515 (of 2,008 total)
In this instance this wouldn't of helped as they detail there are multiple SQL servers at play here, not just the one having the issue with the login. It seems...
November 17, 2011 at 1:27 am
anthony.green (11/17/2011)
this is a good reason why service accounts should be used with none expiring passwords to run SQL server services
Agree for SQL Server Service Accounts. But the issue...
November 17, 2011 at 1:25 am
bpportman 52825 (11/16/2011)
I was able to fix this yesterday...
November 17, 2011 at 1:19 am
I did my best to explain why it should not be used and was met with the same response. I got on the phone about 10 minutes after that discussion...
November 17, 2011 at 1:09 am
GilaMonster (11/16/2011)
Dev (11/16/2011)
I had one of those. I sat down with the architect and explained to him what NoLock actually did and what effects it could have. The...
November 17, 2011 at 1:04 am
okbangas (11/17/2011)
Nice to see that I am nobody 🙂
LOL 😀
November 17, 2011 at 12:49 am
per MSDN:
The rows referenced in the TOP expression used with INSERT, UPDATE, MERGE, or DELETE are not arranged in any order. TOP n returns n random rows.
November 17, 2011 at 12:47 am
winston Smith (11/16/2011)
November 17, 2011 at 12:34 am
Lowell (11/16/2011)
FROM Table;
with that it's very easy to update the original table from that side by side table in...
November 17, 2011 at 12:17 am
oradbguru (11/16/2011)
November 17, 2011 at 12:05 am
Clean Root Folder as well (gererally C:\Program Files\Microsoft SQL Server*)
Then follow each step carefully (Read <--> Implement). I am sure you are missing on something trivial.
How to: Install SQL Server...
November 17, 2011 at 12:01 am
I seem to remember from back in the day that if two columns weren't defined exactly the same, but were used in a join, it was considered a datatype mismatch...
November 16, 2011 at 11:53 pm
I believe you are thinking of a union where the datatypes have to be the same in the returned columns.
Small Correction. "The data types must be compatible."
November 16, 2011 at 11:40 pm
When you run the installer, it performs some verification before installation. Are you ignoring any warning there?
How many times you tried to install it? How are you cleaning it up,...
November 16, 2011 at 11:34 pm
mobgrazer 98125 (11/16/2011)
gets hammered an hour - again - can you quantify?...
November 16, 2011 at 11:29 pm
Viewing 15 posts - 1,501 through 1,515 (of 2,008 total)