I'm trying to script stored procedures/functions and tables in Visual Studio
2005 by dragging the objects from the server explorer to the solution
explorer.
Problem is, it's generating the SP/Function code in a string variable and
calling sp_executesql to create it, whereas the "old" VS2003 use to script a
simple TSQL file.
Also, when tables are scripted they are scripted in one file, whereas the
"old" VS2003 use to create 4 file types, i.e. a .TAB, .FKY, .KCI and .EXT
file for each table.
If I use SQL Management Studio it does the same thing. If I chose the
database, right-click, All Tasks, Create Scripts I get a wizard screen,but
even that does not give me the options I want.
Is there a way to make it work like the previous VS2003?
Thanks,
Steve