Using 'Read Only' as an example -
-- SQL 2000 -
select name from sysdatabases where databaseproperty(name,'isreadonly') = 1
-- SQL 2005 -
select name from sys.databases where databasepropertyEX(name,'Updateability') = 'READ_ONLY'
Note:
System Table SYSDATABASES still works in sql 2005, but the documentation states it will be deprecated in favour of SYS.DATABASES in a future version.
Function DATABASEPROPERTY still works in sql 2005, but the documentation states it will be deprecated in favour of DATABASEPROPERTYEX in a future version.
No comments:
Post a Comment