Results 1 to 2 of 2

Thread: MSSQL 2000 views limitations

  1. 05-23-2003, 08:09 AM #1
    Clu
    Clu is offline Registered User
    Join Date
    May 2003
    Posts
    1

    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!
    Reply With Quote Reply With Quote
  2. 05-23-2003, 10:11 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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