CREATE DATABASE statement

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  June 13, 2002 at 3:42 pm

  #57980

  Hello everyone,

  I wanted to know if thereis any way that I can get the CREATE DATABASE sql statement for my databases. Perhapse a data dictionary view might store that info? Thanks for your help.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 13, 2002 at 5:37 pm

  #430852

  You can generate script for it from Enterprise Manager, or via the object browser in QA in SQL2K.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter