Thursday, November 27, 2008

Copy Database to another database in Sql server 2000

Copy all tables/structures,views,functions,stored procedures..etc
Using DTS Import/Export wizard.

Wednesday, November 26, 2008

Cheat Sheets

.NET Format String Quick Reference
http://john-sheehan.com/blog/wp-content/uploads/msnet-formatting-strings.pdf

ASP.NET 2.0 Page Life Cycle & Common Events
http://john-sheehan.com/blog/wp-content/uploads/aspnet-life-cycles-events.pdf

Visual Studio 2005 Built-in Code Snippets (C#)
http://john-sheehan.com/blog/wp-content/uploads/vs2005-code-snippets.pdf

Asp.net Runtime cheat sheet
http://duartes.org/gustavo/articles/Asp.net-Runtime-Cheat-Sheet-HttpRequest-HttpRuntime.aspx

.Net Cheat sheets
http://john-sheehan.com/blog/index.php/net-cheat-sheets/

C# & Vb comparison sheet
http://aspalliance.com/625

CSS sheet
http://www.addedbytes.com/cheat-sheets/css-cheat-sheet/

Javascript sheet
http://www.addedbytes.com/download/javascript-cheat-sheet-v1/png/

RGB Hex Colour Chart
http://www.addedbytes.com/cheat-sheets/colour-chart/

HTML Character Entities Cheat Sheet
http://www.addedbytes.com/cheat-sheets/html-character-entities-cheat-sheet/

LINQ Cheat sheet
http://weblogs.asp.net/bradvincent/archive/2008/11/01/linq-cheat-sheet.aspx

VC# 2005 sheet
http://download.microsoft.com/download/e/7/9/e79cce22-b196-4b9f-9ea7-b1a21f5342e9/VCSharp_2005_color.pdf

Asp/Vbscript sheet
http://www.addedbytes.com/cheat-sheets/asp-vbscript-cheat-sheet/

Backup sql server 2000 database in BAK

Using Backup Database Wizard
============================
http://articles.techrepublic.com.com/5100-10878_11-1043671.html
http://www.hostmysite.com/support/sql/backup2000/
http://www.dbarecovery.com/completebkup.html

Using Database Maintenance Plan Wizard
======================================
http://www.databasedesign-resource.com/sql-server-maintenance-plan.html
http://www.databasejournal.com/features/mssql/article.php/3530486/Working-with-the-SQL-Server-2000-Maintenance-Plan-Wizard.htm
http://www.mssqltips.com/tip.asp?tip=1016

Monday, November 10, 2008

How do i set Authentication - Windows Server 2003

I have website configured on windows 2003 server. I will be accessing the site by
typing http://machinename/sitename, here authentication screen comes but I don't need this authentication screen. These are the steps I gave:

Go to Internet Information services, point to your virtual folder. Go to Property page. Click on authentication tab and in the edit mode change the authentication mode to "Anonymous" and give userid and password. Then you will not be asked for authentication.