November 18, 2003 at 4:03 am
Hi,
I am getting an error when executing a procedure which tries to update a column in a table based on the data in a view. The view is created from another server database, as the data is to be centralized among other internal tools.
The error is
Server: Msg 50000, Level 16, State 16, Procedure Movement, Line 5
Sorry, you cannot update or delete the rows
I am not having any procedure by name "Movement" which is being shown in the error.
I am executing the stored procedure on a test server, which is having only this database with other system databases.
I am unable to find a solution. So i thought for having the correct solution from "masters" in SQL Server.
OS Windows 2000 Server
SQL Server 2000 (8.00.194)
Database (DBO use only mode)
Waiting for solution.
Ravi
Lucky
November 18, 2003 at 6:16 am
The table you are trying to update has a trigger called 'Movement' that uses RAISERROR to generate an ad-hoc error mesage if update attempted.
Far away is close at hand in the images of elsewhere.
Anon.
November 18, 2003 at 7:08 am
Bay the way 8.00.194 is the RTM version of SQL Server.
Don't you think you should update to SP3a?
* Noel
November 19, 2003 at 1:13 am
Sorry to be a thicko but what does RTM mean?
Helen
Helen
November 19, 2003 at 4:04 am
Hi
RTM = Shipping version of SQL Server with no service packs.
You should load Service pack 3a.
If it aint broke don't fix it!
Andy.
November 19, 2003 at 4:52 am
RTM actually stands for 'Release To Manufacturing'
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply