Thursday, March 22, 2012
cant add new columns to data tables
Hi All,
I am having a problem for which i dont find any reasons ..I hope to get a solution from here.
I have 2 tables ..1 with around 150 columns and the other with around 80 columns.I have view based on these tables.
The problem i m facing from yesterday is that i cant add /delete/change on these tables.If i make a change on these tables and hit the save button the sql server enterprise just hangs..i also tried to add the columns through the query but no results.
I cant even drop this view.
Please any help on this??
ThanksThe question is what type of view did you create? If it is updatable view you may have to update the parent table because a view is just a query rewrite that is persisted. Run a search for views and restrictions in the BOL (books online). I wrote a tutorial on SQL Server views a while back use my email in my profile for short info to get you started on resolving your problem. Hope this helps.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment