Posts

Showing posts from August, 2009

Delete dupliate rows

Delete duplicate rows - sql server 2005 http://blog.sqlauthority.com/2007/03/01/sql-server-delete-duplicate-records-rows/

Localization and globalization in asp.net

Good article for localization and globalization: http://www.codeguru.com/csharp/.net/net_asp/miscellaneous/article.php/c12407

How to install sql server 2005?

Steps to install sql server 2005 can be found at: http://articles.techrepublic.com.com/5100-10878_11-6102265.html You need to install the following, 1. Windows installer Note: No need of installing windows installer for server 2003 sp1,sp2 2. SQLEXPR.EXE 3. SQLServer2005_SSMSEE.msi Download links SQLEXPR.EXE SQLServer2005_SSMSEE.msi If you get client systems error 'doesn't allow remote connections' then follow these steps, start -> programmers -> microsoft sql server 2005 -> configuration tools -> sql server surface area configuration #1 enable sql browser services #2 set the appropriate type for remote connections #3 Stop and start modified services. Happy Installation.
Cscript.exe iisback.vbs /s tech11 /u administrator /p hmsr_2008 /backup /b "D:\hosting\iis_01-08-09.xml" URLS: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/475fb247-984d-4c65-842a-ae3bdd3e1080.mspx?mfr=true http://support.microsoft.com/kb/324277 Cscript.exe iisback.vbs /s srv1 /u Administrator /p DCserver2009 /backup /b iis_backup_01_08-09 iisback /restore /b C:\Documents and Settings\Administrator\Desktop\MetaBack\MetaBack\Initial Backup - created automatically by IIS setup.SC1 /s tech11 /u administrator /p hmsr_2008

backup iis

Cscript.exe iisback.vbs /s srv1 /u Administrator /p DCserver2009 /backup /b iis_backup_01_08-09