what is sqlserver T-SQL equivalent to oracles "show all" listing the set parms on the DB?
+3
A:
select @@options
see http://www.mssqltips.com/tip.asp?tip=1415 for how to decode this.
Martin Smith
2010-09-20 13:07:04
Thank martin useful link, Bring back Oracle all is forgiven this so long winded
icecurtain
2010-09-20 13:13:39
Martin you have answered this question the tick thing won't work
icecurtain
2010-09-20 13:19:26
also, `DBCC USEROPTIONS`. Can use `INSERT...EXEC ('DBCC USEROPTIONS')` to grab the values.
Peter
2010-09-20 13:50:45
Thanks Peter Mucho Grando just what I needed.
icecurtain
2010-09-20 14:33:38
How did you know his middle and last names were Mucho Grando?
Stephanie Page
2010-09-20 21:59:38