-
MSSQL 2000 views limitations
What is the total number of databases that you can access in a view at any one time?
We have about 60 db's, and need to pull common information from all of them for reporting.
Thanks!
-
Are all databases in one server?
You should be able to create a view with 60 references to different databases. You may hit other limitation like memory before you reach 60.
This is a good reference from MS
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|