Forum Replies Created

Viewing 15 posts - 5,071 through 5,085 (of 7,164 total)

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Jeff Moden (10/13/2011)

    Needless to say, I prefer the "all in one place" aspect.

    There is merit in your argument for sure. I would press you for details initially, but as previously...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 13, 2011 at 10:35 pm

    #1394441

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Elliott Whitlow (10/13/2011)

    opc.three (10/13/2011)

    Elliott Whitlow (10/13/2011)

    Generally agreed, as far as misguided I do not.

    Given a particular system it may make as much if not more sense to handle the file...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 13, 2011 at 10:23 pm

    #1394439

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Elliott Whitlow (10/13/2011)

    opc.three (10/13/2011)

    Personally I think using the CLR functionality to access files from with a T-SQL context, while preferable over using xp_CmdShell, is still a misguided application of the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 13, 2011 at 5:18 pm

    #1394402

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Jeff Moden (10/13/2011)

    ...because of those dangerous recommendations, xp_CmdShell continues to receive a black-eye that it really doesn't deserve. ...

    I'll walk elbow-to-elbow with you on this idea any day. The results...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 13, 2011 at 5:06 pm

    #1394397

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Personally I think using the CLR functionality to access files from with a T-SQL context, while preferable over using xp_CmdShell, is still a misguided application of the CLR. It is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 13, 2011 at 11:06 am

    #1394230

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Jeff Moden (10/12/2011)

    opc.three (10/11/2011)

    An example might be calling a web service to cleanse, verify and standardize personal information like name, address and phone number before moving the cleansed data through...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 12, 2011 at 11:20 am

    #1393615

  • RE: public role revoke permissions

    What are you trying to do? What are you worried about the public role having permissions to do that you want to take away?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 11, 2011 at 1:31 pm

    #1393121

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Jeff Moden (10/10/2011)

    Nope... my comment wasn't directed specifically at you, Orlando. If it was, I'd have said, "Orlando, stop....". 😉

    Good to know...if you did say that I would stop,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 11, 2011 at 11:16 am

    #1393016

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Jeff Moden (10/9/2011)

    opc.three (10/7/2011)

    Please, have a look at PowerShell. Once you ramp up you will never want to open CmdShell again.

    Well I might especially if it's to fire off PowerShell...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 10, 2011 at 10:15 am

    #1392500

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    JeremyE (10/7/2011)

    An example of when you "have" to use it would be a requirement from a 3rd party. SAP requires xp_cmdshell be enabled and permission to execute it be granted...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 7, 2011 at 3:53 pm

    #1391994

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    jasona.work (10/7/2011)

    I have setup something that uses xp_cmdshell, although now that I've improved my knowledge and skills with SQL I can see other ways to do this without xp_cmdshell. ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 7, 2011 at 12:30 pm

    #1391926

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    I am happy you succeeded in steering them towards SQL Server. I am curious how they planned on solving this particular problem using Access.

    I get why you would landed on...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 7, 2011 at 12:27 pm

    #1391922

  • RE: Grant Delete on single table

    Agreed on using Database Roles. Triggers are a place to look to cover all bases but with a message like "delete is denied on the object" this points to an...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 6, 2011 at 10:39 am

    #1391318

  • RE: Grant Delete on single table

    Did you check for DENY on that table? What does this return?

    DECLARE @schema_name SYSNAME,

    @table_name SYSNAME ;

    SELECT @schema_name = 'schema_name',

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 6, 2011 at 10:20 am

    #1391303

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Evil Kraig F (10/5/2011)

    Heh, you're stretching an already stretched point there Orlando.

    In the scenario where SQL Express is leveraged to create an on-demand file loader and archiving application SQL Server...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    October 5, 2011 at 10:31 pm

    #1391063

Viewing 15 posts - 5,071 through 5,085 (of 7,164 total)