Post reply

sql query to find out sql server configuration deatils?

  • January 10, 2013 at 12:01 am

    #269095

    any sql query to find out sql server configuration details

    1. data and log file path

    2. data and log file are set to constant value

    3. Instant file initialization is enabled

    etc.

    any solution?

  • January 10, 2013 at 1:12 am

    #1575623

    use databasename

    go

    select * from sys.sysfiles

    go

    select * from sys.database_files

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • January 10, 2013 at 1:37 am

    #1575635

    sumith1andonly1 (1/10/2013)

    3. Instant file initialization is enabled

    Enforce it via group policy

  • January 10, 2013 at 1:44 am

    #1575640

    i mean check whether 'Instant file initialization' is enabled or not?

  • January 10, 2013 at 1:45 am

    #1575642

    you will need to find a way to query secpol.msc for the correct value then.

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

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