Upgrading to Microsoft SQL Server 2017

preview_player
Показать описание
Upgrading Microsoft SQL Server 2016 to 2017 Step by Step Guide
Рекомендации по теме
Комментарии
Автор

To the next guy:

SELECT
as 'Product Version',
as 'Product Level',
SERVERPROPERTY('edition') as 'Product Edition',
as 'CLR Version',
SERVERPROPERTY('collation') as 'Default Collation',
as 'Instance',
SERVERPROPERTY('lcid') as 'LCID',
SERVERPROPERTY('servername') as 'Server Name'

skvgaard
Автор

Thanks Buddy. You saved my day :) it also upgraded my 2014 to 2017

seharunnisa
Автор

Why not post your query in the description?

CK-ckut
Автор

Query:
SELECT
as 'Product Version',
as 'Product Level',
SERVERPROPERTY('edition') as 'Product Edition',
as 'CLR Version',
SERVERPROPERTY('collation') as 'Default Collation',
as 'Instance',
SERVERPROPERTY('lcid') as 'LCID',
SERVERPROPERTY('servername') as 'Server Name'

bigdeoxys
Автор

This music makes me feel like a hacker

alejandrovillalba
Автор

How did you select the features when it showed no features to upgrade

edithnyahmad
Автор

Hi, from the Maintenance button, there is also an option to upgrade version. What is the difference between upgrade option from your Installation button and the upgrade option from Maintenance button.

amg
Автор

as 'Product Version',
as 'Product Level',
serverproperty('edition') as 'Product Edition',
as 'CLR version',
serverproperty('collation') as 'Default Collation',
as 'Instance',
serverproperty('lcid') as 'LCID',
serverproperty('servername') as 'Server Name'


FAKE QUERY

praveenvaishnav