I have a very strange occurance, we set up a new Win 2008 IIS server and started to move over programs. the issue we are having is when it come sto loading some datatables in our asp.net project. I can run the sql query and it works for every person I run the query on the page. but when I do a table coutn to make sure something is there sometimes the rcord is there and sometimes it is absent. But for everyrecord I can find in the db, but its like it does not load into the table, some do some do not. If i push it back to my 2003 web server it all works just fine. So I am assuming it has to do with the Win 2008 iis server and something is not set up correctly.