DataBase Restore History - SQL Server

SELECT MAX(restore_date) AS LastRestore

      ,COUNT(*) AS CountRestores

      ,destination_database_name

FROM msdb.dbo.restorehistory

GROUP BY destination_database_name

From this link 

Browser Capabilities

 http://msdn.microsoft.com/en-us/library/3yekbd5b.aspx

private void Button1_Click(object sender, System.EventArgs e)
{
    System.Web.HttpBrowserCapabilities browser = Request.Browser;
    string s = "Browser Capabilities\n"
        + "Type = "                    + browser.Type + "\n"
        + "Name = "                    + browser.Browser + "\n"
        + "Version = "                 + browser.Version + "\n"
        + "Major Version = "           + browser.MajorVersion + "\n"
        + "Minor Version = "           + browser.MinorVersion + "\n"
        + "Platform = "                + browser.Platform + "\n"
        + "Is Beta = "                 + browser.Beta + "\n"
        + "Is Crawler = "              + browser.Crawler + "\n"
        + "Is AOL = "                  + browser.AOL + "\n"
        + "Is Win16 = "                + browser.Win16 + "\n"
        + "Is Win32 = "                + browser.Win32 + "\n"
        + "Supports Frames = "         + browser.Frames + "\n"
        + "Supports Tables = "         + browser.Tables + "\n"
        + "Supports Cookies = "        + browser.Cookies + "\n"
        + "Supports VBScript = "       + browser.VBScript + "\n"
        + "Supports JavaScript = "     + 
            browser.EcmaScriptVersion.ToString() + "\n"
        + "Supports Java Applets = "   + browser.JavaApplets + "\n"
        + "Supports ActiveX Controls = " + browser.ActiveXControls 
              + "\n"
        + "Supports JavaScript Version = " +
            browser["JavaScriptVersion"] + "\n";

    TextBox1.Text = s;
}

Working Example JavaScript KeyCode

http://www.cambiaresearch.com/articles/15/javascript-char-codes-key-codes
copy and paste into notepad and save as .html file and run it through IE and FireFox browsers.
<html >
<head><SCRIPT language="javascript">

 function displayKeyCode(evt)
 {
    var textBox = getObject('txtChar');
     var charCode = (evt.which) ? evt.which : event.keyCode

     textBox.value = String.fromCharCode(charCode);
     if (charCode == 8) textBox.value = "backspace-8"; //  backspace
     if (charCode == 9) textBox.value = "tab"; //  tab
     if (charCode == 13) textBox.value = "enter"; //  enter
     if (charCode == 16) textBox.value = "shift"; //  shift
     if (charCode == 17) textBox.value = "ctrl"; //  ctrl
     if (charCode == 18) textBox.value = "alt"; //  alt
     if (charCode == 19) textBox.value = "pause/break"; //  pause/break
     if (charCode == 20) textBox.value = "caps lock"; //  caps lock
     if (charCode == 27) textBox.value = "escape"; //  escape
     if (charCode == 33) textBox.value = "page up"; // page up, to avoid displaying alternate character and confusing people            
     if (charCode == 34) textBox.value = "page down"; // page down
     if (charCode == 35) textBox.value = "end"; // end
     if (charCode == 36) textBox.value = "home"; // home
     if (charCode == 37) textBox.value = "left arrow"; // left arrow
     if (charCode == 38) textBox.value = "up arrow"; // up arrow
     if (charCode == 39) textBox.value = "right arrow"; // right arrow
     if (charCode == 40) textBox.value = "down arrow"; // down arrow
     if (charCode == 45) textBox.value = "insert"; // insert
     if (charCode == 46) textBox.value = "delete-46"; // delete
     if (charCode == 91) textBox.value = "left window"; // left window
     if (charCode == 92) textBox.value = "right window"; // right window
     if (charCode == 93) textBox.value = "select key"; // select key
     if (charCode == 96) textBox.value = "numpad 0"; // numpad 0
     if (charCode == 97) textBox.value = "numpad 1"; // numpad 1
     if (charCode == 98) textBox.value = "numpad 2"; // numpad 2
     if (charCode == 99) textBox.value = "numpad 3"; // numpad 3
     if (charCode == 100) textBox.value = "numpad 4"; // numpad 4
     if (charCode == 101) textBox.value = "numpad 5"; // numpad 5
     if (charCode == 102) textBox.value = "numpad 6"; // numpad 6
     if (charCode == 103) textBox.value = "numpad 7"; // numpad 7
     if (charCode == 104) textBox.value = "numpad 8"; // numpad 8
     if (charCode == 105) textBox.value = "numpad 9"; // numpad 9
     if (charCode == 106) textBox.value = "multiply"; // multiply
     if (charCode == 107) textBox.value = "add"; // add
     if (charCode == 109) textBox.value = "subtract"; // subtract
     if (charCode == 110) textBox.value = "decimal point"; // decimal point
     if (charCode == 111) textBox.value = "divide"; // divide
     if (charCode == 112) textBox.value = "F1"; // F1
     if (charCode == 113) textBox.value = "F2"; // F2
     if (charCode == 114) textBox.value = "F3"; // F3
     if (charCode == 115) textBox.value = "F4"; // F4
     if (charCode == 116) textBox.value = "F5"; // F5
     if (charCode == 117) textBox.value = "F6"; // F6
     if (charCode == 118) textBox.value = "F7"; // F7
     if (charCode == 119) textBox.value = "F8"; // F8
     if (charCode == 120) textBox.value = "F9"; // F9
     if (charCode == 121) textBox.value = "F10"; // F10
     if (charCode == 122) textBox.value = "F11"; // F11
     if (charCode == 123) textBox.value = "F12"; // F12
     if (charCode == 144) textBox.value = "num lock"; // num lock
     if (charCode == 145) textBox.value = "scroll lock"; // scroll lock
     if (charCode == 186) textBox.value = ";"; // semi-colon
     if (charCode == 187) textBox.value = "="; // equal-sign
     if (charCode == 188) textBox.value = ","; // comma
     if (charCode == 189) textBox.value = "-"; // dash
     if (charCode == 190) textBox.value = "."; // period
     if (charCode == 191) textBox.value = "/"; // forward slash
     if (charCode == 192) textBox.value = "`"; // grave accent
     if (charCode == 219) textBox.value = "["; // open bracket
     if (charCode == 220) textBox.value = "\\"; // back slash
     if (charCode == 221) textBox.value = "]"; // close bracket
     if (charCode == 222) textBox.value = "'"; // single quote

     var lblCharCode = getObject('spnCode');
    lblCharCode.innerHTML = 'KeyCode:  ' + charCode;

    return false;

 }
 function getObject(obj)
  {
      var theObj;
      if (document.all) {
          if (typeof obj=='string') {
              return document.all(obj);
          } else {
              return obj.style;
          }
      }
      if (document.getElementById) {
          if (typeof obj=='string') {
              return document.getElementById(obj);
          } else {
              return obj.style;
          }
      }
      return null;
  }
 //-->
</SCRIPT>
Press a key in the text box below to see the corresponding Javascript key code. Or scroll down to see the full list.
<br><br>
Try it!
<INPUT ONKEYPRESS="javascript:return false;" ID="txtChar" ONKEYDOWN="javascript:return displayKeyCode(event)" TYPE="text"

NAME="txtChar">&nbsp;&nbsp;&nbsp;<SPAN ID="spnCode" NAME="spnCode"></SPAN>
</div>

JavaScript KeyCode

https://gist.github.com/lbj96347/2567917

keycode    8 = BackSpace BackSpace

keycode    9 = Tab Tab

keycode   12 = Clear

keycode   13 = Enter

keycode   16 = Shift_L

keycode   17 = Control_L

keycode   18 = Alt_L

keycode   19 = Pause

keycode   20 = Caps_Lock

keycode   27 = Escape Escape

keycode   32 = space space

keycode   33 = Prior

keycode   34 = Next

keycode   35 = End

keycode   36 = Home

keycode   37 = Left

keycode   38 = Up

keycode   39 = Right

keycode   40 = Down

keycode   41 = Select

keycode   42 = Print

keycode   43 = Execute

keycode   45 = Insert

keycode   46 = Delete

keycode   47 = Help

keycode   48 = 0 equal braceright

keycode   49 = 1 exclam onesuperior

keycode   50 = 2 quotedbl twosuperior

keycode   51 = 3 section threesuperior

keycode   52 = 4 dollar

keycode   53 = 5 percent

keycode   54 = 6 ampersand

keycode   55 = 7 slash braceleft

keycode   56 = 8 parenleft bracketleft

keycode   57 = 9 parenright bracketright

keycode   65 = a A

keycode   66 = b B

keycode   67 = c C

keycode   68 = d D

keycode   69 = e E EuroSign

keycode   70 = f F

keycode   71 = g G

keycode   72 = h H

keycode   73 = i I

keycode   74 = j J

keycode   75 = k K

keycode   76 = l L

keycode   77 = m M mu

keycode   78 = n N

keycode   79 = o O

keycode   80 = p P

keycode   81 = q Q at

keycode   82 = r R

keycode   83 = s S

keycode   84 = t T

keycode   85 = u U

keycode   86 = v V

keycode   87 = w W

keycode   88 = x X

keycode   89 = y Y

keycode   90 = z Z

keycode   96 = KP_0 KP_0

keycode   97 = KP_1 KP_1

keycode   98 = KP_2 KP_2

keycode   99 = KP_3 KP_3

keycode 100 = KP_4 KP_4

keycode 101 = KP_5 KP_5

keycode 102 = KP_6 KP_6

keycode 103 = KP_7 KP_7

keycode 104 = KP_8 KP_8

keycode 105 = KP_9 KP_9

keycode 106 = KP_Multiply KP_Multiply

keycode 107 = KP_Add KP_Add

keycode 108 = KP_Separator KP_Separator

keycode 109 = KP_Subtract KP_Subtract

keycode 110 = KP_Decimal KP_Decimal

keycode 111 = KP_Divide KP_Divide

keycode 112 = F1

keycode 113 = F2

keycode 114 = F3

keycode 115 = F4

keycode 116 = F5

keycode 117 = F6

keycode 118 = F7

keycode 119 = F8

keycode 120 = F9

keycode 121 = F10

keycode 122 = F11

keycode 123 = F12

keycode 124 = F13

keycode 125 = F14

keycode 126 = F15

keycode 127 = F16

keycode 128 = F17

keycode 129 = F18

keycode 130 = F19

keycode 131 = F20

keycode 132 = F21

keycode 133 = F22

keycode 134 = F23

keycode 135 = F24

keycode 136 = Num_Lock

keycode 137 = Scroll_Lock

keycode 187 = acute grave

keycode 188 = comma semicolon

keycode 189 = minus underscore

keycode 190 = period colon

keycode 192 = numbersign apostrophe

keycode 210 = plusminus hyphen macron

keycode 211 =

keycode 212 = copyright registered

keycode 213 = guillemotleft guillemotright

keycode 214 = masculine ordfeminine

keycode 215 = ae AE

keycode 216 = cent yen

keycode 217 = questiondown exclamdown

keycode 218 = onequarter onehalf threequarters

keycode 220 = less greater bar

keycode 221 = plus asterisk asciitilde

keycode 227 = multiply division

keycode 228 = acircumflex Acircumflex

keycode 229 = ecircumflex Ecircumflex

keycode 230 = icircumflex Icircumflex

keycode 231 = ocircumflex Ocircumflex

keycode 232 = ucircumflex Ucircumflex

keycode 233 = ntilde Ntilde

keycode 234 = yacute Yacute

keycode 235 = oslash Ooblique

keycode 236 = aring Aring

keycode 237 = ccedilla Ccedilla

keycode 238 = thorn THORN

keycode 239 = eth ETH

keycode 240 = diaeresis cedilla currency

keycode 241 = agrave Agrave atilde Atilde

keycode 242 = egrave Egrave

keycode 243 = igrave Igrave

keycode 244 = ograve Ograve otilde Otilde

keycode 245 = ugrave Ugrave

keycode 246 = adiaeresis Adiaeresis

keycode 247 = ediaeresis Ediaeresis

keycode 248 = idiaeresis Idiaeresis

keycode 249 = odiaeresis Odiaeresis

keycode 250 = udiaeresis Udiaeresis

keycode 251 = ssharp question backslash

keycode 252 = asciicircum degree

keycode 253 = 3 sterling

keycode 254 = Mode_switch

Gridview with Fixed Header using CSS

http://csharpdotnetfreak.blogspot.com/2009/07/scrollable-gridview-fixed-headers-asp.html

We need to alter the header's width as per we need using HeaderStyle-Width property

HTML Source

<form id="form1" runat="server">
<div>
<asp:Panel ID="Panel1" runat="server" Height="200px" 
                       Width="200px" ScrollBars="Vertical">

<asp:GridView ID="GridView1" runat="server" 
              AutoGenerateColumns="False" DataKeyNames="ID"
              DataSourceID="SqlDataSource1"
              RowStyle-VerticalAlign="Bottom"
              OnRowDataBound="GridView1_RowDataBound">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" 
                InsertVisible="False" 
                ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="Name" HeaderText="Name" 
                                 SortExpression="Name" />
<asp:BoundField DataField="Location" HeaderText="Location" 
                             SortExpression="Location" />
</Columns>
<HeaderStyle CssClass="header"Height="20px" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [ID], [Name], [Location] FROM [Details]">
</asp:SqlDataSource>
</asp:Panel>
</div></form>

CSS Code 

 <head runat="server">
<title>Creating scrollable GridView with fixed headers</title>
<style type="text/css">
  .header
  {
    font-weight:bold;
    position:absolute;
    background-color:White;
  }
  </style>
</head>

Code Behind 

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if(e.Row.RowIndex == 0)
           e.Row.Style.Add("height","40px");
        }
    }

Javascript ToolTip

Consider the following link
http://www.menucool.com/tooltip/javascript-tooltip

Download the demo source code.(It contains tooltip.css file and tooltip.js file)

We need to add that two files in solution and Register that file in load page.
In code behind , while rowdatabound event we need to add the  
if (e.Row.Cells[8].Text.Replace("&nbsp;", "") != "")
  {
       e.Row.Cells[8].Attributes.Add("onmouseover", "tooltip.pop(this,'" + e.Row.Cells[8].Text + "')");
   }
else
  {
       e.Row.Cells[8].Attributes.Remove("onmouseover");
   }  


it will available in downloaded file.

Get SQL data from another server - OPENROWSET

SELECT * into tr
FROM    OPENROWSET( 'SQLOLEDB',
                    'Server=10.10.1.89\SQLEXPRESSR2;UID=sa;PWD=password',                  
                    'SET FMTONLY OFF;SET NOCOUNT ON; exec BASE89.dbo.GetPWD @UID=''21'''
                  )
select * from tr

http://technet.microsoft.com/en-us/library/ms191188%28v=sql.105%29.aspx