C#

Status SetMeasurableCharacterRanges(
    INT rangeCount,
    const CharacterRange *ranges
);

static void DetachPubsDB()<br />
{<br />
	//Creates a connection<br />
	string connStr = "provider=SQLOLEDB;Data Source=(local);User ID=sa;Password=;Initial Catalog=master; Network Library=dbmssocn";<br />
	OleDbConnection conn = new OleDbConnection(connStr);			<br />
		<br />
	try<br />
	{<br />
		conn.Open();<br />
<br />
		//Detaches the database<br />
		OleDbCommand cmdDetach = new OleDbCommand("sp_detach_db", conn);<br />
		cmdDetach.CommandType = CommandType.StoredProcedure;<br />
		cmdDetach.Parameters.Add("dbname", "Pubs");<br />
		cmdDetach.ExecuteNonQuery();<br />
<br />
		//Attaches the database<br />
		OleDbCommand cmdAttach = new OleDbCommand("sp_attach_db", conn);<br />
		cmdAttach.CommandType = CommandType.StoredProcedure;<br />
		cmdAttach.Parameters.Add("dbname", "Pubs");<br />
		cmdAttach.Parameters.Add("filename1", @"C:\Program Files\Microsoft SQL Server\Data\MSSQL\Data\pubs.mdf");<br />
		cmdAttach.Parameters.Add("filename2", @"C:\Program Files\Microsoft SQL Server\Data\MSSQL\Data\pubs_Log.ldf");<br />
		cmdAttach.ExecuteNonQuery();<br />
	}<br />
	catch(Exception excp)<br />
	{<br />
		Console.WriteLine(excp.Message);<br />
	}<br />
	finally<br />
	{<br />
		if(conn.State == ConnectionState.Open)<br />
			conn.Close();<br />
		conn.Dispose();<br />
	}<br />
}