Thank you so much for all your suggestions. I appreciate it very much!!   

Thank you so very much for the responses!! This is what I needed to know.

Juanita

thank you very much. These are areas I have not even ventured into.

Juanita

HI.. Can you do this without enterprise manager? how would that work?

Juanita 

thank you, thank you !!!   it's so great to have all you guys out there in sql land!! 

At this time they do not have query analyzer installed on their pc.

THANKS !!!! PERFECT!

Juanita

I wasn't trying to accomplish anything in particular. I just happen to view the rowcount on a table and then I did a select and saw the difference in rows....

Thanks! i always thought the row count on the table properties were accurate.

So if I run sp_updatestats, would that show an accurate row count on the table properties?

Thanks,

Juanita

Thank you. I actually have been reading since I posted, pretty much the same consensus... I'll pass this article to the developer.

Juanita

Thanks so much !!! I'll look that up !!

Juanita 

Thank you so much ! Great advice

Juanita

HI ! Thank you sooo much!!! It all worked making the 'dummy' view. We had to go this route because of not being able to set up an oracle client....

Thanks so much ! I will have him give it a try !

Juanita 

HI. Well actually we have 1 account set up to access the linked server so i

had the option set so that any user not defined in the security tab you...