When attaching a SQL Server 2000 database to a 2005 SQL Server, the 2005 IDE would not support opening the 2000 database diagrams. But there are two ways to make this happens: 1) In SQL Server 2005 Management Studio do the following:

1. Right Click on your database, choose properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)" [more]

2) Or by script:

      EXEC sp_dbcmptlevel 'EnterYourDatabaseNameHere', '90';

Also, if you get this error when trying to add a new Diagram:

Error: Database diagram support objects cannot be installed because this database does not have a valid owner

Execute the following script:

EXEC sp_dbcmptlevel 'YourDB, '90';

go

ALTER AUTHORIZATION ON DATABASE::YourDB TO "sa"

go

We can retrieve a row number or Identity of a SQL Server table row using the script below:

select identity(int) col INTO #Temp from dbo.table

select * from #Temp

Idenity is retrieved when INTO is used to insert the record into a user or temporary table  

To get details about an SQL Server database using the following stored procedure:       

       sp_helpdb 'DatabaseName'

to get help about an SQL Server table, use the following stored procedure:        

Also, to list all tables that contain a given column name (Source: http://www.cryer.co.uk/brian/sqlserver/sqlsvrhowto.htm)

If we have string HelloWorld and we want the following:

1) Find the a match when the string Hello World starts with the word Hello on a condition the word World is attached to the word Hello.

    ^(?i:Hello) 

Where:

    ^             matches the beginning of a string or line.

    (             Starts a group.

    ?i:           Ignore Case.

To drop all triggers from any database, execute this script:

declare @trigger varchar(1000)

declare @sql nvarchar(1000)

select @trigger = min([name]) from sysobjects where [name] like 'trig_prefix%'

while @trigger is not null [more]

begin

      set @sql = 'drop trigger ' + @trigger

      exec sp_executesql @sql

      select @trigger = min([name]) from sysobjects where [name] like 'trig_mi%' and [Name] > @trigger
end

When using the LoginStatus control (one of the ASP.NET Membership) to logout,
the page has to postback and that causes an unintentional data retrieval for the page that requested the logout. Then if the page has dynamic controls which have to be populated on every postback, and that causes the dynamic control to be populated and then the logout action happens which a waist of
database and server resources.

The solution is to use a normal link which redirects a page to another page (logout page) that has the following code:              

protected void Page_Load(object sender, EventArgs e)

{

   FormsAuthentication.SetAuthCookie(string.Empty, false);           

   FormsAuthentication.SignOut();           

   Session.Abandon();           

   Response.Redirect("~/LoginDetails/login.aspx");

}

Microsoft have included a new library in .NET 2.0 System.IO.Compression.GZipStream to

compress streams, Soup, ViewState.

 To register a js programmatically, use the following:Page.ClientScript.RegisterClientScriptInclude("script1", ResolveUrl("~/include/js/javascriptfile.js"));.

This can live behinde the master page inside the load event.

//Its better to check if the script was registered (Page.ClientScript.IsClientScriptBlockRegistered("script1")). 

Also, you can use another way if you have more script to register which in sequence:

      if(!IsPostBack && !Page.ClientScript.IsClientScriptBlockRegistered("URLs"))

        {

         StringBuilder scriptBuilder = new StringBuilder();

         scriptBuilder.Append("<script type='text/javascript' src='");    

         scriptBuilder.Append(ResolveUrl("~/include/js/mmloadmenus2.js"));

         scriptBuilder.Append("'></script>");        

         scriptBuilder.Append("<script type='text/javascript' src='");

         scriptBuilder.Append(ResolveUrl("~/include/js/mm_menu.js"));        

         scriptBuilder.Append("'></script>");

         scriptBuilder.Append("<script language='JavaScript1.2'>mmLoadMenus();</script>");

        Page.ClientScript.RegisterClientScriptBlock(typeof(System.String),"URLs",

        scriptBuilder.ToString());

   }