Viewing 11 posts - 61 through 71 (of 71 total)
Thanks, do you think I should treat the tempdb the same as the other databases and put the data file on F and Log on G?
November 15, 2007 at 1:29 am
The way I did it was to run profiler from my PC monitoring only the databases I thought were not in use to see if anyone was using them.
November 14, 2007 at 9:21 am
You should size the Tempdb to a size it uses on a regular basis, if you log size stats you should analyse these to determin what size it should be,...
November 14, 2007 at 8:02 am
Thanks, I think I fixed it by removing the ones that wouldn't work and creating new ones however I don't trust it to work reliably as it seemed like such...
November 6, 2007 at 8:57 am
Do you mean you just want to gather some standard information from each server at your company?
The simplest thing to do would be to write a script to do things...
November 5, 2007 at 9:44 am
It is, it just appears to be certain alerts, I think I might delete them all and recreate them.
November 5, 2007 at 9:38 am
I added a different alert to be set off by a different error number and this works, appart from the error number the alert is configured exactly the same, even...
November 5, 2007 at 8:46 am
Yes, they're all genrated from a job that runs an SP.
November 5, 2007 at 5:16 am
When you say default global mail profile what do you mean, I've tried reconfiguring this a few times but each time I get the same results. I'm using the...
November 5, 2007 at 4:09 am
Even if you have owner rights on msdb you still can't view any maintainence plans or jobs, you need to have sysadmin.
November 2, 2007 at 2:41 am
You can only see Maintainance Plans if you have sysadmin, if you create a test user and keep assigning it different Server Roles and keep re-connecting you can see what...
October 30, 2007 at 8:26 am
Viewing 11 posts - 61 through 71 (of 71 total)