Wednesday, February 27, 2013

Change the sa password in SQL Server

Login into SQL Server using Windows Authentication.
In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.

The Simple trick is to check the box “Map to credential” as shown below after providing a new password and click Okay.

SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted

The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created.
The following actions might require a table to be re-created:
  • Dropping a column
  • Changing column nullability
  • Changing the order of the columns
  • Changing the data type of a column
To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

Friday, February 15, 2013

Check the Microsoft Certification

Use the below link to Check/Share the Microsoft Certication Details
https://mcp.microsoft.com/authenticate/validatemcp.aspx
use the Transcript ID and access code as your password
You are now ready to share your qualifications with your employer, friends, and colleagues. 
Provide them with your Transcript ID and the Access Code, and direct them to https://mcp.microsoft.com/authenticate/validatemcp.aspx. Remember, you can change your Access Code at any time. 
If you decide to stop sharing your transcript, simply change your Access Code at https://mcp.microsoft.com/mcp/tools/MCPDirectoryPreferences.aspx and refrain from sharing the new Access Code with anyone.

The below link is used to update your Certification details 
https://www.microsoft.com/learning/members/en/us/mcp/mcp-default.aspx 


Thursday, February 7, 2013

Tools used in Microsoft CRM 2011

1. The following tools are all part of the CRM 2011 Software Development Kit (SDK) SDK Download: http://www.microsoft.com/download/en/details.aspx?id=24004 
4. Metadata Document Generator - http://metadatadocgenerator.codeplex.com 
5. Visual Ribbon Editor - http://crmvisualribbonedit.codeplex.com 
6. SiteMap Editor - http://sitemapeditor.codeplex.com 
7. Odata Query Designer - http://crm2011odatatool.codeplex.com 
8. Fiddler - http://www.fiddler2.com 
10. JavaScript Conversion - http://crm2011scriptconvert.codeplex.com 
12. Metadata Document Generator for Microsoft Dynamics CRM 2011 (Form Reporter) - http://metadatadocgenerator.codeplex.com 

Setting Blank iFrame in CRM 2011

when you need to default an iFrame to a blank page.  When this is the case, through JavaScript, you’ll then want to set the page to the desired URL.

With CRM 4.0, you could set your page to “/_root/blank.aspx”.  This page however, is no longer an option inside CRM 2011.

With CRM 2011, I like to use the loading screen “/_static/loading.htm”.  Although this page contains an animated .gif and slightly more HTML than a blank page, the reason I prefer this page is because it is already cached by the browser and provides the user with a nice loading graphic.

Add a new iFrame and in the URL filed give the above highlighted text.