Upgrade SQL Server 2014 Standard to Enterprise
This blog is about upgrading SQL Server 2014 Standard Edition to the Enterprise Edition. This blog looks & sound much like my October 2013 post, “Upgrade SQL Server 2012 Standard … Continue Reading →
Tag: SQL Server
dm_tcp_listener_states DMV Altered to be Readable
The sys.dm_tcp_listener_states DMV was introduced in version SQL Server 2012. This is a great DMV because the SQL Configuration Manager does not have to opened to find these values. However … Continue Reading →
Upgrade SQL Server 2012 Standard to Enterprise with Different Service Packs
In October 2013, I wrote about how to “Upgrade SQL Server 2012 Standard to Enterprise“. Recently in the comments section, Leo asked “Is this impacted by service packing?”. This is … Continue Reading →
BCP with No Output & No xp_cmdshell
My problem was that I needed to create a cvs file with an older version of a SQL Server database. My plan was to use the BCP utility to create … Continue Reading →
Script to change the SERVERNAME property in SQL Server
When the Master Database is restored or moved to another server with with a different hostname, the master database is unable to detect that it is on a new server. … Continue Reading →