c****o 发帖数: 265 | 1 I can use the sql
SELECT recovery_model_desc
FROM sys.databases
in 2005, but now i have a 2000 db, i cannot find this value in sysdatabases.
anyone knows? thank a lot! | z***y 发帖数: 7151 | | c****o 发帖数: 265 | 3 your solution is so cool! this sql gets lot of things and i ll take this
down.
Thank you!
I found another one also helpful:
SELECT
DATABASEPROPERTYEX(Name,'Version')
FROM
master..sysdatabases
WHERE Name = 'db_name'
lucky me :) |
|