Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 1,790 total)

  • RE: SQL Server Needs Incremental Updates

    The length of time between releases is not a major thing with me or my organization especially if you have a product that works and SQL Server 2000 does just...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Water Power

    I lived in CA for many years and was delighted to see alternate options such as geothermal, wind, and sun being utilized and explored. There are some truly great ideas...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: An Interview with Idera CEO, Rick Pleczko

    Great article Steve! The line of questioning was solid and I liked the fact that it was not just focused on their product line. I have been fortunate enough...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: List of Databases taking forever to load

    You didn't just install any of the 2005 tools on that machine did you? I know where I have the 2005 tools the database listing expands really slowly. Curious.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Send Email Task error

    Amy,

    Using the mail task in DTS can be somewhat odd in that if you add the task while developing from your PC then it will use your Outlook mail profile...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: dtsrun would not die

    You can also log onto the server, open Windows Task Manager, go to the processes tab, find the dtsrun.exe process and end that process. That will also clear up the...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Logshipping Copy/Load Schedule

    Edit your maintenance plan for log shipping, select the log shipping tab, click on the destination server and select edit, select thresholds tab, and change the load time delay to...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Renaming SQL Server Instance

    This link will give you the information you need.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;303774&Product=sql2k

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Tool For Security Review

    Thanks Brian! I was going down that road and have had good success querying Active Directory from SQL Server in the past but was hoping that I could find something...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Sqlserver 2k Enterprise edition vs Std. edition

    You might also take a look at "Maximum Capacity Specifications" in SQL Server Books On Line....

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: SQL server and load balancing

    As far as I know there is nothing that will truly "load-balance" a SQL Server installation. You can have an Active / Active cluster solution where you split the heavily...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Missing Login Name within a database

    Ahhh. dbo is a standard user in every database. If you were to go to the security, logins view and double click on sa you would see that under the...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Can smiply fly

    I'm still trying to decipher all this but where is the join specification for your first derived table A2.something = A3.something.

    Sorry if I missed it but I just don't...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Missing Login Name within a database

    Not sure I get everything you are saying but the login sa usually translates to database user dbo.

    I would not delete dbo as a user from the database. Not...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: How to Track Changes to Tables

    Triggers is definitely an option. I personally am not a fan of triggers but that is one of the best purposes for them.

    Another option is to build in this...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 15 posts - 1,426 through 1,440 (of 1,790 total)