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
what are user defined datatypes and when you should go for them? : Sql server database administration
How to create a large table with random data for index testing in ms sql server?
What is partition, how will you implement it? : sql server analysis services, ssas
Difference between group by clause and having clause in SQL?
Difference between 2NF &3NF ?
How to get a list all databases on the sql server?
How to make a column nullable?
how many bits ip address consist of? : Sql server database administration
What is the default schema of your login session in ms sql server?
How many columns can we include on clustered index ?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain about Views?
What are the recovery models for a database?
What is the difference between migration and upgradation in sql server?
How will you know when statistics on a table are obsolete?