4.0.1.0: check out generates wrong script
Brought to you by:
wmmihaa
When I double click a (check in) procedure, the
generated script also has a "if exists ... drop
procedure ..." part. But when I choose "Source control
> check out" the generated script misses this required
part! I first have to close the editor and reopen it
by double clicking the (now checked out) procedure
again: the required part is finally there.
Logged In: YES
user_id=1065916
When I re-coded the VSS portion for 4.0 my thinking was
that the drop portion of the stored procedure was not
really a part of the object for purposes of source
control. This is really a design question and perhaps
Mikael and/or Franz will decide to have all script actions
generate the same scripts. I would agree that it appears
to cause confusion when dbl clicking or checking out or rt
clicking a menu and getting 3 different sql outputs. BTW,
the default for Microsoft SQL Query Analyzer is to not
include the drop statements, but if you generate SQL from
enterprise manager, the default is to include the drop
command. Perhaps QC should have an optional flag that
allows the drop to be included or excluded globally.