• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

How do I delete records from a view in SQL Server 2000?

I tried "DELETE FROM view WHERE field=N'value'" but it gives me this:

view is not updatable because the modification affects multiple base tables.

I don't know where the view takes the records from.
0
datalink01
Asked:
datalink01
2 Solutions
 
chapmandewCommented:
you can put an INSTEAD OF trigger on the view.
articles.techrepublic.com.com/5100-10878_11-6113179.html
0
 
Anthony PerkinsCommented:
Why don't you post the View and we may be able to help you more.

What the error message is suggesting to you is that DELETE can only operate on one table at a time.
0
 
datalink01Author Commented:
N/A
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now