Microsoft SQL Server 2005

How can I change my default database in MS SQL 2005
Log in to SQL Server 2005 and click the New Query button. After that run the system stored procedure sp_defaultdb command as follows:
exec sp_defaultdb @loginame='login', @defdb='master'
To achieve this in Microsoft SQL Server Management Studio you need to edit your login by expanding the Security -> Logins node and then right clicking on your login name and selecting Properties. Once the properties page displays there should be a Default database dropdownlist under the General page as seen below:

Software Downloads

Download Center
CodePlex	»	http://www.codeplex.com/ (Microsoft)
SourceForge	»	http://sourceforge.net/

Install
Backup and Deployment
Acronis => http://www.acronis.com/download/

CMS
Joomla => http://www.joomla.org/download.html
Wordpress => http://wordpress.org/

Databasing
MySQL => http://dev.mysql.com/downloads/
Navicat => http://navicat.com/
PostgreSQL => http://www.postgresql.org/
Sqlite => http://www.sqlite.org/

Disassembler
Reflector => http://www.red-gate.com/products/dotnet-development/reflector/

Extensions
Firebug => http://getfirebug.com/downloads (Firefox)

Framework
CodeIgniter => http://codeigniter.com/downloads/
JQuery => http://jquery.com/
JQuery UI => http://jqueryui.com/
PHP => http://php.net/downloads.php
YUI Library => ttp://developer.yahoo.com/yui/

IDE
NetBeans => http://netbeans.org/downloads/
Eclipse => http://www.eclipse.org/

IM
GTalk => http://www.google.com/talk/
MSN => http://explore.live.com/windows-live-messenger?os=other
Skype => http://www.skype.com/intl/en-us/get-skype/on-your-computer/windows/

ISO Utility
PowerISO => http://www.poweriso.com/download.htm
MagicISO => ttp://www.magiciso.com/tutorials/miso-magicdisc-history.htm

Issue Tracker
BugTracker.NET => http://ifdefined.com/bugtrackernet.html
Bugzilla => http://www.bugzilla.org/

Multimedia Player
VideoLAN => http://www.videolan.org/vlc/download-windows.html
XBMX => http://xbmc.org/download/

Office
Open Office => http://download.openoffice.org/

Photo Editors
FastStone Photo Resizer => http://www.faststone.org/FSResizerDownload.htm
GIMP => http://www.gimp.org/downloads/
Paint.NET => ttp://www.getpaint.net/download.html
Pixlr => http://pixlr.com/
Sumo Paint => http://www.sumopaint.com/home/

Remote Desktop Utility
Team Viewer => http://www.teamviewer.com/en/download/index.aspx

Social Networks
Facebook => http://www.facebook.com/
LinkedIn => http://www.linkedin.com/
Twitter => http://twitter.com/

Source Control
Git => http://git-scm.com/
SVN => http://subversion.apache.org/packages.html

Text Editors
E-TextEditor => http://www.e-texteditor.com/
Notepad++ => http://notepad-plus-plus.org/download
TextPad => http://www.textpad.com/download/

Web Browsers
Chrome => http://www.google.com/chrome/intl/en/landing_chrome.html?hl=en
Firefox =>
RockMelt => http://www.rockmelt.com/

Wiki
Screw Turn Wiki => http://www.screwturn.eu/

Zip Utilities
7Zip => http://www.7-zip.org/download.html

Online
Database Management
PhpMyAdmin => http://www.phpmyadmin.net/home_page/downloads.php

IDE
phpanywhere => http://phpanywhere.net/

Office
Google docs =>

Issue Tracker
Zoho => http://www.zoho.com/

Training
GCFLearnFree.org => http://www.gcflearnfree.org/
HTML5Rocks => ttp://www.html5rocks.com/
W3Schools => http://www.w3schools.com/

Still to sort
2 Advanced => http://www.2advanced.com/
Advanced System Care => http://www.iobit.com/advancedsystemcareper.html
Belarc Advisor => http://www.belarc.com/free_download.html
BurnAware => http://www.burnaware.com/
Cooliris => http://www.cooliris.com/
CutePDF => http://www.cutepdf.com/products/cutepdf/writer.asp
doPDF => http://www.dopdf.com/
DropBox => http://www.dropbox.com/install
Filezilla => http://filezilla-project.org/download.php
Foxit Reader => http://www.foxitsoftware.com/Secure_PDF_Reader/
Freshmeat => http://freshmeat.net/
Github => https://github.com/
Google Latitude => https://www.google.com/latitude/
Gmail => Gmail
Greenshot => http://getgreenshot.org/
IrfanView => http://www.irfanview.com/main_download_engl.htm
LastPass => https://lastpass.com/misc_download.php
Linq Pad => http://www.linqpad.net/
PathCopy => http://download.cnet.com/Path-Copy/3000-2072_4-10036463.html
PowerGUI => http://www.powergui.org/downloads.jspa
Secunia PSI => http://secunia.com/
Sendback
SnagIt => http://www.techsmith.com/download/snagit/default.asp
Spybot
StumbleUpon.com => http://www.stumbleupon.com/
VNC => http://vnc.en.softonic.com/
WinAmp => http://www.winamp.com/media-player/en
Xmind => http://www.xmind.net/downloads/
Yammer => https://www.yammer.com/company/desktop

Microsoft Visual Studio 2008

How do I change the default browser used in Visual Studio 2008

• Right click a page (.aspx, or on a folder)
• Select Browse With...
• Choose your browser
• Click set as Default



ASP.NET MVC
• Right click on Default.aspx
• Select Browse With...
• Choose your browser
• Click set as Default

How do I reload the cache of a website when pressing the start button (F5) in Visual Studio 2008

To reload the cache of the browser in Visual Studio 2008 when you've clicked the start button do the following:

• Once the browser has loaded up press and hold down the CTRL + F5 key.

How do I use a stored procedure with the linq data source
To use a stored procedure with the linq data source set the linq data sources ContextTypeName property to the DataContext class and create an OnSelecting method for the linq data source returning the stored procedure in the OnSelecting method. Below is an example to help explain the steps I've taken. In your .ascx, .aspx, etc file the linq data source should look something like below:

And your code behind will look something like the following:


How do I maintain the pages current position when inserting or updating a row in a GridView
To maintain the pages current position when inserting or updating a row in a GridView set your pages maintainScrollPositionOnPostBack attribute in the web.config to true as shown below: