standard edition it will only ever use one processor.

you can delete the older ones manually.

to set the no of logs kept right click on sQL server logs in SSMS and choose configure

maxdop is only available for index operations with enterprise edition

http://msdn.microsoft.com/en-us/library/ms189329(v=SQL.90).aspx

this thread is a year old people...............

has this feature been bought in just to make people used to oracle feel more at home?

🙂

as its a maintenance plan is it failing to delete the older backups or perhaps a permissions issue creating the .txt log file?

17883 errors are usual UMS scheduler hung. There is one UMS Scheduler per CPU. If they are all hung SQL will be unresponsive.

You could try getting in using the DAC...

thanks steve.

I take it the link to the simple talk article on adventurous DBAs is also an aprils fool! 🙂

just reporting in. Sorry I have not posted before but believe me the issues we have at work at the moment now is not the time to be asking the...

under the integrity checks tab there is a tick box that reads something like 'try to repair any errors'. Untick that.

you just want to check the database integrity without trying...

UMG, you talk about THE development server and THE production server, do you only have one of each? If that is the situation you can afford to apply and fully...

When you have a large number of instances to support patching them all every 8 weeks is out of the question. we don't have the DBA resources and the business...

opc_three is referring to using the -n switch (for native format) instead of -c.

This does not prompt for field formats either

if you use detach\attach you may end up with a different dbid which could affect the default database assigned to users, plus the owner of the database will change to...

works in all versions sql2000 - 2008R2

select loginname

from syslogins where sysadmin = 1