Forum Replies Created

Viewing 15 posts - 646 through 660 (of 7,164 total)

  • RE: In-Memory OLTP vs. streamInsight

    izzah100 (7/13/2015)


    New to "current data" processing and just trying to get my head around the two technologies:

    I understand streamInsight is for streaming data processing. It seams In-memory OLTP tried...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: T-Sql calling an .exe is working but problem with space in the path

    curious why you're calling powershell in a cmd shell to then turn around and call robocopy. why not this?

    DECLARE @sqlCmd varchar(300)

    set @SqlCmd = 'Robocopy C:\testSource "c:\test folder\ with spaces\final Destination"...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Problems importing CSV files using SSIS.

    Wow, some might call that a conspiracy theory ^_^

    As Danny Glover said...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Problems importing CSV files using SSIS.

    Jeff Moden (7/8/2015)


    Orlando Colamatteo (7/7/2015)


    Your argument against XML, JSON, even CSV with delimiters available on a 101 keyboard rings very similar to the assembler programmer that used to sit down...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Stored Procedue Schema Rights?

    Jayanth_Kurup (7/6/2015)


    OR you could have the EXECUTE AS SYNTAX within the procedure, the main thing is all procedures are not created alike, so each procedures and its execute permission needs...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Problems importing CSV files using SSIS.

    Your argument against XML, JSON, even CSV with delimiters available on a 101 keyboard rings very similar to the assembler programmer that used to sit down the hall from me...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

    mckinnj1 (7/6/2015)


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

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SSMS Maturity

    This (SSC) being primarily a community of folks that favor T-SQL I am not surprised at the piling on to SSIS and SSRS on a thread highlighting SSMS :hehe: To...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

    Make sure the called app isn't asking for user input, e.g. a login name or license required.

    If you run the app from a cmd shell directly under the same...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Stored Procedue Schema Rights?

    Sean Lange (6/26/2015)


    alex.sqldba (6/26/2015)


    Hi Guys,

    If I granted execute right to Schema1 for sp MyProc;

    And MyProc updates something in Schema2

    Will it work? Or will it fail as its a different Schema?

    Cheers

    Alex

    If...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SSMS Maturity

    There is hope. It is paramount to bring the server engine along but SSMS is what the users see and has helped differentiate the platform from other good platforms.

    I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: The Importance of Our Work

    It's important to meet each challenge with an appropriate level of urgency and attention based on it's importance and priority relative to all else going on. It can become all...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: job token

    In what context are you having trouble, a job step or an alert?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: The Case for Specifying Data Types and Query Performance

    MarbryHardin (6/23/2015)


    Or of course you could just call a stored procedure and avoid this issue correct?

    Nope...the same issue persists with stored procedures but to a far, far, far lesser degree....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: AlwaysOn Read-Only Replica Routing Problem

    Did you configure the read_only_routing_list on the primary replica?

    Can you confirm you can connect directly to the secondary's read only routing URL?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 646 through 660 (of 7,164 total)