Versions des environnements
Sergey,
That is exactly what I'm looking for. sys.sql_modules has the complete view definition even to the renamed fields. Thanks a bunch! Now I just need to work out the permission issues since the users won't have sa rights, but perhaps I can give the app role permission.
Thanks again.
Gary
>>I've been using sysobjects and syscomments in SQL 2000 to get base table information on our views. I seem to dimly recall that in SQL 2005 this is discouraged in favor of using a system view or information_schema.???? or a sp_something or other. Does anyone have any info on this? Thanks.
>
>Hi Gary,
>
>In SQL 2005 info about views stored the following catalog views: sys.views, sys.columns, sys.sql_dependencies and sys.sql_modules. The last one stores the text of the CREATE VIEW statement.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement