Which command using Query Analyzer will give you the version
of SQL server and operating system?

Answer Posted / koti-khammam

exec xp_msver

Is This Answer Correct ?    11 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference between primary keys and foreign keys?

546


What is SQL Azure Data sync?

105


How to drop an existing table?

557


What is best institute to Learn DotNET And SQL in chennai?

1696


What method is used by the Command classes to execute SQL statements that return single values?

606






What happens to a trigger with multiple affected rows?

534


What are the advantages of user defined function?

499


List out the differences between global and local temp tables in sql server?

580


Do you know what is bit data type and whats the information that can be stored inside a bit column?

558


How do I view a trc file?

507


How to insert multiple rows with one insert statement in ms sql server?

588


what are different types of raid configurations? : Sql server database administration

490


Why do we partition data?

622


How many columns can exist together per table?

712


Can you type more than one query in the query editor screen at the same time?

579