Perfect Jeff Thanks

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

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

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

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

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

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

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

any ideas guys ??

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

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.

...

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

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

Is there anythng I am missing?

Thanks

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

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