I was in the wrong database, you are right, I am still not used to changing databases. Sorry!

Sorry, didn't check the deny permissions, he had been denied permission to write. That took care of deleting. I guess denying a person write permission does not allow...

How do I update statistics?

OK, here is why I need to get the full text for each SPID.

I wrote stored procedure that will give me the amount of CPU and I/O used over a...

Thanks guys, I liked both answers, but the sp_msforeachtable can be very handy.

One more question:

How can I check the full text of the sql statement that is being...

Actually I just remembered that we changed the passwords in our databases/servers yestearday and this could be the reason for the failure. Can someone tell me where I go...

I want to know what is the page size of the memory pages. I look in the Enterprise Manager/Current Info/Process Info and the Memory Usage Column shows very little...

How can I check the memory page size?

Thank you!

We are using SQL 2000.

Other than sp_helpdb, is there any function I can run?

Thanks for the fast response Steve!

Yesterday I printed the BOL pages about sp_dboption and sp_configure and studied the different settings that can be set. But the BOL did not...

Just to update everyone on the situation, I am running three different Profiler sessions checking on different things and I have also created a delete trigger. Since yesterday morning,...

I need your help on something. I know how to create a trigger, but I wanted to capture some important information such as who (users/system process) is deleting my...

Thanks a lot for your help guys. I loaded the table several time last night and sometimes the data would not be there right after DTS was finished loading....

Damn!

This morning (around 9:00 am) I loaded the table again, checked it periodically all day to see if the data will be deleted. It is now 7:30 pm and...