Forum Replies Created

Viewing 15 posts - 3,151 through 3,165 (of 6,104 total)

  • RE: how to find sa password

    NGSSquirrel and NGSSQLCrack are two products capable of doing this to recover an sa password. They are available from NGSSoftware. However, as others have indicated, you...

    K. Brian Kelley
    @kbriankelley

  • RE: NETLIB invalid insatance on connect sql2000 sbs2003 Help!

    Do you have the firewall up on those Windows XP machines?

    K. Brian Kelley
    @kbriankelley

  • RE: SQL and IIS on Different Boxes Using Windows Authntication

    Last time I checked, it was not needed. As always, run the tests to verify. Most firewall admins balk at allowing any NetBIOS traffic, so I think you'd have heard...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Database Administration using PERL

    The short answer to your questions is Yes! There's a book you want to get:

    Real World SQL Server Administration with Perl by Linchi Shea.

    BTW, source code...

    K. Brian Kelley
    @kbriankelley

  • RE: Stored Procedure Locking

    The lock hint against a table won't help against the [COMPILE] lock being generated on the stored procedure. You are right that it is an exclusive lock which serializes access...

    K. Brian Kelley
    @kbriankelley

  • RE: Access via User Groups

    It's not what domain the server is registed in that is causing the problem.

    Out of curiousity, if you were to assign that group access to another resource in Domain...

    K. Brian Kelley
    @kbriankelley

  • RE: Beta Programs

    I'm more than willing to help.

    K. Brian Kelley
    @kbriankelley

  • RE: sp_recompile doesn''''t

    This generally isn't recommended in a production system as it will drop execution plans on all objects, not just the one in question.

    K. Brian Kelley
    @kbriankelley

  • RE: Access via User Groups

    The group shouldn't be a SQL login. It should be a Windows login. Also, it must be a global or universal domain group. Verify the group in question isn't a...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Agent won''''t start

    These servers are only listening on shared memory. That means they can't be communicated with other than on the laptop. That also explains why you're not seeing an entry with...

    K. Brian Kelley
    @kbriankelley

  • RE: sp_recompile doesn''''t

    How about modifying the stored procedure to force it to use the indexes with query hints?

    K. Brian Kelley
    @kbriankelley

  • RE: How to Monitor or Identify Dropping of Triggers in DB

    You can run a profiler or SQL Server trace and track the Objecteleted event. This will tell you after the fact that such...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Agent won''''t start

    What OS, service pack, SQL Server, service pack versions? Personal firewall in place? If so, what is it?

    When you run a netstat -an from the command prompt, do you see...

    K. Brian Kelley
    @kbriankelley

  • RE: Enterprise Mgr CRASH!!

    I had this happen on one of my machines (client-side only). I ended up re-installing the service pack on the client and it worked fine. Does any client connecting to...

    K. Brian Kelley
    @kbriankelley

  • RE: Access via User Groups

    Does domain A trust domain B? A\username works for someone coming in with B\username credentials? Can you verify this with a profiler trace?

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 3,151 through 3,165 (of 6,104 total)