SQL 6.5 Auto File Growth

[krotha]

Hi Everyone
I am getting error in SQL 6.5 Database. How shall I make default file size auto increment in SQL 6.5, I have worked in SQL 2000 But not in 6.5

Error 1105 Severity 17, State 1. Can't allocate space for object 'datafile' in database 'dbname' because the 'default' segement is full. If you ran out of space in syslogs, dump the transaction log. otherwise, use alter database or sp_extendsegment to increase the size of the segments.

Thanks for your help.

 

[Kressmark]

Hi,

Auto-grow & auto Shrink was a new feature in SQL 7.
SQL 6.5 does not support it. Why are you running SQL 6.5 for, anyway?

http://www.tedroche.com/Present/2000/DEV311Doc.htm

/mk