view scripting - what happened?

Hot Topic

Failure installing SQL Server 2005 SP 1
Measure expressions and currency conversion
Modifying a dimension by adding a new attribute using AMO
Authentication, windows or custom
Upgrade/migrate to new hardware. What's best?
MySQL function equivalent
Reporting Services 2005 : The report server cannot open a connection to the report server database
found the fix for the issue
Null Processing Option (analysis services 2005)
[OLE DB] how can i use IRowChange::Insert() to insert data ?

SQL Server

Using Teradata .NET data provider as data source
SQL Server 2005 - move system databases
Custom Sql Exceptions through the CLR
deleting sql server 2005 deployed packages?
Joining Table Operation
Installing onto Windows 2003 Server for multi-user application
How to Execute different Packages Sequencially
The connection manager 'OLEDB' is not properly installed on this computer
Does a checkpoint file record a package's state
Streams in SqlFunction

view scripting - what happened?

I just loaded 2005 Developer after using 2000 Standard for quite awhile. I went to script views using the new Server Management Studio and things are definitely different:

1) No ANSI / Unicode options; it looks like everything is Unicode (bad move).

2) All this extended property junk (EXEC sys.sp_addextendedproperty...) is now generated; is there any way to turn this stuff off And what is the point of it anyway

Thanks

Answer this question

view scripting - what happened?

Debbie112
Never mind - I found it. If you want to select options instead of taking the defaults you have to right-click the database containing the views, select Tasks > Generate Scripts..., then select the options & objects.
view scripting - what happened?

Answer this question