index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Access Denied ::    show all messagesPost a New Message | Post a Reply
Aug 3 2006, 9:46 AM
 Re: Access DeniedPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

We use the generic “dbo” account to query SQL Server for the stored procedures as shown below:

SELECT [NAME] FROM dbo.SYSOBJECTS WHERE XTYPE='P' AND STATUS>0 ORDER BY 1

If the above statement does not return all your stored procedures, you can change it by using the DatabaseProceduresQuery property of the report wizard which will be available in the next minor release due tomorrow (Friday 3rd August 3, 2006). AS follows:

objWiz.DatabaseProceduresQuery = “SELECT NAME FROM SYSOBJECTS WHERE XTYPE='P' AND STATUS>0 ORDER BY 1”


-------------------------
Ghost
Pages: (1)   [1]

search this forum: