SQL Server 2012 does not come up after service pack upgrade SP4
A failed SQL Server Service Pack upgrade is fixed with a trace flag.
2020-07-27
3,526 reads
Service Packs
When a Service Pack or Cumulative Update Install Fails by Evaporating
Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.
2018-12-07 (first published: 2016-01-11)
5,772 reads
Vote Now: Final Service Packs for 2008/2008 R2
Microsoft has continued to release Cumulative Updates, with each one specifying that customers should wait for the next service pack if they don't experience an issue. However, no Service Packs have been released for some time. Let Microsoft know we want Service Packs.
2014-03-06 (first published: 2014-02-28)
4,471 reads
2010-09-30
5,572 reads
2010-01-04 (first published: 2009-12-30)
1,687 reads
2010-01-15 (first published: 2009-12-28)
79 reads
2008-04-24 (first published: 2008-02-28)
1,837 reads
SQL Server 2000 SP 3: What's New in Security
Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.
2005-12-09 (first published: 2003-06-05)
30,022 reads
Ways to Determine the Version and SP of SQL Server
There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.
2003-02-28
21,879 reads
Another SQL Server Virus Hits the Internet
On Friday the 24th, a virus that preys on a SQL Server vulnerability began to attack networks, taking down many networks. This brief network describes the virus and how to protect yourself from it.
2003-01-27
10,799 reads
Blogs
The PowerShell Basics If Statement–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
T-SQL Tuesday Retrospective #013: What the business wants
Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010...
Daily Coping 14 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Last day of the previous month - Format MM/DD/YYYY
I use the below to get Last day of Previous Month, but I want...
How to change schema of all tables, views and stored procedures in MSSQL
Hello Community, I trying to use the following sql code to change the Schema...
Changing SSAS TCP port directly in config file
Goodday, I have a problem with changing the TCP port for SQL Server Analysis...
Ask SSC