Forum Replies Created

Viewing 15 posts - 3,751 through 3,765 (of 9,715 total)

  • RE: Query runs with error when passed parameters

    GilaMonster (1/8/2013)

    Brandie Tarvin (1/8/2013)

    GilaMonster (1/8/2013)

    I thought you said you were calling the exact piece of code as you gave above, with the declare and set in it?

    Gail, believe it or...

    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.

    January 8, 2013 at 10:27 am

    #1574926

  • RE: How to know which DTSX file was deployed in a server.

    Glad you got it worked out.

    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.

    January 8, 2013 at 9:33 am

    #1574904

  • RE: Query runs with error when passed parameters

    GilaMonster (1/8/2013)

    I thought you said you were calling the exact piece of code as you gave above, with the declare and set in it?

    Gail, believe it or not, that additional...

    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.

    January 8, 2013 at 9:32 am

    #1574903

  • RE: Query runs with error when passed parameters

    Glad I could help. @=)

    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.

    January 8, 2013 at 9:31 am

    #1574902

  • RE: How to make group of continuous tasks to execute based on single condition

    Then my original suggestion of using Sequence Containers and precedence constraints (with expressions) should work for 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.

    January 8, 2013 at 9:30 am

    #1574899

  • RE: Question regarding msdn.dbo.sp_add_jobschedule

    2008 SP2 version (just in case).

    CREATE PROCEDURE sp_add_jobschedule -- This SP is deprecated. Use...

    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.

    January 8, 2013 at 9:28 am

    #1574896

  • RE: Query runs with error when passed parameters

    Fair warning. I only know the barest bit about SAP because I work with someone in another state who uses it. That being said, does this article help?

    http://scn.sap.com/thread/1703641

    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.

    January 8, 2013 at 8:01 am

    #1574837

  • RE: Full Backup stopped prior to completion

    Have you verified that the drive has enough space for the backup to even save? I know files don't always "stick around" if the space to save them doesn't exist.

    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.

    January 8, 2013 at 4:47 am

    #1574749

  • RE: SQL Agent Job - T-SQL Job Step Question

    Thanks. I appreciate the answers. Now I need to figure out why it seems to the BU that they are running asynchronously.

    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.

    January 8, 2013 at 4:31 am

    #1574740

  • RE: Full Backup stopped prior to completion

    As GSquared said, check the Windows logs. Application specifically. And the SQL Server Agent log (just in case).

    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.

    January 7, 2013 at 12:06 pm

    #1574470

  • RE: Are the posted questions getting worse?

    jasona.work (1/7/2013)

    SQLRNNR (1/7/2013)

    Brandie Tarvin (1/7/2013)

    Windows 8 Pro is on sale for $40.00 (U.S.) through the end of the month. It's a download.

    http://windows.microsoft.com/en-US/windows/home

    :sick:

    It's not that bad...

    I've been using it here at...

    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.

    January 7, 2013 at 11:50 am

    #1574463

  • RE: Are the posted questions getting worse?

    Windows 8 Pro is on sale for $40.00 (U.S.) through the end of the month. It's a download.

    http://windows.microsoft.com/en-US/windows/home

    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.

    January 7, 2013 at 7:17 am

    #1574296

  • RE: Are the posted questions getting worse?

    jcrawf02 (1/3/2013)

    Yowch

    All Ruby On Rails versions suffer a SQL injection vulnerability

    I don't know Ruby, but that sounds like a doozy.

    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.

    January 4, 2013 at 7:13 am

    #1573737

  • RE: Need some help with a query

    So you're getting the data you need now?

    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.

    January 2, 2013 at 12:19 pm

    #1573040

  • RE: Need some help with a query

    Patrick, look up Table Aliases in Books Online. You can indeed join the same table multiple times, but you can't have two tables with the same naming reference.

    Table Aliases should...

    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.

    January 2, 2013 at 12:03 pm

    #1573034

Viewing 15 posts - 3,751 through 3,765 (of 9,715 total)