Forum Replies Created

Viewing 15 posts - 4,216 through 4,230 (of 9,726 total)

  • RE: Add Job History Manually..??

    Are your execs logging into Integration Services and executing the package from the Stored Packages folder? Or are they running them from the child jobs?

    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.

    July 10, 2012 at 7:44 am

    #1510919

  • RE: SQL Agent Job succeeds even though step should fail

    So far as I know, it's not possible to pass an error outside of a jobstep to cause the job itself to fail. The error is only relevant inside the...

    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.

    July 10, 2012 at 7:30 am

    #1510907

  • RE: MSDB.dbo.sp_send_dbmail sending blank html body

    Thank you for letting us know. That will help with future questions.

    Glad you got it working.

    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.

    July 10, 2012 at 6:20 am

    #1510859

  • RE: Today's Random Word!

    Daniel Bowlin (7/9/2012)

    Heatwave

    Heatstroke

    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.

    July 9, 2012 at 7:06 am

    #1510315

  • RE: SSIS Possible File System Task problem

    Koen Verbeeck (7/9/2012)

    These are the types of bugs that can drive you really mad 🙂

    Tell me about it!

    Sure enough, same issue on the other packages that are having the exact...

    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.

    July 9, 2012 at 5:27 am

    #1510269

  • RE: SSIS Possible File System Task problem

    Oh, for the love of ...!#(*%$#W$

    I think I just found out what the issue is. EDIT: Forget the screenshots.

    I have a file that comes over from a vendor named MyFile...

    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.

    July 9, 2012 at 5:06 am

    #1510258

  • RE: Add Job History Manually..??

    GilaMonster (7/6/2012)

    While I belive you can insert into the job history tables (they're not system tables), it would probably be better if you created your own history tables for the...

    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.

    July 9, 2012 at 4:21 am

    #1510237

  • RE: SQL Agent Job succeeds even though step should fail

    mehmet.erbay (7/8/2012)

    Hi

    use

    "SET ANSI_WARNINGS OFF"

    in your stored procedure

    Can I ask what makes you think this will 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.

    July 9, 2012 at 4:07 am

    #1510233

  • RE: because it is being used for replication

    You said nothing about distribution, so here's a link. Check everything:

    http://technet.microsoft.com/en-us/library/ms152757.aspx

    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.

    July 6, 2012 at 12:33 pm

    #1509863

  • RE: last day of any year

    tim.cloud (7/6/2012)

    For my business, it begins on the first day of October and ends on the last day of the following September.

    In addition to what everyone else has already added,...

    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.

    July 6, 2012 at 12:31 pm

    #1509862

  • RE: because it is being used for replication

    What error is it giving you?

    I'm betting the distributor is still set up. Or the subscribers.

    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.

    July 6, 2012 at 12:15 pm

    #1509848

  • RE: Add Job History Manually..??

    I don't know how you can add an entire job history, but you can check the success / failure of a job and its individual steps by querying against sysjobs,...

    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.

    July 6, 2012 at 12:09 pm

    #1509844

  • RE: MSDB.dbo.sp_send_dbmail sending blank html body

    You may have to make the query dynamic SQL (stored in a variable) and execute the variable in order to get the Body = @tableHTML part of it working correctly.

    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.

    July 6, 2012 at 12:07 pm

    #1509841

  • RE: sql server2008 query- To split the delimited values in the table ibnto multiple rows

    bitbucket-25253 (7/6/2012)

    I would suggest reading Jeff Moden's aticle here on SSC at:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D

    Making it a clickable link. @=)

    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.

    July 6, 2012 at 12:00 pm

    #1509838

  • RE: last day of any year

    tim.cloud (7/6/2012)

    I need one that will always display the last day of the fiscal year.

    What is your fiscal year? And do you keep track of it in other ways in...

    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.

    July 6, 2012 at 11:57 am

    #1509834

Viewing 15 posts - 4,216 through 4,230 (of 9,726 total)