internal static bool HasCreatePermissions(string connectString)
{
var returnVal = false;
var conn = new System.Data.SqlClient.SqlConnection();
SqlDataReader existsReader = null;
try
{
conn.ConnectionString = connectString;
conn.Open();
var cmdUserExist = new SqlCommand();
cmdUserExist.CommandText = "use [master] select case when Permissions()&1=1 then 1 else 0 end as hasAccess";
cmdUserExist.CommandType = System.Data.CommandType.Text;
cmdUserExist.Connection = conn;
existsReader = cmdUserExist.ExecuteReader();
if (existsReader.Read())
{
try
{
if (int.Parse(existsReader["hasAccess"].ToString()) == 1)
{
returnVal = true;
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
}
finally
{
if (existsReader != null)
existsReader.Close();
if (conn != null)
conn.Close();
}
return returnVal;
}
#endregion