Post reply

Stored Procedure error.

  • November 18, 2003 at 4:03 am

    #83483

    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

    #482403

    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

    #482428

    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

    #482559

    Sorry to be a thicko but what does RTM mean?

    Helen


    Helen

  • November 19, 2003 at 4:04 am

    #482583

    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

    #482586

    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