Interested to Buy Any Domain ? << Click Here >> for more details...
How to determine the service pack currently installed on
SQL Server?
- 1 Answers
- 4325 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
The global variable @@Version stores the build number of the
sqlservr.exe, which is used to determine the service pack
installed.
eg: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17
2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service
Pack 3)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you trace the traffic hitting a sql server? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Why would you use sql agent? : sql server DBA
when does an alert gets signaled?
how can you create a user-defined lock?
how does an oracle clusterware manage crs resources?
Why does Oracle not permit the use of PCTUSED with indexes?
what is the use of ocr?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
How to start SQL Server in minimal configuration mode?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is grd?
What is a correlated sub-query? : sql server DBA
What purpose does the model database server? : sql server DBA
