daily pastebin goal
66%
SHARE
TWEET

Untitled

a guest Jun 20th, 2018 44 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. EXEC %%DatabaseEx(Name = @dbname).SetCompatibility(Level = @input_cmptlevel)
  2.    
  3. -- does not return any result
  4. select  *
  5. from    sys.procedures
  6. where   [name] like '%DatabaseEx%'
  7.    
  8. -- Note: database @dbname may not exist anymore
  9. -- Change compatibility level
  10. -- If invoke gets error, exception will abort this proc.
  11. EXEC %%DatabaseEx(Name = @dbname).SetCompatibility(Level = @input_cmptlevel)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top