Generating SQL scripts in VS2005

Hi,

I'm using Beta 2 and I've noticed a difference in behavior between VS2005 and VS2003 when generating SQL scripts from database objects in Server Explorer. In VS2003, scripting a table results in separate files (TAB, KEY etc) for the table, indexes and so on. With VS2005 I just get one file.

Is it possible to switch the behavior back to generating mutiple files? If not, why was the behavior changed?

Many thanks in advance!Hi Ian,

Did you ever get an answer to this?

(I've got the same problem!)

Thanks,

Steve|||You should try a different forum. This is an SSIS forum.

Generated sprocs of VS2005

Can someone explain the generated sprocs of VS2005 if one column can be nullable

DependentOfSeqID = @.Original_DependentOfSeqID OR ((@.IsNull_DependentOfSeqID = 1) AND (DependentOfSeqID IS NULL))

In VS2003 the generated sprocs would be

DependentOfSeqID = @.Original_DependentOfSeqID OR ((@.Original_DependentOfSeqID IS NULL) AND (DependentOfSeqID IS NULL))

Which is the best?

I guess the 2 statements are the same: the first 1 uses a variable @.IsNull_DependentOfSeqID to determine whther the @.Original_DependentOfSeqID is null; while the 2nd directly compare it to null.