Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 6,104 total)

  • RE: Mystery Logins

    Who has sysadmin access? Do the logins look like something reasonable? I know it is dev, but is this SQL Server exposed to the Internet or does it support a...

    K. Brian Kelley
    @kbriankelley

  • RE: TSQL Debugger in Query Analyzer

    Out of curiosity, what SQL Server service pack is your SQL Server on? Have any SQL Server service packs been applied to any of the client machines?

    K. Brian Kelley
    @kbriankelley

  • RE: Problem adding users and groups to SQL 7

    A couple of things to look at that I've seen cause issues such as these:

    Time on the SQL Server is within 5 minutes of the time on all DCs?

    SQL Server...

    K. Brian Kelley
    @kbriankelley

  • RE: How to install service pack on sql server with multi-instances

    No idea and I just spent time looking in their KB. Probably need to call back MS support and tell them you have the sqlstp.log file and the info on...

    K. Brian Kelley
    @kbriankelley

  • RE: Windows Authenticating as a different User

    I can't replicate the issue (away from a domain) but I've seen this issue before. An old trick was to map a connection to ipc$ of the server that you...

    K. Brian Kelley
    @kbriankelley

  • RE: Attach DB and Procedure Cache

    When you execute sp_detach_db, the procedure cache is flushed for that database. This is probably due to DBCC DETACHDB() [which sp_detach_db wraps], though this command is undocumented.

    Edit: You can see...

    K. Brian Kelley
    @kbriankelley

  • RE: Procedure DECRYPT2K question

    This is well known. It decrypts encrypted stored procedures. The main difference between it and the tool cited is dOMNAR's tool requires you to be a member of the sysadmin...

    K. Brian Kelley
    @kbriankelley

  • RE: How to install service pack on sql server with multi-instances

    No, both are not completed updated. When you run the service pack executable, you'll get the option to select the instance to update. Shared components, like client tools will be...

    K. Brian Kelley
    @kbriankelley

  • RE: Brainbench Exam

    I know when we looked at some candidates, it showed one thing: they went out and at least applied themselves. We didn't use it necessarily as a measure of ability....

    K. Brian Kelley
    @kbriankelley

  • RE: Using Standard SQL Security from Web Apps

    It complicates your security management on the SQL Server side tremendously. That means a greater chance of giving one of these logins more access than it actually needs. Also, it...

    K. Brian Kelley
    @kbriankelley

  • RE: Can all permissions to Public role be safely removed?

    Short answer, no. Microsoft made minimal changes to earn a C2 compliance standard. Public was largely unaffected.

    SQL Server 2000 C2 Administrator's and User's Security Guide

    If you...

    K. Brian Kelley
    @kbriankelley

  • RE: What''s the Point of File Sharing?

    I look at it this way...

    For years I-95 served as a major artery to get drugs into the US (I haven't heard anything recently but I'm sure this hasn't changed)....

    K. Brian Kelley
    @kbriankelley

  • RE: What''s the Point of File Sharing?

    Service packs, technical webcasts that can be downloaded quickly for viewing use later, sharing of large but nonsensitive databases of test data, such as for verifying good stored procedure support...

    K. Brian Kelley
    @kbriankelley

  • RE: dbo, who should it be?

    With respect to what has been covered, in most environments sa isn't ruled out. Also, given the example you presented, there is nothing, other than a procedure to excluse sa...

    K. Brian Kelley
    @kbriankelley

  • RE: ChoicePoint Again

    ChoicePoint can't stay out of the news. From the Florida felons list to the most recent stock sale investigation it's like a train wreck in slow motion. The barn is...

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 3,076 through 3,090 (of 6,104 total)