Forum Replies Created

Viewing 15 posts - 19,351 through 19,365 (of 19,564 total)

  • RE: Are the posted questions getting worse?

    ooooh oooh

    Why did brave Sir Robin turn about and valiantly chicken out?

    Alternatively; If a train leaves Juneau AK heading due East, and a Train leaves Quebec heading due west. ...

  • RE: DBAs Pen

    That is good information.

  • RE: Are the posted questions getting worse?

    running is great - how many miles?

    I enjoy running - sick, hurt, tired, rain, snow, sun but not so much in the wind.

  • RE: How to find on which account SQL server agent is running

    Alternative method

    EXECUTE master.dbo.xp_instance_regread

    N'HKEY_LOCAL_MACHINE',

    N'SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT',

    N'ObjectName',

    @ServiceAccount OUTPUT,

    N'no_output'

    SELECT @Serviceaccount as SQLAgent_ServiceAccount

    Same principle

  • RE: DBAs Pen

    Lynn Pettis (9/9/2009)


    I find much value in getting published. Having authored 4 articles (2 here on SSC and 2 on SSWUG.ORG), I find it a way to give back...

  • RE: How can the domain of a SQL Server be determined

    I also forgot to mention another method:

    Ask the Engineering, Network, Server Admin team (whatever they are called at your work) what the domain for that server is.

  • RE: How can the domain of a SQL Server be determined

    Elliott W (9/9/2009)


    SET NOCOUNT ON

    DECLARE @Domain varchar(30)

    CREATE TABLE #cmdshelloutput ( outtext varchar(255) )

    INSERT #cmdshelloutput EXEC master.dbo.xp_cmdshell 'SET'

    SELECT @Domain = RIGHT(outtext, LEN( outtext ) - 11 )

    FROM #cmdshelloutput...

  • RE: If you weren't a DBA what would you be doing?

    SQL Iron Chef (9/9/2009)


    we could always be full time college students for life 😎 where's the party at!? :w00t:

    Ahh, but where will the money come from? Ma and Pa...

  • RE: Are the posted questions getting worse?

    Greg Edwards (9/9/2009)


    Jan Van der Eecken (9/9/2009)


    GilaMonster (9/9/2009)


    Silverfox (9/9/2009)


    No it isnt, Gail made some money by the sounds of it.

    No I didn't. No one local was willing to bet that...

  • RE: Are the posted questions getting worse?

    GilaMonster (9/9/2009)


    CirquedeSQLeil (9/9/2009)


    So my curiosity is if you live close to Durban or somewhere else.

    Durban? Hell, no. I'm in JHB.

    Well put.

    Thx

  • RE: Are the posted questions getting worse?

    GilaMonster (9/9/2009)


    Silverfox (9/9/2009)


    No it isnt, Gail made some money by the sounds of it.

    No I didn't. No one local was willing to bet that the pigeon would lose.

    Let's put it...

  • RE: Am I the only DBA

    Silverfox (9/8/2009)


    CirquedeSQLeil (9/8/2009)


    Laptop / Desktop - Yes. Laptop supplied by work is usually always a fight with the employers.

    Books - Yes. I buy my own.

    Certification - Not since...

  • RE: Are the posted questions getting worse?

    But maybe, just maybe, two european swallows flew to Mauritius, procurred a coconut and presented it to two african swallows. That solves that.

    Now if we only knew the avg...

  • RE: Am I the only DBA

    Laptop / Desktop - Yes. Laptop supplied by work is usually always a fight with the employers.

    Books - Yes. I buy my own.

    Certification - Not since SQL2000. ...

  • RE: If you weren't a DBA what would you be doing?

    Florian Reischl (9/8/2009)


    SQL Iron Chef (9/8/2009)


    The world would store their data in flat text files or excel spreadsheets lol :hehe:

    Wouldn't exist, too. CSV and Excel are just a lousy kind...

Viewing 15 posts - 19,351 through 19,365 (of 19,564 total)