When you restore a Microsoft SQL Server database on a different machine, you cannot access the database until you fix the permissions.

The problem is that the user in the database is an "orphan". This means that there is no login id or password associated with the user. This is true even if there is a login id that matches the user, since there is a GUID (called a SID in Microsoft-speak) that has to match as well.

This used to be a pain to fix, but currently (SQL Server 2000, SP3 and higher) there is a stored procedure that does.

You should execute the stored procedure as a database admin, with the restored database selected

--First, make sure that this is the problem. This will lists the orphaned users:

EXEC sp_change_users_login 'Report' 

--If you already have a login id and password for this user, fix it by doing: 

EXEC sp_change_users_login 'Auto_Fix', 'user' 

--If you want to create a new login id and password for this user, fix it by doing: 

EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password' 

A neat regular expression function to strip the passed string of all HTML Tags.

public static string StripHTML ( string value )

{

    // Strip the html tagstring

    pattern = "<(.|\n)+?>"; 

    string strOutput = string.Empty; 

    Regex regex = new Regex ( pattern, RegexOptions.IgnoreCase ); 

    // Replace all HTML tag matches with an empty 

    stringstrOutput = regex.Replace(value, string.Empty); 

    // Replace all < and > with &lt; and &gt; 

    strOutput = strOutput.Replace("<", "&lt;"); 

    strOutput = strOutput.Replace ( ">", "&gt");

    return strOutput; 

}

studio NetSouls completes the design and development of this unique online shopping experience, The Scandihoovians Shopping Experience.

The Scandihoovians shopping experience of elegant design, cutting-edge jewellery and fashion, and friendly service.

Make it Simple
Make it Beautiful

A new wave of Scandinavian design is sweeping the world. It is colourful, stylish and just plain fun and you will find it first at Scandihoovians.

Scandinavian design is built on centuries of tradition, craftsmanship and innovation. It brings art, texture, beauty and the simplest of solutions to daily tasks in our homes and workplaces, combining elegance and function with lasting quality and enjoyment.

Scandihoovians brings it all together in our constantly expanding collection of modern Scandinavian design complemented by carefully selected international designs of exceptional quality.

We offer the same low prices at our store locations in Northampton, and Amherst, Massachusetts, as we offer nationally online. And great service, too.

Visit: www.scandihoovians.com