Forum Replies Created

Viewing 15 posts - 1 through 15 (of 24 total)

  • RE: How to run a file on a server thru SSIS

    As I mentioned, it works on the local machine and through a 3rd party app on another remote server.

    It's just the syntax the SSIS package is expecting is eluding...

  • RE: How to run a file on a server thru SSIS

    The .exe file accepts the username and password as part of the connection string when running it locally.

    For example:

    "C:\Program Files\McKesson\Supply Chain Management\BIN\BatchFMS.exe" username password

    I've also called it from...

  • RE: How to run a file on a server thru SSIS

    I am running into the same issue via SSIS. I am trying to run the following:

    Execuable: cmd.exe

    Argument: /c "\\he_interface_test\c$\Program Files\McKesson\Supply Chain Management\BIN\batchfms.exe" login password

    The executable will...

  • RE: Login Failure for NT Authority\System user

    I had a similar issue with the Mail Delivery service not sending emails and the Maintenance Cleanup task not deleting old BAK files on one of my servers. I...

  • RE: Maintenance Plan Best Practice

    You answered everything perfectly!

    Thanks for the peace of mind and the guidance!!

    +100 to Irish.

    😀

  • RE: Maintenance Plan Best Practice

    Thank you, that kind of solidified what I thought.

    I could not understand the rebuild after the reorg...

    Now, with that said, here are some follow up questions...

    Would it be better to...

  • RE: Maintenance Plan Best Practice

    GilaMonster (5/20/2010)


    Why do you want to shrink at all?

    The log files tend to grow rapidly over the course of a few weeks if unchecked. Is it better to run...

  • RE: Maintenance Plan Best Practice

    GilaMonster (7/1/2008)


    Loner (6/26/2008)


    Why not shrink the database?

    http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

    Sorry to resurrect this issue...

    Just looking for some general advice I suppose.

    We have a database where the vendor has several daily stored procedures that...

  • RE: Maintenance Cleanup Task Is not working

    homebrew01 (5/10/2010)


    Nothing jumps out. It's not something silly like you're path is to the TRN files but you're specifying BAK files ?

    I think the installation of SQL 2005 on...

  • RE: Restore Db from transaction Logs

    GilaMonster (5/6/2010)


    mckinnj1 (5/6/2010)


    homebrew01 (5/5/2010)


    The OP seems to be posting hastily without taking the time to properly explain the problem or the attempted solutions. If it's important, perhaps he/she will try...

  • RE: Restore Db from transaction Logs

    Going forward, I will try to be more detailed, but yesterday we had many things going on at once. I appreciate everyone's assistance in the matter who gave an...

  • RE: Restore Db from transaction Logs

    homebrew01 (5/5/2010)


    The OP seems to be posting hastily without taking the time to properly explain the problem or the attempted solutions. If it's important, perhaps he/she will try harder.

    Wow. ...

  • RE: Restore Db from transaction Logs

    Lynn Pettis (5/5/2010)


    Didn't know you could run DBCC CHECK DB against a .bak file.

    Were you able to restore the database itself as under a differnet name using the .bak file?

    I...

  • RE: Restore Db from transaction Logs

    Michael Valentine Jones (5/5/2010)


    mckinnj1 (5/5/2010)


    I don't believe so.

    When we restore the 1 month old BAK file with the ldf file, we get I/O errors when accessing some tables. I...

  • RE: Restore Db from transaction Logs

    I don't believe so.

    When we restore the 1 month old BAK file with the ldf file, we get I/O errors when accessing some tables. I am guessing this is...

Viewing 15 posts - 1 through 15 (of 24 total)