Software Applications Programming Errors and solutions.

Posts

SQL Database shrinking full step details with Screenshots to reduce database size

Step 1: (‎05-‎Mar-‎17 4:00:46 PM) User right click on "MicrosoftDynamicsAX (tree item)" in "Microsoft SQL Server Management Studio" Step 2: (‎05-‎Mar-‎17 4:00:49 PM) User left click on "Properties (menu item)" Step 3: (‎05-‎Mar-‎17 4:00:56 PM) User left click on "Options (tree item)" in "Database Properties - MicrosoftDynamicsAX" Step 4: (‎05-‎Mar-‎17 4:00:59 PM) User left click on "Auto Shrink ()" in "Database Properties - MicrosoftDynamicsAX" Step 5: (‎05-‎Mar-‎17 4:01:00 PM) User left click on "Open (button)" in "Database Properties - MicrosoftDynamicsAX" Step 6: (‎05-‎Mar-‎17 4:01:02 PM) User left click on "containmentTypeComboBox (combo box)" in "Database Properties - MicrosoftDynamicsAX" Step 7: (‎05-‎Mar-‎17 4:01:03 PM) User left click on "Recovery model: (co

Create Index From SQL of Expensive queries

Index creation from expensive query from SQL You can use Activity monitor of SQL . Then you can find missing index detail from show execution plan by right click on query. Add caption If its ax then you can create it from AOT step provided at the end of video.

Sending mail by Telnet and manually checking connection

Open Command prompt using CMD as administrator Then Put in this command : telnet server Name 25 Wait to be invited to next step (ehlo), then put in this command: EHLO Domai nanme After output put in this command: MAIL FROM : From email address After output ("Sender OK"), then put in this command: RCPT TO : to email address After output ("Recipient OK"), then put in this command: DATA After output , then put in this command: Subject : type message After output , then put in a dot (".") and hit enter. After output and confirmation message, then put in this command: Then QUIT

Advantages of pragma exception init in ORACLE

1.You can define error message for predefined oracle error number.. But once you declare pragma statement, exception are handled implicitly... No need to raise exception explicitly... 2.User could define error message for predefined ora- error number. I guess this would be advantage of using it.. 3.The pragma actually makes it possible to check for errors which are not predefined. the only other way would be to check with 'WHEN OTHERS' clause and then accessing the oracle error code. 4.To enhance application interface and display accurate reason for an error.