public bool UpdateExtendedProperty(DBObjectExtendedProperty type, string value, string object_name, string column_name = "", string property_name = "MS_Description")
{
MSSqlService sql = new MSSqlService();
sql.AddParameter("@name", SqlDbType.VarChar, property_name);
sql.AddParameter("@value", SqlDbType.VarChar, value);
sql.AddParameter("@level0type", SqlDbType.VarChar, "user");
sql.AddParameter("@level0name", SqlDbType.VarChar, "dbo");
sql.AddParameter("@level1type", SqlDbType.VarChar, type.ToString());
sql.AddParameter("@level1name", SqlDbType.VarChar, object_name);
if (type == DBObjectExtendedProperty.Column)
{
sql.AddParameter("@level2type", SqlDbType.VarChar, "column");
sql.AddParameter("@level2name", SqlDbType.VarChar, column_name);
}
try
{
sql.ExecuteSP(sp_updateextendedproperty);
return(true);
}
catch
{
return(false);
}
}
public void DeleteBackupHistory(DateTime date)
{
MSSqlService sql = new MSSqlService();
sql.AddParameter("@oldest_date", SqlDbType.DateTime, date);
sql.ExecuteSP(sp_delete_backuphistory);
}
public void BindDefault(string db_name, string table_name, string column_name, string default_value)
{
MSSqlService sql = new MSSqlService();
sql.AddParameter("@defname", SqlDbType.VarChar, default_value);
sql.AddParameter("@objname", SqlDbType.VarChar, db_name + "." + table_name + "." + column_name);
sql.ExecuteSP(sp_bindefault);
}
public void SetStoredProcedureExec(string sp_name, bool exec)
{
MSSqlService sql = new MSSqlService();
sql.AddParameter("@ProcName", SqlDbType.VarChar, sp_name);
sql.AddParameter("@OptionName", SqlDbType.VarChar, "start_up");
sql.AddParameter("@OptionValue", SqlDbType.VarChar, exec?"on":"off");
sql.ExecuteSP(sp_procoption);
}
