Forum Replies Created

Viewing 15 posts - 46 through 60 (of 79 total)

  • RE: osql Cursor values to output file

    Perfect Jeff Thanks

  • RE: Bcp utility with Stored Proc

    Kenneth,

    Thank you for your reply.

    I have tried the following

    exec master..xp_cmdshell

    'sqlcmd -E -dVBAICMS_DEV -SNV-DEVSQL3\ASTRO -Q"exec SP_GENERATE_INSERTS ACM_CASE_TYP" -oc:\myTable.sql'

    but it doesnt give any insert statments, below is the output from...

  • RE: Bcp utility with Stored Proc

    Kenneth,

    Any luck I tried classifying the SP using 'use dbname' clause and dbname.dbo.tablename but wouldnt help.

    Any suggestion/inputs would help.

    Thanks

  • RE: Bcp utility with Stored Proc

    Kenneth,

    Thank you for the reply, thats exactly the problem - it is not picking up the tables name.

    I looked to include -d clause with database name in bcp command but...

  • RE: Bcp utility with Stored Proc

    Below is the snippet of the code the stored proc which uses charindex with substring. Is there something that I am missing ???

    As mentioned it throws the error only if...

  • RE: Bcp utility with Stored Proc

    Kenneth,

    Thank you for your reply.

    I am using sql server 2005, the stored proc is marked as system object.

    When I execute the stored proc from different database from management studio it...

  • RE: Bcp utility with Stored Proc

    Jeff, thank you for the reply but still doesnt seem to work. I get the same

    error. I am running out of ideas

    SQLState = 42000, NativeError = 536

    Error = [Microsoft][SQL...

  • RE: Bcp utility with Stored Proc

    Thank you for your inputs

    I will try it out, sp_generate_inserts code is from the following website.

    http://vyaskn.tripod.com/code/generate_inserts_2005.txt

  • RE: Bcp utility with Stored Proc

    any ideas guys ??

  • RE: Bcp utility with Stored Proc

    I get the following

    bcp.exe "EXEC vbaicms_dev.dbo.SP_GENERATE_INSERTS 'auth'" QUERYOUT C:\AICMS.sql -S NV-DEVSQL3 -q -c -T -eC:\AICMS.log -o C:\AICMS_out.log

  • RE: Bcp utility with Stored Proc

    Sp_generate_inserts runs fine from query analyzer - I dont think there is a problem with that its only when I usd as part of bcp utility it gives me error.

    ...

  • RE: Results to txt file

    David, Jeff, bledu

    Thank you for your reply.

    I have named as stored proc as SP_ since I created it as system stored procedure in master database. We need to use this...

  • RE: Error in Stored Procedure

    I am running the inner stored proc and outer stored proc with the same user - sa.

    Is there anythng I am missing?

    Thanks

  • RE: Setting Database level defaults

    Thanks guys, there is nothing wrong with the database defaults. But the I had to disable the database level trigger - ddldatabasetriggerlog which was causing the problem.

    Thanks again

  • RE: import table and data in compact edition

    Thanks for your reply.

    When I am trying to import data using merge replication I am getting 'charecter set' incompatibility error - the schema file for

    the table created in SQL...

Viewing 15 posts - 46 through 60 (of 79 total)