Which command using Query Analyzer will give you the version
of SQL server and operating system?
Answer Posted / madhu
select serverproperty('productversion')
| Is This Answer Correct ? | 11 Yes | 9 No |
Post New Answer View All Answers
What is the recovery model?
How to create a large table with random data for index testing in ms sql server?
What is the use of floor function in sql server?
What is the difference between Clustered and Non-Clustered Index?
Can a table be moved to different filegroup?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What are the source of constraints?
How do I connect to sql server database?
Do you know what are acid properties of transaction?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
How to write a query with a full outer join in ms sql server?
What the different components in replication and what is their use?
How to delete an existing row with delete statements in ms sql server?
What are system databases into sql server (2005/2008)?
What are scheduled tasks in sql server?