How to determine the service pack currently installed on
SQL Server?
Answer / 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 |
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How can you control the amount of free space in your index pages? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is fill factor? : sql server DBA
what are the types of connection load-balancing?
How do you resize a data file?
what is the difference between catalog & nocatalog?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
one datafile is lost in standy side how can you recover that??
what is the difference between db2start command and start database manager command?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?