Insert data from Excel to SQL Server 2005 by using copy and paste commands

http://www.mssqltips.com/tip.asp?tip=1430

how to reset you sqlserver password

hi anybody forget or lost sqlserver password, dont worry

follow these steps:-
1)open sql query analyzer
2)click on windows authentication
3)click connect
4)enter this command
sp_password null,’new password’,'username’

ex:-sp_password null,’hello’,’sa’

simple

now your password is reset now connect to sa user to this password

note:-if you are using vista open query analyzer ‘run as admin’

How do I send a web page

System.Net.Mail does not natively support sending a web page. However, using the WebRequest class, you can screen scrape web pages, and pass the resulting Html string to the MailMessage object. The following example demonstrates this technique.

public static void EmailWebPage()
{
//create the mail message
MailMessage mail = new MailMessage();

//set the addresses
mail.From = new MailAddress(“me@mycompany.com”);
mail.To.Add(“you@yourcompany.com”);

//set the content
mail.Subject = “This is an email”;

//screen scrape the html
string html = ScreenScrapeHtml(“http://localhost/example.htm”);
mail.Body = html;
mail.IsBodyHtml = true;

//send the message
SmtpClient smtp = new SmtpClient(“127.0.0.1″);
smtp.Send(mail);

}
public static string ScreenScrapeHtml(string url)
{
WebRequest objRequest = System.Net.HttpWebRequest.Create(url);
StreamReader sr = new StreamReader(objRequest.GetResponse().GetResponseStream());
string result = sr.ReadToEnd();
sr.Close();
return result;
}

WCF

I am very new to WCF this link is very useful who are learn to WCF

http://msdn.microsoft.com/en-us/netframework/cc512374.aspx