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 |
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
which background process invoke at the time of upgradation tell me???
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent
What are the ways tablespaces can be managed and how do they differ?
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
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is ora 600?
what is a crs resource?
i had backup last manday.now i need back monday to now ..how do get backup?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?