Jeff Moden (6/13/2011)

---

Understood. Thanks for the...

I tend to use SQLCMD (that is if PowerShell is not available to me :-D). We disable access and use of xp_cmdshell.

It is a good book to use for the exercises and practice exam. If you plan on taking both 70-432 and 70-450, there is not book out there from Microsoft...

That book is covered with errors and will not...

I would suggest at least getting service pack 1 installed on the instance. It has a fix for maintenance plans, I think being dependent on SSIS.

If a login is member of the BUILTIN\Administrators group on the server no, specific permission should not be required.

Found this over on StackOverflow.com that might work and lead you to a solution.

+1 She does have a way with words. 🙂

when does the recovery model ever change on the database to cause you to have that step?

S.K. (5/3/2011)

---

As for using WSUS, I never really looked into it, but some of our hosts are not internet-connected (behind firewalls), so downloading the patches directly would be a problem,...

A few questions, pure curiosity....

Why not use WSUS to deploy the service packs and CU for SQL Server? How does your shop handle the OS updates if you do not...

So yall tell me...

The poster on this thread, the one with all the letters after his name, opened himself up cause he put his blog address on his signature.

So you...

We cycle the error logs in SQL frequently so I don't show logs back to Nov...

Well considering that is an undocumented stored procedure I doubt you are going to get much help by putting a Connect item out there.

I checked a SQL Server 2005...

The...