Running the publish to provider wizard from Visual Studio 2010, if I want to only export the stored procedures in my database, I uncheck "Script all objects in selected database", then I select "stored procedures" then when presented with a list of stored
procedures I click "select all" - this is where I think the problem occurs. If instead of "select all" i manually select the check box in front of my 100+ SPs it works, if I use the select all however, I export all the tables and data as well.
It looks as if the select all is doing just that, selecting all SP's and tables, even thought the wizard only shows the SPs.
Maybe there is a VS2010 update to fix this bug? If not, there needs to be one :)
View Complete Post