Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 7,164 total)

  • RE: x-cmdShell access

    Lynn Pettis (9/19/2012)

    opc.three (9/4/2012)

    Jeff Moden (9/4/2012)

    opc.three (9/4/2012)

    All sysadmins can execute any commands they wish and those commands will run in the context of the SQL Server service account, i.e. you...

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

    September 19, 2012 at 9:43 am

    #1539644

  • RE: How do I use one column for node names and the others for elements in that node?

    Jeff Moden (9/18/2012)

    And some folks wonder why I/O is one of the biggest bottle-necks on some servers. Imagine what it would cost to get a 300% improvement by changing...

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

    September 19, 2012 at 8:06 am

    #1539583

  • RE: How to copy last line of .txt file into new .txt file?

    Happy you got something going. I didn't mention tail.exe because it's not technically a PowerShell solution, but if you're open to using an external exe here is a sourceforge project...

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

    September 19, 2012 at 7:54 am

    #1539574

  • RE: x-cmdShell access

    Jeff Moden (9/19/2012)

    Sorry, lost track of this thread...

    opc.three (9/5/2012)

    Jeff Moden (9/5/2012)

    Examples of why I'd want to use xp_CmdShell are two fold.

    The first is cost. It's not likely...

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

    September 19, 2012 at 7:44 am

    #1539567

  • RE: How to copy last line of .txt file into new .txt file?

    Fly Girl (9/17/2012)

    Windows Server 2008 R2

    I'm totally new to PowerShell but was trying to use it to solve an issue with data files that come with the last row being...

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

    September 19, 2012 at 7:19 am

    #1539537

  • RE: Ownership Chains, Dynamic Queries, and SQL Injection

    Dynamic SQL does break the ownership chain established when exectuing the proc. A new ownership chain can be established later in the call stack but at the end of the...

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

    September 17, 2012 at 7:24 am

    #1538594

  • RE: Excel Connection Manager error in SSIS 2012

    Thanks for posting back the root cause so others can benefit. The Excel driver built-into SSIS is a 32-bit Jet 4.0 driver which cannot be used in 64-bit mode so...

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

    September 17, 2012 at 5:36 am

    #1538529

  • RE: Powershell for network path

    bwperrin (9/13/2012)

    "cd c:" works! Thanks!!

    What build are you on?

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

    September 13, 2012 at 6:56 pm

    #1537594

  • RE: Logshipping is not working.

    Perry Whittle (9/13/2012)

    For details of how a diff resumes an LS plan see the start of my article at this link

    Humble pie anyone?????????? 😉

    Perry, I am quite certain...

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

    September 13, 2012 at 1:40 pm

    #1537448

  • RE: Memory Leak SQL 2008 R2 64 bit?

    ananda.murugesan (9/11/2012)

    TotalServerMemoryMB - 3270.125000

    Thank you. This confirms what was mentioned before. At present there are no indicators that anything out of the ordinary is occurring in terms of how much...

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

    September 11, 2012 at 1:23 am

    #1536023

  • RE: Memory Leak SQL 2008 R2 64 bit?

    ananda.murugesan (9/10/2012)

    Thanks for your valuable reply. I hope, i am going to correct path for fixing memory related issues.

    All we have established so far is that your SQL Server eventually...

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

    September 11, 2012 at 12:11 am

    #1536012

  • RE: Memory Leak SQL 2008 R2 64 bit?

    Thanks for posting some results but now that we know you have lock pages in memory (lpim) enabled the process list is not going to tell us anything of much...

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

    September 10, 2012 at 11:17 pm

    #1536006

  • RE: Help!... Memory Use on Windows 2008 R2, SQL Server 2005 x64. The physical is 98%

    Chances are you have 'lock pages in memory' enabled which prevents memory SQL Server allocates to the buffer pool from showing in Task Manager. Same symptoms: http://www.sqlservercentral.com/Forums/FindPost1356979.aspx

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

    September 10, 2012 at 5:28 pm

    #1535963

  • RE: Not View Any DB Other than The One He Has Access

    Phew, another mystery averted 😛

    Thanks for posting the rest of the story Clare!

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

    September 10, 2012 at 5:22 pm

    #1535961

  • RE: Memory Leak SQL 2008 R2 64 bit?

    Of course! I did not even think to ask if lpim was enabled. Most people do not turn that on with x64 without a reason. That must be it.

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

    September 10, 2012 at 1:47 pm

    #1535905

Viewing 15 posts - 3,166 through 3,180 (of 7,164 total)