Viewing 15 posts - 91 through 105 (of 7,631 total)
OK, here's the quote from the documnetation:
Current identity value is set to the new_reseed_value. If no rows have been inserted into the table since the table was created, or if...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 12:29 pm
Florian! Long time no see!
Anyhow, as I recall, this is known behavior, though I forget right now where Microsoft documented it...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 12:25 pm
What do you mean by "recognizes accents"? "Recognizes" is an ambiguous non-technical term that does not tell us what is really going on.
Describe to use what commands/actions you are...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 12:21 pm
opc.three (9/10/2012)
I don't know about that. If it were denied on public in Clare's environment then she would not have seen the listing unless she explicitly added a GRANT to...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 11:46 am
I have not done this myself, but I am pretty sure that you can do it through the use of the new Policy Management features. For this, I think...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 11:34 am
opc.three (9/10/2012)
RBarryYoung (9/10/2012)
public does have VIEW ANY DATABASE by default and my test instances do not undergo any changes to those permissions. REVOKE simply clears an explicit setting on the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 10:06 am
opc.three (9/10/2012)
MissTippsInOz (9/9/2012)
Developer Edition 9.0.4266
I just tried it on another machine using SSMS 2005 connecting to Developer Edition 9.0.4060 and I cannot reproduce what you're seeing. Are you using the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 8:48 am
Glad that worked for you. (Kind of surprised too. I really thought that it would take more than that)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 8:37 am
pakwichek (9/9/2012)
Thanks for your quick reply. I will like to add that, I have purchased the Virtual Private Server (VPS) from ToggleBox.com and using it to run my SQL...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2012 at 8:33 am
The error message seems pretty clear. There's a problem with the SMTP service or connecting to it. You should talk to whoever supports your SMTP server.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 9, 2012 at 3:47 pm
Exactly, I was just trying to say it in a more positive way. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 9, 2012 at 3:41 pm
First, you should *not* need to use any DENYs unless you've already given your user implicit permissions that you need to override explicitly. And in general you do not...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 8, 2012 at 10:23 pm
suresh0534 (9/7/2012)
I didn't understand what license and connection limit problem. Can you explain in detail.
No I could not, because you haven't given any of the details that we would need...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 8, 2012 at 9:49 pm
If I were just to take wild guess, I'd say that this could be a license/connection limit problem.
However, like Lynn, my ESP's on the wane, so that really is just...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 7, 2012 at 4:22 pm
RBarryYoung (9/7/2012)
opc.three (9/7/2012)
na1774 (9/7/2012)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 7, 2012 at 4:05 pm
Viewing 15 posts - 91 through 105 (of 7,631 total)