Thanks, our company doesn't allow automatic update on some of our application servers that hosts some in house developed applications, which include web server, application server and database server.

So it...

Thank you.

Thanks, when you say you windows update service,

do you mean you do it from

Control Panel\All Control Panel Items\Windows Update ?

What are the ways you do it

Thanks, for update,

I reinstall UA on the server that I want to upgrade, then it has no those errors.

But from my local workstation copy, or from other server to scan...

Thanks, I tested, it works without restarting.

Thanks all.

Thank you Chuck, I will give a try about this.

Perry Whittle (4/10/2012)

---

sqlfriends (4/10/2012)

---

So when you say your rename server, you do both rename computer name then use sp_dropserver and sp_addserver to rename SQl server name, correct? then after...

Never mind, I figure it out.

I don't want to post the table structure out for some reasons, but for this one I think it is simple enough and I do...

If you have a Typically what we do is get our new server up and running, restore backups of all databases, set up active subscriptions and inactive publications. Then, the...

Right now it is Page Life Expectancy 132

Is that...

Thanks a lot

I will download it and check into it. Thanks for the link

SQLRNNR (4/10/2012)

---

Well, what is your...