Script to determine if you should update Build version

Posted by NeilHambly on SQL Blogcasts See other posts from SQL Blogcasts or by NeilHambly
Published on Wed, 15 Jun 2011 11:41:00 GMT Indexed on 2011/06/20 16:30 UTC
Read the original article Hit count: 458

Filed under:

SQL version Patching

Aaron Betrand has posted a great article on the Patch Tuesday Security Bulletin and I have quickly translated that into a SQL script to check your version and advise what you should be doing http://www.microsoft.com/technet/security/Bulletin/MS11-049.mspx Aaron's article: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/06/14/security-updates-for-all-supported-versions-of-sql-server.aspx#comments Naturally ANY Script needs to be carefully vetted before it is used in your own environments;...(read more)

Related posts about SQL version Patching

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
iPod OS version, Xcode version and Mac OS X version

as seen on Super User - Search for 'Super User'
Hello everyone My Mac OS X version is 10.5.8 Xocde 3.1.4 I hope to debug my app on the iPod Touch iPod OS version 3.1.3(7E18) Organizer told me that I need newest Xcode. I downloaded and try to install the newest Xcode, but it told me I need new Mac Os X. So I clicked my Mac mini's software update… >>> More
Get Last Version in TFS doesn't download the last version in Version Control

as seen on Stack Overflow - Search for 'Stack Overflow'
I have modified default.aspx. When I use Get Last Version in TFS 2005, it still keeps my local version. How to really get last version in Version Control ? >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Putting data from local SQL database to remote SQL database without remote SQL access enabled (PHP)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a local database, and all the tables are defined. Eventually I need to publish my data remotely, which I can do easily with PHPmyadmin. Problem however is that my remote host doesn't allow remote SQL connections at all, so writing a script that does a mysqldump and run it through a client… >>> More

Developer IT