InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 17:53:18 GMT20http://www.sqlservercentral.com/Forums/Topic486990-149-1.aspxIn SQL 2005, there's a view called "sys.sql_modules", which has the definition (create script) for views, procs, etc. Books Online has the specifics.Join that to sys.views to get the name (or to sys.all_objects) on object_id column.If you can select from that, you should get what you need.Edit: I just tested this with a proc with just over 75,000 characters, and it returned as a single row with the full text in it.Fri, 18 Apr 2008 07:53:22 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic486990-149-1.aspxsp_helptext should give you what you're looking for. But you may have to grant your user higher permissions than it already has - check out the Permissions section of the sp_helptext topic in Books Online.JohnFri, 18 Apr 2008 04:26:24 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic486990-149-1.aspxThanx a lot for the anwer I am aware of this,I need to be able to do this dynamically from the .NET applicationnot manually from the Enterprise manager.It is part of an automated procedure, and the View name and other parameters (Like the Database and Server name) are supplied run-time...:DFri, 18 Apr 2008 04:20:24 GMTJohn.Geranioshttp://www.sqlservercentral.com/Forums/Topic486990-149-1.aspxIn the Object Explorer for the SQL Server, expand the database, expand views, find the view, right click and Script view as > Create To > New Query window.Fri, 18 Apr 2008 04:11:54 GMTAkeel.Mughalhttp://www.sqlservercentral.com/Forums/Topic486990-149-1.aspxHelloI am writing an application in VB .net.I need to perform select queries using the SQL of pre existing Views in the server, after some slight "surgery" on it. ( So I cannot just write SELECT* from View_A and be good with it.)I need to be able to retrieve the SQL of a view, by just providing its name as a parameter.I have found the solution:SELECT TABLE_NAME, VIEW_DEFINITIONFROM INFORMATION_SCHEMA.VIEWSWHERE (TABLE_NAME = 'Report_View_A')It is what I want but....Some views are very complex thus long...(have a large SQL script)So in this cases i get a "Trimmed" VIEW_DEFINITION as return...How can i get the full View definition SQL?Where does SQL Server keeps the full SQL of the views?Could you please help?....Thanx in advance..A.I.G:)Fri, 18 Apr 2008 03:08:30 GMTJohn.Geranios