Error Getting -244 (Due update in systable)

dicipulofer · #1 (**permalink**) 01-15-08, 12:11

Hello...

I'm trying to chage my table to row lock (was in page lock)...

I heard about update in systable the field locks..... but afte I did this,my application's getting this error (-244)...

How I change one table from page to row ?

Thanks.

mjldba · #2 (**permalink**) 01-15-08, 12:28

alter table <table_name> lock mode (row)

ceinma · #3 (**permalink**) 01-15-08, 12:29

never ever....ever....ever... you do a update/delete/insert over any SMI (sys*) tables....

To alter the lock mode:

Code:

alter table tab_xyz lock mode (row)

you already shutdown you IDS and restart to stopping these errors?

dicipulofer · #4 (**permalink**) 01-15-08, 12:51

I guess It's ok now.. thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech