Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Database Engine

sp_dboption

I noticed that BOL says that the above is possibly going away. What's the official way to print out all your db options once it goes away, i.e. what are we supposed to do to quickly look at dboptions with doing sp_dboption 'databasename'?
[242 byte] By [CLM] at [2008-2-7]
«« AS Support for Teradata
»» 2 Windows App. Deployment Questions
# 1

You should use select * from sys.databases where name ='databasename'
/choose columns that you need/
Thanks
Mirek

MirekSztajno at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 2

Aaahhh...the old fashioned way...

CLM at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 3
Well, personally I think this is a better way
Mirek
MirekSztajno at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 4
sorry, didn't mean anything by that. I just was wondering what direction MS was pushing us. thx.
CLM at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
SQL Server
SQL Server Database Engine

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified