Forum Replies Created

Viewing 15 posts - 136 through 150 (of 185 total)

  • RE: Changing SA password breaks DTS packages

    You did restart the server (the physical server, not SQL Server) after doing this didn't you?  If not, you need to.  We had the same problem a couple weeks ago. ...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: Formatting Query output column width

    SELECT CAST(spv.name AS VARCHAR(5)) FROM master.dbo.spt_values spv

    SELECT spv.name FROM master.dbo.spt_values spv

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: sp3 vs sp3a

    Version NumberService Pack
    8.00.194Microsoft SQL Server 2000
    8.00.384Microsoft SQL Server 2000 SP1
    8.00.532Microsoft SQL...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: insert..select performance HORRIBLE

    Use ROWCOUNT and see what that gives you.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: execute stored proc from within stored proc

    To do this, you need to:

    1.  Create a temp table with columns that match the output of the Stored Procedure.

    CREATE TABLE #recordset(

    ident INT IDENTITY(1,1) PRIMARY KEY,etc,etc)

    2.  Do an INSERT...EXEC.  You...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: connecting to sql server with vb

    Hi Chris.  You should go to http://www.asp.net and download one of the starter kits.  They have SQL Server databases included and you can learn several different ways of connecting...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: Download Yukon. where?

    You can't.  If you can find someone who got Beta 1, they can share it with you.  They handed it out at last years PASS conference and a few other...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: Copy table from one server to another

    There are several ways to do this Erik.

    1.  You can set up a linked server from server A to server B. (Look up linked server in Books Online).

    You can then...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: How to fix "Divide by zero error" in SQL Server

    Don't divide by zero.    You need to figure out where you are doing this and fix it. 

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: BetOnSports Seeks DBA for Exotic Costa Rica

    Ahhhhh....pobrecito.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: Attachdb Not Working

    You followed what syntax?  You might want to post the code.  Also, the account has to have sufficient priviliges to run sp_attach_db.

    Only members of the sysadmin and dbcreator fixed server...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: BetOnSports Seeks DBA for Exotic Costa Rica

    Telecommuting.......are you kidding!!!!!   It's Costa Rica.  I would move there in a heartbeat.  Just pay me enough I can fly back to the USA every 3 months or so.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: msdb percent log used above 84%

    If you don't want to do log backups on the msdb database, and I don't know why you would, you can just set the recovery mode to simple.  This will...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: Database Ownership

    --Also, here's a script for you while I'm at it. 

    DECLARE

     @int_counter INT,

     @int_max INT,

     @txt_name NVARCHAR(255),

     @txt_sql NVARCHAR(2500)

    DECLARE @databases TABLE (

     int_id INT IDENTITY(1,1) PRIMARY KEY,

     txt_name NVARCHAR(255))

    INSERT @databases(txt_name)

     SELECT name FROM master..sysdatabases WHERE name NOT...

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • RE: Database Ownership

    sp_changedbowner

    Read all about it in Books Online.  It really shouldn't be owned by a person BTW.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

Viewing 15 posts - 136 through 150 (of 185 total)