Results 1 to 6 of 6

Thread: Views problem

  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Views problem

    is there any way to see, which view belongs to which data base, for example if you have 20 data bases.Now I see View-dbo.View_1, not important how many views is open, each has the same name.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You open it under specific db, do you?

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Are you opening it in Management Studio?

  4. #4
    Join Date
    Mar 2009
    Posts
    3
    yes and yes

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Then you know the view is in which db.

  6. #6
    Join Date
    Mar 2009
    Posts
    3
    for 2 different databases all I see is this

    http://forums.databasejournal.com/im.../2009/04/1.jpg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •