Thanks for the link. I was there before but could not see anything on unattended install of SP3. Look like it can only be done via Windows updates. Since we...

I just Googled it. http://www.sqlscripter.com/

Hello everyone,

I believe this will make everyone happy and there is not coding involved. Just search for SQLScripter. A gentleman has create a neat application to script out everything or...

Ok, just copy "Managing many SQL Servers?" (without the quotes) and paste it into the Search window (above and to the right) and clcik Go and then on the results...

Hello Joe,

Have a look at an article I created here called "Managing many SQL Servers?" and see if this works for you. Code is also provided.

Thanks,

Rudy

Excellent! Thanks Luke! This is what I'm looking for. Now I'll need to see if I can create a proc around this so that I can specify a job or...

sp_help_jobhistory seems to give you run_time but is this the duration or time started? I think it's in milliseconds.. I have to look more at this.

Thanks,

Rudy

Hello Luke,

Thanks for the info but I cannot seem to get the duration of the job. I can get when the backups were started but not the time it took...

Hello TRACEY,

Thanks for the info, but I'm looking some sort of script to execute. I don't want to do a manual process on over 80 servers.

Thanks,

Rudy

Hello Markus,

That seems to do the trick. Just strange why this is happening. Although, I have done refreshes before and the only way to get it to work is to...

Hello,

Just read this discussion and though that maybe what we do here may work for you. We monitor all production jobs via a web page report that is updated every...

We are currently using servers with multiple instance installed in which all are using the same port number (not default port number) and we are not having any issues. Could...

Great job and nicely done. We will be doing some log shipping soon and it's nice to know what to look out for.

Rudy

Oh, I see. Well SQL 2008 will not allow you to remotely execute code (via SSMS) to SQL 2000 and earlier. Why I'm not sure and I have not tested...

Glen,

This process/code works on all our SQL server. We are using versions 2000, 2005 and 2008 (we also has 7.0 and it work on that too). We also have a...