The warning is because SQL Server 2005 does not recognize W2K8. That OS was not around when SSK5 was released. So it warns you about potential issues.

Getting to SP3 will...

Which account? If you set a proxy for xp_cmdshell, just give it the rights needed.

If you change a service account, use the Configuration Manager. It will assign the correct rights...

Quotes are hard. It's why printing out the string is a good idea.

Glad it's working.

cold...

The problem with either solution is that you can break the client side easily.

I'd recommend that you use a set schedule so that people are aware when the db will...

I agree with Gail. I would run this daily on my system databases.

Please no more responses on modifying system tables. It's not safe, and in this case, it should not be done.

To InfiniteError, you cannot modify the transaction log after, nor...

I'll check and see. I'd have thought the "/" was universal, but changing to "-" shouldn't be hard.

We'll be correcting things soon. Some of the idea behind SQL Monitor was to show you what an average instance looks like at many companies. Both Brad and I have...

This white paper should help: http://msdn.microsoft.com/en-us/library/ee523927%28v=SQL.100%29.aspx

Note that what you need is a big limiting factor. What types of data loss, recovery interval, administrative cost, etc. can you talk about for...

print out your SQL, look at it, execute it in stages. You are getting a syntax error here.

I still think my old method of using scripts is a good one. It handles dependencies, and it integrates VCS with a release process.

Building a stored procedure for a release...

Good advice above. I'd also add that what you want will change as you mature. There is no "best" to recommend for anyone in general, but there is a "best"...

It came out when I was 9, so that's when I saw it (10 times).

I think my son watched it at 6 or 7, but my daughter managed to see...

WayneS (11/29/2010)

---

CirquedeSQLeil (11/29/2010)

---

On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business and make sure we have...