Krishan Kayat

The following steps will give you the opportunity to change your Picture Tile image and the background image in your Picture Hub. 1  Home screen 2  Select Pictures 3  Under the Title “Pictures”  Tap and Hold 4  A menu pops up and select ‘Change background” 5  Select a images in one of your your albums 6  Move the image around within the given frame. 7  Select the “v” check mark 8  Now your Picture Hub background image has been changed as well as your Picture Tile on the home screen.

1  From your PC go to the start menu and in the search area type regedit. This will open the registry editor. 2  In the bar located on the left of the editor navigate to the given path     HKEY_LOCAL_MACHINE –> SYSTEM –> CurrentControlSet –> Enum –> USB 3  This will give you a long list in your side bar. Select the USB folder you have just reached but don’t do anything else yet. 4  Hit Ctrl+F, which will open the Find dialog box. Input ZuneDriver and enter. This will automatically bring you to the WUDF folder. 5  Select the folder just above WUDF, named Device Parameters, opening a number of entries in the main screen on the right. 6  Among the many entries look for “ShowInShell”, double click and change the value from 0 to 1. 7  The registry value marked as “PortableDeviceNameSpaceExcludeFromShell” goes to 1 from the default 0 8  Set “EnableLegacySupport” to 1. 9  Exit registry editor. guys hope it'll help you....... please comment me if it he

Go to the Phone section (as if you were going to make a call) Enter  ##634# It did not call anything.  There should now be a “Diagnosis” option on the top of your screen; Go to Diagnosis and a keypad comes up and enter  *#1234#  –It should bring up a menu that includes the WiFi Mac Address; Please let me know if this works with any other Samsung Windows Phone 7 or for that matter any Windows Phone 7 ?  

I'd suggest you find out the MAC address of your WP7 and then set up a DHCP reservation at a particular IP for that MAC address (I've done this on my little home WiFi router, but it should be no problem within a company architecture).  Apparantly there is no way to determine the MAC address through the phone itself; you'll have to find it off the network itself.  Talk to your network guys or sys admins about setting up a reservation for the MAC once you have it.

if your Tabel has a duplicate data and you want to delete only duplicate records and want to save only single records in your table then this single line of code will help you.......... select * from tblname where tblname. %%physloc%% not in(select MAX(b.%%physloc%%)  from tblname   group by b.coloumnname) Hope it helped you........ plz comments.........

we need all the time date format in our project so i have some date format for your help.... How to format datetime & date in Sql Server 2005 November 16, 2012 — Krishan Kumar Kayat Execute the following Microsoft SQL Server T-SQL datetime and date formatting scripts in Management Studio Query Editor to demonstrate the multitude of temporal data formats available in SQL Server. First we start with the conversion options available for sql datetime formats with century (YYYY or CCYY format). Subtracting 100 from the Style (format) number will transform dates without century (YY). For example Style 103 is with century, Style 3 is without century. The default Style values – Style 0 or 100, 9 or 109, 13 or 113, 20 or 120, and 21 or 121 – always return the century (yyyy) format. – Microsoft SQL Server T-SQL date and datetime formats – Date time formats – mssql datetime  – MSSQL getdate returns current system date and time in standard internal format SELECT   conv