Forum Replies Created

Viewing 3 posts - 16 through 18 (of 18 total)

  • RE: performance

    GilaMonster (2/18/2010)


    river1 (2/18/2010)


    Make a "inner join on x=Y" or make "select ..... where x not in (select y)"

    Unless I'm missing something, those will not return the same result.

    I was...

  • RE: Is xp_cmdshell Security threat???

    The short answer is yes, xp_cmdshell is a dangerous object to enable. There are several ways around using xp_cmdshell, and it would be worth your while to research your alternatives.

  • RE: Problems running exe within sql job

    I have always done this with WMI in a script task. WMI scripting allows you to assign a namespace, and designate impersonation levels, etc. I suggest using integrated security though,...

Viewing 3 posts - 16 through 18 (of 18 total)