היי חברים,
שיטה נחמדה
לבדיקת נתוניי SQL
Server
כגון : Product
Version ,
Service Pack
Number
וכו'.
1.
פתחו את ה-SQL Server Management Studio
2. פתחו דף
שאילתא חדש
3.
רשמו את השאילתא הבאה :
SELECT
SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')
והתוצאה לפניכם (דוגמא)
:
|
SQL Server 2012 Versions
|
|
|
RELEASE
|
PRODUCT VERSION
|
|
SQL Server 2012 Service Pack 1
|
11.00.3000.00
|
|
SQL Server 2012 RTM
|
11.00.2100.60
|
|
SQL Server 2008 R2 Versions
|
|
|
RELEASE
|
PRODUCT VERSION
|
|
SQL Server 2008 R2 Service Pack 2
|
10.50.4000.0
|
|
SQL Server 2008 R2 Service Pack 1
|
10.50.2500.0
|
|
SQL Server 2008 R2 RTM
|
10.50.1600.1
|
|
SQL Server 2008Versions
|
|
|
RELEASE
|
PRODUCT VERSION
|
|
SQL Server 2008 Service Pack 3
|
10.00.5500.00
|
|
SQL Server 2008 Service Pack 2
|
10.00.4000.00
|
|
SQL Server 2008 Service Pack 1
|
10.00.2531.00
|
|
SQL Server 2008 RTM
|
10.00.1600.22
|
בהצלחה !
רון נס.
============================================================================================================================================================================================================================================================
Hello
Friends,
Nice method
to test SQL Server data such as: Product Version, Service Pack Number etc..
1.
Open the SQL Server Management Studio
2.
Open a new query page
3.
Enter the following query:
SELECT
SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition’)
Here is the
result (example):
|
SQL Server 2012 Versions
|
|
|
RELEASE
|
PRODUCT VERSION
|
|
SQL Server 2012 Service Pack 1
|
11.00.3000.00
|
|
SQL Server 2012 RTM
|
11.00.2100.60
|
|
SQL Server 2008 R2 Versions
|
|
|
RELEASE
|
PRODUCT VERSION
|
|
SQL Server 2008 R2 Service Pack 2
|
10.50.4000.0
|
|
SQL Server 2008 R2 Service Pack 1
|
10.50.2500.0
|
|
SQL Server 2008 R2 RTM
|
10.50.1600.1
|
|
SQL Server 2008Versions
|
|
|
RELEASE
|
PRODUCT VERSION
|
|
SQL Server 2008 Service Pack 3
|
10.00.5500.00
|
|
SQL Server 2008 Service Pack 2
|
10.00.4000.00
|
|
SQL Server 2008 Service Pack 1
|
10.00.2531.00
|
|
SQL Server 2008 RTM
|
10.00.1600.22
|
Good Luck J
Ron Ness.
No comments:
Post a Comment