Forum Replies Created

Viewing 15 posts - 2,446 through 2,460 (of 6,104 total)

  • RE: Problem conneting remote client sql server 2000

    Are all the computers trying to connect from the same network? From the machines that cannot connect to the SQL Server, are you able to ping it?

    K. Brian Kelley
    @kbriankelley

  • RE: DTC problem with SQL 2005 on Server 2003

    Is MS DTC configured to run under Network Service on both servers?

    K. Brian Kelley
    @kbriankelley

  • RE: long duration for "Audit Logout" in trace

    In the case of Audit Logout, the duration is approximately how long (in ms) the connection had been open. In this case the connection had been open about 6447 seconds,...

    K. Brian Kelley
    @kbriankelley

  • RE: Login failed for user ''''NT AUTHORITY\SYSTEM''''

    Has the BUILTIN\Administrators group been removed from being able to logon to the SQL Server? If so, do you have the full text search service installed?

    K. Brian Kelley
    @kbriankelley

  • RE: 2000 tools for 2005

    Yes, you can. As a matter of fact, I have 'em both open right now.

    K. Brian Kelley
    @kbriankelley

  • RE: 2000 tools for 2005

    I've got both sets of client tools installed, if that's what you mean. There are a few things to consider, like checking your path and deciding whether the SQL Server...

    K. Brian Kelley
    @kbriankelley

  • RE: Installing another Instance on SQL2000

    Was there a previous install (canceled) or uninstall run since the last reboot? If so, that might explain the error. As for being able to do anything without the reboot,...

    K. Brian Kelley
    @kbriankelley

  • RE: 2000 tools for 2005

    I don't know if there is a reference or not, but I know Profiler doesn't work, either. You've got to use Profiler90, which comes with the SQL 2005 tools. Third...

    K. Brian Kelley
    @kbriankelley

  • RE: What is the argument against IDENTITY columns

    There's also a maximum "throughput" on INSERTs, but I forget what that number is. Far greater than what most of us see, though.

    K. Brian Kelley
    @kbriankelley

  • RE: Viewing posts issue

    I don't have the combo box issue, but I have had the viewing additional pages issue. What I typically do in these cases is scan the forum groups I normally...

    K. Brian Kelley
    @kbriankelley

  • RE: Create a "Pivot" table

    Pivot being primitive in 2005... I'd have to agree. Can't stick a subquery where you specify the columns for the PIVOT operator, meaning you have to hardcode them. That means...

    K. Brian Kelley
    @kbriankelley

  • RE: Re-Installation SQL on a Laptop

    Can you post the exact error?

    K. Brian Kelley
    @kbriankelley

  • RE: Create a "Pivot" table

    SQL Server 2000 or SQL Server 2005? The reason I ask is there's a new PIVOT T-SQL command in SQL Server 2005.

    If 2000, something like the following works (and I...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Server on a Virtual Server

    Actually, the most expensive part is always maintenance. And this is where VMs can reduce cost. Case in point: you want to apply SP4 to your SQL Server. You've run...

    K. Brian Kelley
    @kbriankelley

  • RE: How to be a Good DBA - Strategy and Tactics

    Even some larger organizations have DBAs wearing all the hats. They may make a separation that says, "Because you were the DBA assigned to development in this project, you can't...

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 2,446 through 2,460 (of 6,104 total)