Forum Replies Created

Viewing 15 posts - 6,136 through 6,150 (of 9,399 total)

  • RE: Running WinSCP in SSIS Task / .bat file

    jasona.work (4/30/2015)


    I'm 90% sure that DOS doesn't like single quotes around path / programs, it prefers double quotes.

    So instead of:

    'C:\Program Files (x86)\WinSCP\winscp.exe' /script=\\MyNASShare\SFTPFile.txt

    go with

    "C:\Program Files (x86)\WinSCP\winscp.exe" /script=\\MyNASShare\SFTPFile.txt

    Perfect, Jason, thank you....

  • RE: Today's Random Word!

    SQLRNNR (4/29/2015)


    Revenant (4/29/2015)


    Ed Wagner (4/29/2015)


    Eirikur Eiriksson (4/29/2015)


    Stuart Davies (4/29/2015)


    Eirikur Eiriksson (4/28/2015)


    Ed Wagner (4/28/2015)


    TomThomson (4/28/2015)


    crookj (4/28/2015)


    Ed Wagner (4/28/2015)


    Revenant (4/28/2015)


    SQLRNNR (4/28/2015)


    TomThomson (4/27/2015)


    SQLRNNR (4/27/2015)


    marlin

    spike

    hall

    fame

    Fortune

    Teller

    Automatic

    Tommy

    Gun

    Smoke

    Mirrors

    Reflect

    surface

    Pro 4

    Amateur

  • RE: DBCC Shrinkdatabase run every week?

    SQLRNNR (4/29/2015)


    It's been said nicely.

    I'll be blunt that these maintenance practices are piss poor. Whether physical or virtual, you should not be performing these tasks. I would have...

  • RE: Today's Random Word!

    crookj (4/29/2015)


    Ed Wagner (4/29/2015)


    djj (4/29/2015)


    Ed Wagner (4/29/2015)


    Eirikur Eiriksson (4/29/2015)


    Ed Wagner (4/29/2015)


    Space

    Distance

    Time

    Continuum

    Q (STNG reference)

    Q (007 reference)

    Sean Connery

  • RE: DBCC Shrinkdatabase run every week?

    Personally, I don't like Maintenance Plans. The brute-force approach to everything just isn't necessary. Also, there's no trapping of errors at all. If, for example, you have...

  • RE: Are the posted questions getting worse?

    GilaMonster (4/29/2015)


    Ed Wagner (4/29/2015)


    They're posting information about the cost of it. Let's see...we have a vessel free-falling to earth and they're concerned about the cost, no where it's going...

  • RE: Today's Random Word!

    djj (4/29/2015)


    Ed Wagner (4/29/2015)


    Eirikur Eiriksson (4/29/2015)


    Ed Wagner (4/29/2015)


    Space

    Distance

    Time

    Continuum

    Q (STNG reference)

  • RE: DBCC Shrinkdatabase run every week?

    Steve Vassallo (4/29/2015)


    No rational I can see. Its actually part of a maintenance plan they push out to all the servers. I am trying to get more information...

  • RE: DBCC Shrinkdatabase run every week?

    Well, I guess it makes sense to rebuild all the indexes. After all, the shrink fragments everything pretty well.

    I don't work with VMs, but I don't see why they...

  • RE: Identify/Map Application users in sql 2005 database

    The answers from Lowell in the duplicate thread are located here: http://www.sqlservercentral.com/Forums/Topic1681290-359-1.aspx

  • RE: Today's Random Word!

    Eirikur Eiriksson (4/29/2015)


    Ed Wagner (4/29/2015)


    Space

    Distance

    Time

  • RE: Identify/Map Application users in sql 2005 database

    metroman17 (4/29/2015)


    Is it possible to identify/map application users inside sql 2005 database?If yes, how?

    Yes, you can query the users from the database. When you say you want to map...

  • RE: Today's Random Word!

    Space

  • RE: Running WinSCP in SSIS Task / .bat file

    Brandie, a word of encouragement if I may. Your batch file is creating your WinSCP script file. You then invoke it by calling the WinSCP executable from the...

  • RE: Today's Random Word!

    djj (4/29/2015)


    Ed Wagner (4/29/2015)


    Revenant (4/29/2015)


    Ed Wagner (4/29/2015)


    Eirikur Eiriksson (4/29/2015)


    Stuart Davies (4/29/2015)


    Eirikur Eiriksson (4/28/2015)


    Ed Wagner (4/28/2015)


    TomThomson (4/28/2015)


    crookj (4/28/2015)


    Ed Wagner (4/28/2015)


    Revenant (4/28/2015)


    SQLRNNR (4/28/2015)


    TomThomson (4/27/2015)


    SQLRNNR (4/27/2015)


    marlin

    spike

    hall

    fame

    Fortune

    Teller

    Automatic

    Tommy

    Gun

    Smoke

    Mirrors

    Reflect

    surface

    Depth

    Measurement

    Build

Viewing 15 posts - 6,136 through 6,150 (of 9,399 total)