Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpham
Starting Member
19 Posts |
 Posted - 2006-08-01 : 20:58:54
|
| Hi All,We had an application which used the sysdatabases system tableto get the database information. This system table sysdatabases willbe dis-support in the next release version after SQL 2005.So is there any system table(sysdatabases) which is support but SQL2000 and SQL2005?ThanksJoanne |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-02 : 03:26:15
|
| I think the sets of INFORMATION_SCHEMA.xxx views can do that for you.Also look at the SERVERPROPERTY functions.Peter LarssonHelsingborg, Sweden |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-08-02 : 04:00:46
|
| The thing is that sys.databases is still very important in sql 2005, because they have changed the way that information_schema.schemata works (which they said that they wouldn't). I can't see the sys.databases view going any time soon.-------Moo. :) |
|
|
|
|
|
|
SQL2005 - sysdatabases