I want to check the database is set to full or simple recovery mode using C# and SQl queries.how do i check this?
SELECT DATABASEPROPERTYEX('name_of_the_database', 'Recovery');
WHERE name = 'name_of_the_database';
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?