Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Sql server list dbcc useroptions (See related posts)

// description of your code here

if not object_id('tempdb..#options') is null
	drop table #options;
go
create table #options (setOptions varchar(128), value varchar(50));
go
insert into #options
	exec('
dbcc useroptions')
go
select * from #options
to SQLServer dbcc useroptions by deostroll on Fri Jan 02 05:19:42 -0500 2009

You need to create an account or log in to post comments to this site.


Click here to browse all 6646 code snippets

Related Posts