Forum Replies Created

Viewing 15 posts - 3,211 through 3,225 (of 9,703 total)

  • RE: Add Reference to SSIS 2008 package

    Brandie Tarvin (4/21/2014)


    How do I figure out what the problem is when I add a reference and it has the yellow warning next to it?

    Nevermind. I'm in brain-dead mode this...

  • RE: Add Reference to SSIS 2008 package

    How do I figure out what the problem is when I add a reference and it has the yellow warning next to it?

  • RE: Add Reference to SSIS 2008 package

    Eirikur Eiriksson (4/21/2014)


    Open the Script Task Editor and choose Edit Script. In the VSTA editor, select Project menu and Add Reference...

    😎

    Oh, good grief. I'd never have found that. Thank you.

  • RE: Sorting

    The thing about ordering is that it never works quite the way you expect. The individual columns are all associated with one record, so you can't get every column to...

  • RE: Audit report

    The column you are looking for is type_desc in sys.server_principals.

  • RE: Need Query for Problem

    vignesh.ms (4/19/2014)


    this is not the fine answer & also not mine...

    You were not asked to post someone else's code. You were asked to post what you tried.

    If you are unwilling...

  • RE: xp_create_subdir for non-sysadmins

    Regarding the error... Are you sure that the accounts you are using have FULL CONTROL on the share where you're trying to create the subdirectories?

    Definitely (just for kicks and giggles)...

  • RE: Need Query for Problem

    AWESOME! Thanks for that link. Gail, as always, does wonderful work.

  • RE: sql server and ram

    Perry Whittle (4/18/2014)


    Brandie Tarvin (4/18/2014)


    But none of us recommend you lower the max memory setting unless you know the consequences.

    You would do if your server starts blue screening because...

  • RE: Need Query for Problem

    vignesh.ms (4/18/2014)


    Brandie Tarvin (4/18/2014)


    This sounds like a contest or homework problem to me.

    Should be mixture of all products..

    I'm eagerly waiting for the query....

    Pls try it out..

    Sorry. I don't do other...

  • RE: EXECUTE permission was denied

    If the error is happening because a proc is called inside another proc (or something like that) and you have permissions to see the proc, running this little code snippet...

  • RE: Simple view question regarding indexes

    NineIron (4/18/2014)


    if the underlying table(s) is not indexed or poorly indexed (I have little control over this), will an indexed view work to speed up performance?

    Yes and no. The problem...

  • RE: sql server and ram

    Perry Whittle (4/18/2014)


    Tony Sweet (4/17/2014)


    It does not release RAM until you cycle the service or the OS tells it to give up the RAM.

    or if you lower the max memory...

  • RE: DROP USER or sp_dropuser

    My w.a.g. is that probably a brackets issue. Domain\User usually needs to be surrounded by square brackets [Domain\User] or it causes issues in the drop statements. It appears at first...

  • RE: 1 Server multiple instances or 1 instance or even Multiple servers?

    I mostly agree with Grant, but I would put the Reporting database on the same instance as the non-mission critical (and rarely used) databases. That way any reporting doesn't interfere...

Viewing 15 posts - 3,211 through 3,225 (of 9,703 total)