I'm trying to find something smart :) but let me first explain situation I've couple databases with the some structure Is there any way to run the same SSIS packages parallel against those databases . Ideally the packages should be controlled by master package
How to genericaly search the entire db for any text string in any stored procedure, function, table definition, agent job, etc. Any one command or anyone have a stored proc that does this wide search?
can someone please advise me on the correct syntax to bcp export executing a stored procedures results to xml I know it begins bcp "exe sp_procedure" queryout