Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 6,104 total)

  • RE: I am getting error 7356 on SQL Server 2000

    Do you mean at the OS level?

    K. Brian Kelley
    @kbriankelley

  • RE: DBGhost Review

    Excellent review, Jeremy. I would have to agree on attempting to use it on production databases with the other posters (albeit with caution). If source control works the way it...

    K. Brian Kelley
    @kbriankelley

  • RE: Remove BOL from PROD boxes

    You can certainly remove the shortcut from the Start menu. Also, you could remove the files from wherever BOL installed. The default is the C:\Program Files\Microsoft SQL Server\80\Tools\Books directory. Keep...

    K. Brian Kelley
    @kbriankelley

  • RE: Remove BOL from PROD boxes

    True, but a justification can be made that Books Online can be accessed, even in IE enhanced security mode on Windows Server 2003 by dropping msdn.microsoft.com in as an approved...

    K. Brian Kelley
    @kbriankelley

  • RE: sp_password problem

    Ultimately this is a business decision your organization is going to have to make. It's not hard to modify the stored procedure and have it refer to a second stored...

    K. Brian Kelley
    @kbriankelley

  • RE: application create SQL logins?

    When you're able to upgrade to SQL Server 2005, you'll find you can get granular with the permissions and create the mix that you want. Ability to create a login,...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Server Services Restarted

    Check the event logs in Windows. The application and system event logs may give you an idea of why SQL Server went down if it wasn't a person doing it....

    K. Brian Kelley
    @kbriankelley

  • RE: Remove BOL from PROD boxes

    It's not a documentation thing... it's the fact that Books Online uses Windows Help and is a known target... typically in a certain location (default of C:\Program Files\Microsoft SQL Server\80\Tools\Books...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL on VMware

    We're also heavily using SQL Server on VM in non-production. We've gone with ESX Server. It's substantially more efficient than GSX Server on Windows based on how it's architected (as...

    K. Brian Kelley
    @kbriankelley

  • RE: I am getting error 7356 on SQL Server 2000

    Take a look at:

    SSC.com Article: Oracle Link by Adrian Small

    He worked through the errors he was receiving making a linked server connection to Oracle and that error you cite...

    K. Brian Kelley
    @kbriankelley

  • RE: Creating View

    Write a select statement pulling back the metadata to do most of the work for you and execute it in QA:

    SELECT COLUMN_NAME + '1,
    ' FROM INFORMATION_SCHEMA.Columns
    WHERE TABLE_NAME = '<Your table...

    K. Brian Kelley
    @kbriankelley

  • Viewing 15 posts - 2,671 through 2,685 (of 6,104 total)