Forum Replies Created

Viewing 15 posts - 4,411 through 4,425 (of 9,399 total)

  • RE: Running as SysAdmin

    Ivanova (12/23/2015)


    Also, if your company has a security team, make them your friends and allies. They can be incredibly useful in such a scenario.

    That's a huge benefit. If you...

  • RE: Running as SysAdmin

    Steve Jones - SSC Editor (12/23/2015)


    loyd.gravitt (12/23/2015)


    Here is the way the problem usually develops

    1) Developers begin developing an application and use sa on their personal copy of mssql.

    2) DBA warns...

  • RE: Difference Between cross apply and cross join

    Jeff Moden (12/24/2015)


    RonKyle (12/24/2015)


    That's a pretty jerk answer.

    Sorry, but I don't agree. Maybe it could have been phrased differently, although I don't see anything wrong with it. ...

  • RE: create stored procedure with if condition

    baiju krishnan (12/25/2015)


    when i tried to execute your code following error shown

    Msg 8117, Level 16, State 1, Procedure Sp_Login, Line 19

    Operand data type bit is invalid for max operator.

    I see...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/25/2015)


    Eirikur Eiriksson (12/24/2015)


    Brandie Tarvin (12/24/2015)


    Oh, has anyone stayed at a Hyatt recently?

    He he, cash only:-D

    😎

    I'm genuinely curious how you manage that when all the hotels demand credit cards...

  • RE: Number VS Letter

    Basurmanin (12/24/2015)


    Hello, 582444567

    Hello. Were you able to figure out the reason behind your restrictions?

  • RE: Number VS Letter

    I don't understand the restrictions either. ITVFs and CTEs are a part of SQL Server and can accomplish some great things, like your exact requirement. Above all else,...

  • RE: Byte Me: Private Cloud

    Alvin Ramard (12/23/2015)


    Eric M Russell (12/23/2015)


    Alvin Ramard (12/23/2015)


    Eric M Russell (12/23/2015)


    Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted...

  • RE: Running as SysAdmin

    Eric M Russell (12/23/2015)


    Indianrock (12/23/2015)


    How is SA ( with good password properly managed and not used by applications ) any worse than your own "admin" sysadmin login?

    Because it can be...

  • RE: Running as SysAdmin

    n.ryan (12/23/2015)


    That's possibly rather unpleasant. I'll have to check that.

    I can see it's use, but it's also rather dangerous...

    I would argue that having the sa account is one of the...

  • RE: Are the posted questions getting worse?

    Sean Lange (12/23/2015)


    It is hard to tell if the spammers or IWasBornReady clutters up the feed more. So many useless comments on QOTD from 10 years ago.

    I know what you...

  • RE: Byte Me: Private Cloud

    mjh 45389 (12/23/2015)


    Eric M Russell (12/23/2015)


    Eric M Russell (12/23/2015)


    mjh 45389 (12/23/2015)


    I was in a shop at the weekend and they were selling external hard drives as 'Private Clouds'! Things like...

  • RE: Today's Random Word!

    eccentricDBA (12/23/2015)


    djj (12/23/2015)


    Ed Wagner (12/23/2015)


    Grumpy DBA (12/23/2015)


    anthony.green (12/23/2015)


    Ed Wagner (12/23/2015)


    Sleep

    Deprived

    Fatigue

    Mistake

    Regret

    Resolution

    Solution

  • RE: Question of the Day for 05 Jan 2004

    Iwas Bornready (12/23/2015)


    It's been too long since I've worked in DTS. Totally forgot this.

    I don't miss DTS at all. BTW, you're posting a comment to a QOTD that's 11...

  • RE: Comparing data from two database for a list of selected tables more than 400 out of 1000+ tables

    So what products have you tried? I haven't used Red Gate's tool, but have heard good things about it.

    Please know that, given the volume of tables you're talking about,...

Viewing 15 posts - 4,411 through 4,425 (of 9,399 total)