I was able to figure out that 2=tempdb, 1=file id, 128=page id.

Thats a very interesting article that may apply to a problem we are having. It refers to the resources 2:1:1 and 2:1:3 and gives a little info on what they...

Thank you very much!!!

Huh?

I thought you could only loop through a table with a cursur. Could you post some sample code?

Thanks.

I'll forward this to the engineer working on it. They don't give me permissions to run task manager or perfmon

That's one of the things we are looking into.

Thanks.

We have several hundred databases in our server farm and it is alot easier to create a maintenance plan that hits all the user databases. I just wanted to make...

This can be a real hassle. I have had a couple of customers on MSDE have this happen. Once it hits the limit, you can't do any query operations at...

I work with Windows and we're always bitching and moaning about its shortcomings. But a college professor I know uses Macs in his home office, and whenever I'm there, he...