Forum Replies Created

Viewing 15 posts - 31 through 45 (of 92 total)

  • RE: SQL Server and other applications

    We're running into two problems here. One, nothing from Microsoft is going to imply that you can't share a server with other applications. I searched for a while...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Script to see if SQLAgent is running

    sc.exe comes with the Win32® Software Development Kit (SDK)

    http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarpic/html/msdn_scmslite.asp


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: odd connection problem

    It's just a guess but perhaps a change was made to the user database between the time the master backup was created and the backup was restored.

    If you look in...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: MultiServer Administration

    Well, um YEAH!

    After some reading on the multi-server deal it doesn't seem worth it. I was just curious whether the multi-server maintenance plans actually existed on the target server...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Adminstration Tool for DBA

    http://www.aspenterprisemanager.com Is one of many open source tools striving to meet this goal.


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: How old are you?

    Well, Duh! There it is.

    I'm 35, Married for eleven years (dated my wife for five years before that) and have an angel of a three year old daughter. ...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Dev Tools people use and why?

    I'm constantly on the search for a better tool. (Probably why I've started thinking about just making my own.)

    Mostly EM/QA.

    For SQL Scripts I've started using UltraEdit32. It's a...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: What did you do before SQL?

    Before becomeing a fulltime DBA I was a...

    *** Post College ***

    Manager of an IT department for a software company with < 50 people.

    Helpdesk/pc tech.

    *** College Years ***

    Cashier Supervisor/trainer at a...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: job report success even though failed..

    Could it be that you have it set up so that the task the job step performs is kicking off the DTS package? If so as long as the...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Remove Leading Zeros

    I tried something similar to coondapoor's approach but it doesn't handle a string of all zeros. i.e. '000' yields '000'

    Hence the case statement...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Admin GUI for SQL Server

    I just found that yesterday. It's also at http://www.aspenterprisemanager.com

    It seems like a logical starting point but then too, I'd have to learn ASP.Net...

    I suppose though, with Yukon right around...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Remove Leading Zeros

    Sorry, ugly spacing.

    I've always thought SQL should have a simple function like this:

    TRIMSTRING(<string to be searched>, <pattern to be removed>, <Remove from R or L>)


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Remove Leading Zeros

    There's probably a much simpler way to do this...

    create table RemLZ (LZ varchar(25))

    insert into RemLZ values ('000234')

    insert into RemLZ values ('000203040')

    insert into RemLZ values ('000')

    insert into RemLZ values ('234000')

    insert...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Admin GUI for SQL Server

    Oh yeah, and we need a name. Preferably something that is short or has an acronym.

    MAGI - Multiserver Admin Graphic user Interface

    DAMIT - Database Admin Manager Interface Tool


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • RE: Admin GUI for SQL Server

    It's up in the air really. I'm totally starting from scratch. My preference is something web based and ASP is sort of a minimal effort when it comes...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

Viewing 15 posts - 31 through 45 (of 92 total)