Thanks for your input. I think SQL server commits the transaction by default on the management studio when I run the select query:

select * from invntry_adj with (tablock,holdlock)

...

This is exactly...

Thanks again for all your help.

There is a foreign key constraint on the table CRI to parent table ANJ and the application needs the constraint.

For one program, the...

THanks for your replies. But I think delete restrict will prevent the parent rows from being deleted.

My criteria is when the parent rows are deleted, I dont want the...

I've asked our admin to look into the issue and he is going to reboot the server if necessary..

Thanks for your replies..

Yes, I get the same error with all the tables in all the databases on that server..

But it works fine when I open the table from my pc...

Thanks a lot for the information.

Also, though I know Master database is being used by all the other databases in the SQL Server 2000, our client use master database specific to each database. In this...

Thanks. I just tried using the unique index:

CREATE UNIQUE INDEX numwrk_itm_reprn_no

ON numwrk

( itm,

CASE

WHEN itm IS NOT NULL

THEN reprn_no

ELSE NULL -- This is the default, so you don't really have to...

Thanks. But the sys.objects does not have status column in it?

Hi,

I just looked at the SQL Code on the application side. It is a 50lines code and straightforward, basically does:

select * from mlist where col1= value, col2=value

...

Hi JP, thanks for the link. But I still do not know how I can get through this. Is it specifically because of GetChunk method?? I'm also not sure what...

I changed the numeric to (11,2) and it worked.

Thanks much.

Thanks Ehsan. I tried the view but I'm getting this below error:

Arithmetic overflow error converting varchar to data type numeric.

I appreciate your help. Thank you.

Hi all,

I have the below view created:

create view text_vw (itm, sile, eqty) ...