Viewing 15 posts - 3,151 through 3,165 (of 6,104 total)
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
March 16, 2005 at 6:07 pm
Do you have the firewall up on those Windows XP machines?
K. Brian Kelley
@kbriankelley
March 16, 2005 at 6:04 pm
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
March 16, 2005 at 6:01 pm
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
March 16, 2005 at 2:23 pm
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
March 16, 2005 at 2:19 pm
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
March 16, 2005 at 2:12 pm
I'm more than willing to help. ![]()
K. Brian Kelley
@kbriankelley
March 16, 2005 at 1:40 pm
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
March 16, 2005 at 1:38 pm
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
March 16, 2005 at 1:37 pm
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
March 16, 2005 at 12:48 pm
How about modifying the stored procedure to force it to use the indexes with query hints?
K. Brian Kelley
@kbriankelley
March 16, 2005 at 11:36 am
You can run a profiler or SQL Server trace and track the Object
eleted event. This will tell you after the fact that such...
K. Brian Kelley
@kbriankelley
March 16, 2005 at 11:34 am
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
March 16, 2005 at 11:27 am
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
March 16, 2005 at 11:22 am
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
March 16, 2005 at 11:21 am
Viewing 15 posts - 3,151 through 3,165 (of 6,104 total)