Forum Replies Created

Viewing 15 posts - 646 through 660 (of 7,168 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...

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

  • RE: Problems importing CSV files using SSIS.

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

    As Danny Glover said...

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

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

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

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

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

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

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

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

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

  • RE: job token

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

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

  • 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?

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