public DataTable ExecObjectDependInfo(string obj_name)
{
MSSqlService sql = new MSSqlService();
sql.AddParameter("@objname", SqlDbType.VarChar, obj_name);
return(sql.ExecuteSPDataSet(sp_depends).Tables[0]);
}
public DataTable ExecSPObjectInfo(StoredProcedureObject type, string procedure_name, string procedure_owner)
{
MSSqlService sql = new MSSqlService();
sql.AddParameter("@procedure_name", SqlDbType.VarChar, procedure_name);
sql.AddParameter("@procedure_owner", SqlDbType.VarChar, procedure_owner);
return(sql.ExecuteSPDataSet("sp_" + type.ToString()).Tables[0]);
}
public DataTable ExecTableObjectInfo(TableObject type, string table_name, string table_owner)
{
MSSqlService sql = new MSSqlService();
sql.AddParameter("@table_name", SqlDbType.VarChar, table_name);
sql.AddParameter("@table_owner", SqlDbType.VarChar, table_owner);
return(sql.ExecuteSPDataSet("sp_" + type.ToString()).Tables[0]);
}
public DataSet ExecObjectInfo(string obj_name = "")
{
MSSqlService sql = new MSSqlService();
if (obj_name != String.Empty)
{
sql.AddParameter("@objname", SqlDbType.VarChar, obj_name);
}
return(sql.ExecuteSPDataSet(sp_help));
}
public DataTable ExecDataTypeInfo()
{
MSSqlService sql = new MSSqlService();
return(sql.ExecuteSPDataSet(sp_datatype_info).Tables[0]);
}
public DataTable ExecDBInfo()
{
MSSqlService sql = new MSSqlService();
return(sql.ExecuteSPDataSet(sp_databases).Tables[0]);
}
public DataSet ExecMonitorDatabaseInfo()
{
MSSqlService sql = new MSSqlService();
return(sql.ExecuteSPDataSet(sp_monitor));
}