1. Run SQL Server Configuration Manager. Expand SQL Server Network Configuration and select Protocols for MSSQLSERVER. Make sure Named Pipes and TCP/IP are enabled.
2. Run Windows Firewall. Click on "Allow a program through Windows Firewall". Check if port 1433 is allowed. If not, then click on "Add port...". Add the following details; Name = Port 1433 - SQL Server 2008, Port = 1433, Protocol = TCP.
3. If you are also accessing SQL Server Reporting Services reports, check if port 80 is allowed. If not, then click on "Add port...". Add the following details; Name = Port 80 - HTTP, Port = 80, Protocol = TCP.

To change the location of the offline files are saved:

1. Make sure you have Exited Outlook.
2. Click Start, and then click Control Panel.
3. Double-click Mail, and then click E-mail Accounts.
4. Click View or change existing e-mail accounts, and then click Next.
5. Select the Microsoft Exchange Server account, and then click Change.
6. Clear the Use Cached Exchange Mode check box.
7. Click More Settings.
8. Click the Advanced tab.
9. Click Offline Folder File Settings.
10. Click Disable Offline Use, and then click Yes in the dialog box that appears.
11. Click Offline Folder File Settings.
12. Click Browse, go to the location where you want to save your .ost file, and then click Open.
13. Click OK.
14. Select the Use Cached Exchange Mode check box.
15. Click Next, and then click Finish.

The Microsoft Future Pro Photographers Photography Contest is the most lucrative contest of its kind and provides a unique opportunity for college and university student photographers from around the world to showcase their artistic talent and photographic style.

Microsoft is committed to carrying the art of digital photography forward by encouraging new and emerging talent at the student level to learn, utilize, and implement state-of-the-art equipment, software, and techniques to produce the finest images possible.
http://prophoto.microsoft.avitivacorp.com/Site.aspx

You can view some great galleries as well as download fantastic new tools.
http://www.microsoft.com/prophoto/default.aspx

SQL Server 2008 introduces MERGE, a new keyword which performs INSERT, UPDATE and DELETE operations at one go. With SQL Server 2008, you can perform the above operation as simple as the following code.

CREATE PROC dbo.usp_MergeSQL
(
     @pID INT OUTPUT,
     @pName VARCHAR(80)
)
AS
BEGIN
     SET NOCOUNT ON;
     MERGE dbo.Table1 t
     USING (SELECT @pName
            ) p(Name)
     ON t.Name = @pName
 
     WHEN NOT MATCHED THEN
     INSERT (Name)
     VALUES (@pName)
 
     WHEN MATCHED THEN
     UPDATE SET @pID = ID;
 
     SET @pID = COALESCE(SCOPE_IDENTITY(),@pID);
 
END
RETURN
 

For the keen photographers out there,

Have you heard of Shutterstock? It is an exciting program that can turn your photos into cash!
ShutterStock will sell your photos and pay you for each one that's downloaded!

Sign up for free at http://submit.shutterstock.com and start to make $$$ from your photos!

Submit Photos to ShutterStock and make $$$!

Check out My Gallery Here

Download unlimited stock photos!