"kind of bug" with sql server 2008

  • I am not understanding this behaviour of SQL Server 2008 (ent ed, sp3cu2). I configured my model database with adequate space so that any new database have default configuration of model.

    Now the problem is,

    When I am creating it via ssms qizrd, its creating the data and log files as exact of model.

    But,

    If I run simple tsql as "create database test", it still not creating the data and log file as per model. And also its not consistent of default things which is 3 mb for data and 1 mb for log (initial size). In some environment, this value also changing.

    Can someone point me right direction to understand this?

    I am not sure about other edition or version but my build level is 10.0.5768.0(sql 2008, sp3cu2) , 64 bit server and 64 bit sql where I am having this issue.

    ----------
    Ashish

  • Please ignore this duplicate thread as i moved it here http://www.sqlservercentral.com/Forums/Topic1413640-391-1.aspx

    thanks for looking

    ----------
    Ashish

Viewing 2 posts - 1 through 1 (of 1 total)

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