Pages

Wednesday, June 22, 2011

If error occurs while dropping all stored procedure from sql server

create a stored procedure as follows and execute the procedure

create Procedure DeleteAllProcedures1
As
      declare @procName varchar(500)

      declare cur cursor

            for select [name] from sys.objects where type = 'p'

      open cur

       fetch next from cur into @procName
      while @@fetch_status = 0

      begin

           if @procName <> 'DeleteAllProcedures'

                  exec('drop procedure ' + @procName)

                  fetch next from cur into @procName

      end
      close cur
      deallocate cur
Go

      Grant Execute On dbo.DeleteAllProcedures To Public

Go

Thursday, May 19, 2011

enter key event on form submit using jquery

 $(document).ready(function () {
            $('#ItxtUserID').val('');
            $('#ItxtPwd').val('');
            $('#ItxtUserID').focus();
            $('#divLogingEnter').bind('keypress', function (e) {
                if (e.which == 13) {
                    Login();
                }
            });

        });

Friday, February 4, 2011

Microsoft Dynamics CRM

 1. How many tabs can we create in a form.
 A. 8

2. CRM license is for 10 users. If you create 11 user then what will happen?
A. the 11 user will create , but it is in disable mode. 










Tuesday, January 18, 2011

about E-Mail Routing in CRM 4.0


The CRM E-Mail Router is a piece of software that receives messages from a service and forwards the messages to another service.

The good thing is that you can install the CRM E-Mail Router on a separate server. This doesn't need to be the same server where you have Microsoft Exchange Server installed or the same machine where you have the CRM Server installed. You can even install it on a separate server or computer running Windows XP Professional, Windows Vista Business, or Enterprise as those are the versions that can be joined to a domain (The Windows XP Home and Windows Vista Home versions are not supported). If you install the CRM E-Mail Router on a separate server, be sure this computer is on and available all the time or the e-mails won't be sent when this computer is off line and also that system should be in the same domain.

For installation, follow the below link.


Click on the Download button "DynamicsCRMEmail_1033_amd64.exe"

Make sure that you need to save it in a folder. After installation the exe file then it
Will prompt to install the MAPI Client then follow the below link


After successfully installation of that file you will get the all the Queues created in CRM

Videos on E-Mail routing: