Post reply

Return DB Info

  • September 11, 2002 at 10:36 am

    #58029

    Does anyone know of a script to return the Server Name, DBName, DBO, Version, size of DB, and when last modified. There may already be a script posted somewhere around here, so if anybody finds it before I do, posting the link would be great. Thanks in advance for any help.

    -pat

  • September 11, 2002 at 6:56 pm

    #436356

    In this link, there's a script that show some info from a given database. It is posted by me and if you don´t like I can create a new one for you.

    http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=145

  • September 12, 2002 at 10:51 am

    #436399

    any ideas on how to get server name, dbname, DB owner, and version?

  • September 12, 2002 at 6:06 pm

    #436450

    To find the server name: Select @@servername

    DBName:select db_name() (where you are running it)

    DBO,size with sp_helpdb.

    The server version with: select @@version

  • September 13, 2002 at 7:47 am

    #436485

    thanks for your help. I appreciate it.

    -pat

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply