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 in place upgrade in sql server?
What are the joins in sql server? : sql server database administration
How to assign new column names in a view?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What are the advantages of paper records?
What is the difference between deallocate cursor and close cursor?
Why do you want to join software field as you have done your BE in Electronics?
what authentication modes does sql server support? : Sql server database administration
Tell me about joins in database system and explain each in detail.
Can you move the resources after pausing the node? : sql server database administration
What are the acid properties?
What do you understand by a stored procedure?
Differentiate between a having clause and a where clause.
How to list all field names in the result set using mssql_field_name()?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration