Ian's script is exactly what I am looking for. It saves the efforts to record the restore history myself.

Dunnjoe's suggestion also makes sense. I will try that.

Thanks everybody.

My guess: For all rows, the database will have to run the "SELECT ItemID FROM dbo.GetChilds(@parentItem)", and spend extra time to get the value of @parentItem and pass it to...

Prasad is right. Sorry for the typo.

I suppose you have a 3-tiered system, and you just don't want users to see 20 fields in the GUI:

1. In your GUI, as Jon mentioned, you allow the user...

I prefer frequent backups than autogrows.

If your system is so busy that your transaction log grows quickly, you should also consider differential backups if you don't have yet. Of course,...

If I understand your question right (from Prasad's description), can you input the data after the report hass been produced? Or in other words, if non-PDF format is acceptible, why...

The same problems happended to me many times, and the reasons differed everytime. I agree with CDB that everything is possible, and I would start from checking the memory and...

Our memory stabilized at 1GB ava. memory and SQL is using 1.7 GB, which is fine for us. Thanks everybody! I will examine our databases and applications more closely so the...

Steve and Allen, thank you so much! I am looking for the reasonable memory size for OS and will assign an upper bound for SQL.

All our databases, including systems, are in total 13 gb.

We have sp 3a.

You can also try Data Driven Subscription.