Forum Replies Created

Viewing 15 posts - 46 through 60 (of 92 total)

  • RE: Admin GUI for SQL Server

    I created a blog for people interested in joining the project. If you want to join just send me an email at brenbart@yahoo.com.

    http://sqlservergui.blogspot.com


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

    August 27, 2003 at 10:11 am

    #471639

  • RE: Tools question

    Is there a stored procedure in the database that kicks off the month end routine? If so you'd just be able to muck around with that and fire it...


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

    August 27, 2003 at 9:50 am

    #471632

  • RE: Tools question

    First to answer your question: No, I've never heard of any software that would do that.

    However, could you change the way the month end kicks things off?

    Meaning...


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

    August 27, 2003 at 9:48 am

    #471630

  • RE: Newbie: continuing backup failures

    Oops! Didn't mean to do that. I was just checking to see if I could.


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

    August 26, 2003 at 11:56 am

    #471476

  • RE: Newbie: continuing backup failures


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

    August 26, 2003 at 11:55 am

    #471475

  • RE: Newbie: continuing backup failures

    What do you have checked on the reporting tab of the maintenance plan?


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

    August 26, 2003 at 11:49 am

    #471472

  • RE: Looping Through Records

    I actually noticed and undocumented stored procedure called xp_execresultset.

    You can't see the code since it's an extended stored procedure. (xprepl.dll) My guess is that it runs a...


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

    August 26, 2003 at 10:09 am

    #471456

  • RE: Newbie: continuing backup failures

    In Enterprise Manager-SQL Server Agent-Jobs look at the specific jobs that failed. Right click and check the job history. Also check the SQL Server logs as well as...


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

    August 26, 2003 at 10:00 am

    #471452

  • RE: Goodbye from: mssqlserver@topica.com

    I tried subscribing and kept getting some sort of cookie error when I tried to confirm. I emailed the help address and got some useless spam back that essentially...


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

    August 22, 2003 at 2:59 pm

    #471070

  • RE: Is there a recommended data compression utility?

    It seems like sql server ought to be able to this by itself since as part of replication process you can have it "compress" snapshot files. Of course BOL...


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

    August 22, 2003 at 11:40 am

    #471042

  • RE: Log File problem

    RE: sp_attach_single_file_db

    It actually works either way.

    According to BOL the only difference is that sp_attach_single_file_db automatically does some cleanup with replication. This only matters if you are doing replication and...


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

    August 22, 2003 at 8:28 am

    #470990

  • RE: Thanks for this site ! Any similar for DB2

    Just for the heck of it I typed the url http://www.db2central.com.

    I came up with a plain looking Login/Password page. It makes me wonder...

    Are there DB2 sites like this out...


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

    August 22, 2003 at 8:13 am

    #470981

  • RE: Finding & removing a space from a string

    Ok, last thing I'm going to say on this then I'll leave the dead horse for others to beat.

    Sure, you can do it without a while loop but when did...


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

    August 21, 2003 at 5:25 pm

    #470892

  • RE: Pet Peeves

    Senior DBA: Grey hair, cautious to the point of paranoia, never volunteers for anything not strictly database related and has a tendency to chitchat about normalization.

    Junior DBA: Younger, willing to...


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

    August 21, 2003 at 4:09 pm

    #470880

  • RE: Finding & removing a space from a string

    Now why did the multiple spaces get removed?

    'Have___a__Nice_day!' to

    'Have_a_nice_day!'

    When I wrote this originally I was scrubbing some data that had a ton of problems like this. It had been...


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

    August 21, 2003 at 3:43 pm

    #470873

Viewing 15 posts - 46 through 60 (of 92 total)