Hi all, what i really want to know is what actualy tells sql server to grow
the database, file, i found a post that says something about xmb size, what
can find no other impormation, So my question is what event promts sql to
autogrow its database file,

Thanks Andrew

Whenever a connection is executing a query where space needed to be allocated (read about extents in
Books Online), and there is not space in the database file (or files if that object is on a
filegroup constituted of several files).

Show quoteHide quote

index scan and seek help...
Nocount
Blocking issue in sql2000
trigger or stored procedure
Error when creating new database user
Removing Domain Controller status from a SQL server
Linked Server "NOLOCK" problem on SQL 2000
[TCP/IP Sockets]ConnectionCheckForData()) Error
Performance dropped after upgraded to MS SQL 2000
SQLExpress 2005/Yukon documentation