To search the procedures by name in a Database

SELECT
ROUTINE_NAME--, ROUTINE_DEFINITION
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_NAME LIKE '%DBADS_SP_CHECK_JOB_PROGRESS%'
      AND ROUTINE_TYPE='PROCEDURE'

Comments

Post a Comment

Popular posts from this blog

SysDictField object not initialized. - Views

One of my Colleague had this issue.. I’m using a View (with some calculated fields), as the source for another View (summed fields, so I’m working with “total” records). This 2 nd View continues to have this error message: SysDictField object not initialized. Stack trace (C)\Classes\SysTableBrowser\AddField - line 32 (C)\Classes\SysTableBrowser\showAutoFields - line 95 (C)\Classes\SysTableBrowser\run - line 67 Solution: Go to the Field Groups and delete the fields that are in the Autoreport and delete the fields that are Autoreport and not in the Field List of the View.
Read more

Get the value of Month or YY in SysComputedCOlumns in AX views

Here is the Code: public static server str WFinvoiceDateMM() {     str sDate =         SysComputedColumn::returnfield(             tableStr (WFSyscoInvoicesV),             queryDataSourceStr (WFSyscoInvoicesQ, CustInvoiceJour),             fieldStr (CustInvoiceJour, InvoiceDate)             );     return 'Month(' + SysComputedColumn::fromUtcDateToDate(sDate) + ')' ; }
Read more

Hot to Put the Header on Each Page in an SSRS Report?

Image
Here is a brief explanation of how to put on each page of an ssrs report. Once the report is designed, Click on the Header row and click Tablix Properties and check both the rows under Row Headers as shown in Picture 1. Click on the Column Groups and Click the Advanced Mode Select the Static value under the Row Groups and look at the tablix member properties on the right. Set the Properties as shown in Picture 3. Save, Build and Deploy the report. :)
Read more