Its a bug with maintenance plans and jobs on SQL 2005 post SP2...I believe there is a hotfix for it...I went on to install build 4028 which is CTP for...

Did you reboot the server after patching??

Thanks!!

Depends on what type of RAID is the existing disk..and the performance would boost if it were to be moved to a disk with higher throughput..but first we need to...

Do you have IIS installed? If so is it on the DB server or on a separate app server?

Thanks!!

You just have 100MB of available memory...sounds like a bottleneck..but lets not stop there..what are the RAID configurations?

Is tempdb on a separate disk? What kind of activity goes on these...

4 GB of RAM is a dead rubber...I wouldn't be scratching my head why the server is slow...just ADD RAM..

Did you even check how much the BUFFER CACHE HIT ratio...

Check the SQL ErrorLogs and the Windows Event logs for any thing unwanted.

Thanks!!

Last but not the least would be troubleshooting issues as and when they come..well to be a good DBA, investigate the problem before the users call you..hey somethings wrong with...

Always have the backup handy..make sure there is no corruption of data...thanks!!

Iqtedar: Does your developer need to do a point in time restore with his database..only in that case does he need to put the database in full recovery mode..which calls...

Paul..I hope you are having fun during your holidays...I would like your insights on this issue once you are here please..thanks!!

Well Barry..it seems you just learnt a new thing in this New Year....:P

reddi..to create any object you would need to use the dbo ( database owner) role, but how do you intend to keep track of all the objects that this user...

Is this for a specific user account or for an app account??

If you don't want to give the syadmin role, then these are some of the options

CREATE DATABASE permission defaults...

What kicks off the report generating process? Are they stored at the same location..please provide some more details like are you using report server to create this?

Thanks!!