| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 136789 | 2014-04-15 20:49:00 | query all views in SQL database | Mike (15) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1372818 | 2014-04-15 20:49:00 | Hi all, I have 97 views that I need to query to find which database the view looks at. We are running a database migration and the views are all pointing currently at our test database environment and while I have gone through and changed the reference of all the views to point at our production database I need to double-check that I haven't missed any. These views are used for the data migration, so need to be looking at the right place :) SQL Server 2008 R2 Cheers, Mike. |
Mike (15) | ||
| 1372819 | 2014-04-15 21:27:00 | Have you tried this (msdn.microsoft.com) | Webdevguy (17166) | ||
| 1 | |||||