Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kbearhome
Starting Member
36 Posts |
 Posted - 2007-06-04 : 18:25:52
|
| I have created views but when I add a comment and save it, the comment goes away. What am I supposed to be doing to make the comment save? [Seemed so much easier to do a simple thing in 2000.]Thank you. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-04 : 18:36:53
|
| They should work fine..Can you post your view code?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-04 : 18:55:19
|
probably you are using the "design/modify view" GUI. it ignores comments I believe. If you write out a CREATE VIEW script by hand in the query editor, comments will be preserved. that is, they will be preserved if you script the view to file/clipboard/new query window:-- here is where the header would gocreate view MyView asselect a,b,c,d -- the columns i care aboutfrom mytable -- the table i care about
www.elsasoft.org |
|
|
|
|
|
|
Comment in view