Forum Replies Created

Viewing 15 posts - 5,056 through 5,070 (of 7,164 total)

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

    steveb. (10/25/2011)

    The poll does seem a bit skewed towards the positive,

    because the only answer if you 'do not cringe' is to pick 'whats wrong with it' ...

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

    October 25, 2011 at 9:51 am

    #1399196

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

    patrickmcginnis59 (10/25/2011)

    opc.three (10/25/2011)

    So far there are 43 responses to the poll with a breakdown as follows:

    60.47% of responses were I do too. There are so many different ways to get...

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

    October 25, 2011 at 9:14 am

    #1399165

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

    So far there are 43 responses to the poll with a breakdown as follows:

    60.47% of responses were I do too. There are so many different ways to get things done...

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

    October 25, 2011 at 8:07 am

    #1399131

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

    Jeff Moden (10/24/2011)

    BTW, Orlando... thanks for the link to "How Standards Proliferate". Now THAT's funny because it's oh-so true! 😛

    Haha, happy you liked it! It hit me dead center...

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

    October 25, 2011 at 6:29 am

    #1399064

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

    patrickmcginnis59 (10/24/2011)

    This discussion is pretty good except that I'm not really understanding the actual attack surface issue itself. The closest I could find on the web is that an attacker...

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

    October 24, 2011 at 5:13 pm

    #1398932

  • RE: Script error

    tempdb will be recreated anytime you restart SQL Server, however you may have issues with your I/O subsystem, a common source of DB corruption. Have you run DBCC CHECKDB on...

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

    October 24, 2011 at 9:37 am

    #1398761

  • RE: SSRS - Heat Spot report

    try searching for "heat chart" instead

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

    October 24, 2011 at 9:31 am

    #1398755

  • RE: Options to monitor file grow and shrink events

    GilaMonster (10/21/2011)

    They're in the default trace, so you can use that with no extra work required.

    That sounds good. I already have working code for reading the default trace into a...

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

    October 21, 2011 at 12:18 pm

    #1398172

  • RE: Options to monitor file grow and shrink events

    Elliott Whitlow (10/21/2011)

    I believe you could certainly run a server side trace for this but I am wondering why you are so concerned about these events.

    I have adjusted my auto...

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

    October 21, 2011 at 12:15 pm

    #1398170

  • RE: sqlcmd.exe is hanging after running sql statement in inno package

    WaitingWonder2 (10/18/2011)

    Hello,

    I'm write installation package using inno for ms sql script. I have the following code:

    strParam := '-U hel -P password -S ServerName -d...

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

    October 21, 2011 at 8:58 am

    #1398031

  • RE: Filtered Foreign Key

    Interesting. Your syntax is clean and intuitive. Playing devil's advocate, in thinking about sys.database_principals where groups and users exist together and both share the same set of surrogate keys, I...

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

    October 20, 2011 at 4:06 pm

    #1397690

  • RE: public role revoke permissions

    This post seems relevant to your situation: http://blogs.technet.com/b/fort_sql/archive/2010/02/04/remove-public-and-guest-permissions.aspx

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

    October 14, 2011 at 8:09 pm

    #1394896

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

    rmechaber (10/14/2011)

    Thanks for the reply. Let me respond bit by bit:

    Why not spend that time coding a PowerShell script where you can move across the boundaries of the file...

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

    October 14, 2011 at 10:38 am

    #1394771

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

    Jeff Moden (10/14/2011)

    @opc.three,

    What's funny about all of this is that xp_DirTree, xp_CmdShell, xp_FileExists, etc, etc, etc all live in a single DLL called XPSTAR.DLL.

    XPSTAR.dll, not sure why that is amusing...

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

    October 14, 2011 at 10:13 am

    #1394750

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

    rmechaber (10/14/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 CLR....

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

    October 14, 2011 at 9:24 am

    #1394712

Viewing 15 posts - 5,056 through 5,070 (of 7,164 total)