Forum Replies Created

Viewing 15 posts - 3,226 through 3,240 (of 9,715 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Audit report

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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)...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Need Query for Problem

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 3,226 through 3,240 (of 9,715 total)