I realise this question was posted was some time ago, but I had the same issue recently, starting up MSSQL 2005 SP2. Basically my problem was that the MSSQL service...

Thanks Mark, I'm installing the Standard edition version. Frustrating if that is the case, thanks for your help.

Sam

Thanks JLK, no quite what I was after. You're correct in that the default directories can be set here for subsequent DB creates. But my biggest concern was the build...

Thanks for you reply Wayne,

If I have "Auto-Update Statistics" checked for my options, do I still need to run "sp_updatestats"? Would you know if I need to set my obects...

Thank you all for taking the time to respond, much appreciated!

Thanks for the input. My weekly maintenance tasks are:

1. Run update statistics on DB

2. Run DBCC on DB

3 Shrink DB

Is this the way to go about weekly DB maintenance? I...

Thank you for your reply Gift.

My stored procedure has three actions:

1. Dump database to local drive.

2. Copy database to remote server using xp_cmdshell.

3. Load dump onto database on remote server...

Thanks for you prompt reply Colin. Does anyone else perform defrags of there disc drives?

Thanks Mr Killer,

I think I maybe on the wrong wave length with using EXPIREDATE/RETAINDAYS. What I was trying to achieve was the deletion of the backup file after a...

Thanks for you help Norene. I think I maybe on the wrong wave length with using EXPIREDATE/RETAINDAYS. What I was trying to acheive was the deletion of the backup file...

I'd just like to thank all those that repliend to my query, I now have a list of all the servers on my network. Really appreciate the help, thank you very...