Hi Ryan,

Unless you have a specific need to recreate the entire db from scripts, I would suggest a simple backup and restore of the db you need a copy of....

Hi Dial,

What error is returned? Is xp_cmdshell enabled on your instance? Provide as much information as possible.

Thanks,

AB

Hi, try removing the double quotes and use single quotes. 

Example -

EXEC master.dbo.xp_cmdshell 'osql -S. -E -dTest -Q"EXEC sp_generate_inserts 'OccRadiology','Fact',@debug_mode=1,@cols_To_Include='Ipsil' -w8000 -h-1 -o c:/Artifex/inserts.sql'

The double-quote character shouldn't be used...

Hi, I witnessed this behavior as well using a linked server. The group was granted access to both Sql Server instances, the linked server was setup to use "Be made...