Which function is used to know the database property in SQL Server.

 Posted by Abhisek on 2/26/2010 | Category: Sql Server Interview questions | Views: 2382
Answer:

DATABASEPROPERTYEX(dtabase,property)
It will return the specified property of the specified database.
Example:-
SELECT DATABASEPROPERTYEX(Student,Version)
-->365

You can use this function to know other properties of your database.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response