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 |
|
mr_mist
Grunnio
1870 Posts |
 Posted - 2007-05-18 : 05:56:21
|
Hmm. I have an oddity on one particular server where a list of select * from information_schema.schemata is not returning all the databases. I know that master..sysdatabases is probably the better alternative given the change in 2005, but it would help to know if anyone has seen this behaviour before and has a fix for it?The user running the command has sysadmin.-------Moo. :) |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2007-05-18 : 09:09:28
|
| Turns out it was because of "auto close"...-------Moo. :) |
 |
|
|
|
|
|
information_schema.schemata not returning all dbs