I am having a weird situation, Several tables through enterprise Manager will not open to show all records I am getting a timeout. The weird thing is I can open a top N to a point. however if I go one over I get that timeout. Also if I run a select * on this table in Query analyzer It just keeps running with no results. Our machine is a 2GB Ram Dual Processor 1.5 Ghz Cpu Any help would be appreciated. Also I am having Problems Deleting records from some of these tables.