How To Deploy XAP File Directly To Your Emulator

If you ever want to install/ deploy XAP file to your emulator just run the following application;

"C:\Program Files\Microsoft SDKs\Windows Phone\v7.0\Tools\XAP Deployment\XapDeploy.exe"

*path can vary according to the installation path.

This is helpful for testing whether the XAP file you made has all the needed resources like: Images, DBFile etc.

How to Install IIS 6 Management Compatiblity on IIS 7

Url : http://technet.microsoft.com/en-us/library/bb397374(EXCHG.80).aspx



Install the IIS 6.0 Management Compatibility Components in Windows Server 2008 R2 or in Windows Server by using the Server Manager tool 

1. Click Start, click Administrative Tools, and then click Server Manager.

2. In the navigation pane, expand Roles, right-click Web Server (IIS), and then click Add Role Services.

3. In the Select Role Services pane, scroll down to IIS 6 Management Compatibility.

4. Click to select the IIS 6 Metabase Compatibility and IIS 6 Management Console check boxes.

5. In the Select Role Services pane, click Next, and then click Install at the Confirm Installations Selections pane.

6. Click Close to exit the Add Role Services wizard.



Install the IIS 6.0 Management Compatibility Components in Windows 7 or in Windows Vista from Control Panel 


1. Click Start, click Control Panel, click Programs and Features, and then click Turn Windows features on or off.

2. Open Internet Information Services.

3. Open Web Management Tools.

4. Open IIS 6.0 Management Compatibility.

5. Select the check boxes for IIS 6 Metabase and IIS 6 configuration compatibility and IIS 6 Management Console.

6. Click OK.

Create Log File for MSI Setup

msiexec /i  <MSI File Path>  /l*vx <LogFile Path>

e.g:
msiexec /i C:\Users\Test.msi /l*vx C:\LogFile.log

How to Check When Your DB was Last Updated - Sql Server

SELECT OBJECT_NAME(OBJECT_ID) AS TableName, last_user_update,* FROM sys.dm_db_index_usage_statsWHERE database_id = DB_ID( 'Database')