<?php
$DbHost = '';
$DbUserName = '';
$DbPass = '';
//Database name goes below, it must be in brackets ex: [12456_Dbname]
$DbName = '[]';

$result = mssql_connect($DbHost,$DbUserName,$DbPass);

if(!$result)
{
	die(mssql_get_last_message());
}
else
{
	echo "Successfully Connected to $DbHost<br>";
}

$dbget = mssql_select_db($DbName);

if(!$dbget)
{
	//die(mssql_error());
	echo "Error Occurred!";
}
else
{
	echo "$DbName was selected!<br>";
}

 mssql_select_db($DbName);

$query = mssql_query('SELECT * FROM sysobjects WHERE type = \'U\' ORDER BY NAME');

if(!$query)
{
	echo "Could not run query to list tables";
}
else
{
	while($row = mssql_fetch_row($query))
	{
		echo "Table: ".$row[0]."<br>";
	}
}

$new_statement = mssql_init('NewStatement');
mssql_execute($new_statement);

$dbclose=mssql_close($result);

if(!$dbclose)
{
	//die(mssql_error());
	echo "Error Occurred!";
}
else
{
	echo "db closed!<br>";
}

?>