database options

• sani

  SSCrazy

  Points: 2477

  More actions

  January 4, 2004 at 4:17 am

  #65908

  hi all,

  is there any stored procedure which give a complete information about a database configuration like : collation , ... . I used sp_dboptions but it isn't complete.

  tanx in advance

  sani

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  January 4, 2004 at 6:08 am

  #488574

  use DATABASEPROPERTYEX( database , property )

  for example select convert(sysname,DatabasePropertyEx('MyDB','Collation'))

  see BOL

  Bye

  Gabor

  
  
  Bye
  Gabor

• sani

  SSCrazy

  Points: 2477

  More actions

  January 4, 2004 at 10:08 pm

  #488619

  hi nyulg ,

  tanx for ur reply it works fine. But I search for a command to give me total information about a database. Do u have any idea?

  sani

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  January 5, 2004 at 12:42 am

  #488626

  sqldmo script database-properties ?

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• Amit Jethva

  SSCarpal Tunnel

  Points: 4707

  More actions

  January 5, 2004 at 1:51 am

  #488635

  What exactly is "total information" of a database that you are looking for ?

  Is it the information showed in SQL EM ?

   

  Amit

  
  

  -- Amit

  ---

  
  "There is no 'patch' for stupidity."

  ---

  
  Download the Updated SQL Server 2005 Books Online.