Forum Replies Created

Viewing 15 posts - 91 through 105 (of 7,635 total)

  • RE: CHECKIDENT bug?

    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...

  • RE: CHECKIDENT bug?

    Florian! Long time no see!

    Anyhow, as I recall, this is known behavior, though I forget right now where Microsoft documented it...

  • RE: Replicated table does not show words with accent

    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...

  • RE: Not View Any DB Other than The One He Has Access

    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...

  • RE: Auto encryption of new databases

    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...

  • RE: Not View Any DB Other than The One He Has Access

    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...

  • RE: Not View Any DB Other than The One He Has Access

    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...

  • RE: Need help desperately on query optimization

    Glad that worked for you. (Kind of surprised too. I really thought that it would take more than that)

  • RE: SQL 2008 express DB Mail

    pakwichek (9/9/2012)


    Hello RBarryYoung,

    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...

  • RE: SQL 2008 express DB Mail

    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.

  • RE: Create objects only in one schema

    Exactly, I was just trying to say it in a more positive way. 🙂

  • RE: Create objects only in one schema

    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...

  • RE: Unable to login users

    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...

  • RE: Unable to login users

    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...

  • RE: Not View Any DB Other than The One He Has Access

    RBarryYoung (9/7/2012)


    opc.three (9/7/2012)


    na1774 (9/7/2012)


    So accoriding to the above logic. I have to Deny View Any DB first. THen make the login owner of the DB. Then it will be not...

Viewing 15 posts - 91 through 105 (of 7,635 total)