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 |
|
SQLboston
Starting Member
3 Posts |
 Posted - 2005-09-29 : 18:05:19
|
| I am using SQL Server 7 (sp4).I have an application that is having problem seeing some of these views. I used sp_refreshview to refresh some of the Information-schema views. I get an error message that says the view does not exit. But if I go to EM, I can see the views along with other user and system views.How do I refresh these views or recreate them?Thanks for help.Frank |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-09-29 : 19:18:47
|
| They are special views and are defined in the master database.There is some permission-checking going on in them, so that might be an issue.Welcome to SQLTeam.rockmoose |
 |
|
|
SQLboston
Starting Member
3 Posts |
Posted - 2005-09-30 : 08:24:36
|
Rock thanks for welcome.I login with SA account. I guess that should give me permission to refresh these objects. Is there a way to clear these views and recreate them?Thanksquote:
Originally posted by rockmoose
They are special views and are defined in the master database.There is some permission-checking going on in them, so that might be an issue.Welcome to SQLTeam.rockmoose
|
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-30 : 08:46:01
|
| Are you trying to query the views using SA, or just to refresh them with SA?There are definitely permissions issues if you use these views without certain permissions (but "sa" WILL have enough permissions)Kristen |
|
|
|
|
|
|
Information-schema views refresh.