Viewing 15 posts - 1,411 through 1,425 (of 7,168 total)
Never used it this way but redgate SQL Compare Pro with an Automation License might be worth a look.
March 26, 2013 at 11:22 am
Not sure if there was a misconception but to clarify the WITH NOCHECK option only applies to the initial creation of the FK, not later updates. If the column with...
March 26, 2013 at 11:19 am
Jeff Moden (3/26/2013)
Michael L John (3/26/2013)
Do all of you realize that you are saying the same things, but in different contexts?
Security is not something simple,...
March 26, 2013 at 8:55 am
Michael L John (3/26/2013)
Do all of you realize that you are saying the same things, but in different contexts?
Security is not something simple, and to...
March 26, 2013 at 8:50 am
Jeff Moden (3/26/2013)
opc.three (3/25/2013)
Jeff Moden (3/25/2013)
opc.three (3/24/2013)
March 26, 2013 at 8:49 am
Jeff Moden (3/26/2013)
opc.three (3/26/2013)
March 26, 2013 at 8:42 am
When running the service as a named domain account the SPN must be registered to the domain account which is why you do not see it when you ask to...
March 26, 2013 at 8:01 am
If you post the Actual execution plan for one of your long running updqtes that would help too.
March 26, 2013 at 7:58 am
Alone (3/25/2013)
Hi ,it was 90.
I had a couple other questions too. What was the data type of the column you were updating and what was the nature of the...
March 26, 2013 at 7:56 am
Not only are you crass in your delivery but your advice is irresponsible and dangerous. Please keep the mischaracterizations to yourself. You're doing a disservice to the community and are...
March 26, 2013 at 4:11 am
It is worth noting that the solution provided requires you enable xp_cmdshell, which is disabled by Microsoft by default when you install SQL Server and for good reason. Enabling it...
March 25, 2013 at 10:00 pm
Sergiy (3/25/2013)
opc.three (3/25/2013)
What gave you that impression?
Lack of answers on direct questions from me and Jeff.
You have nothing to support your words.
Seriously, where are you going with it Sergiy?...
March 25, 2013 at 8:44 pm
Sergiy (3/25/2013)
opc.three (3/25/2013)
Sergiy (3/25/2013)
When one does not want to admit of being wrong he's resotring to personal attacks.
😛 You just made my point for me. I think we're done here...
March 25, 2013 at 8:34 pm
The SQL is only doing what it is told to do by the .NET, i.e. to end the session because the .NET gave up waiting and closed it's connection. There...
March 25, 2013 at 8:32 pm
Viewing 15 posts - 1,411 through 1,425 (of 7,168 total)