Enabling the UnRestricted File Growth option using Query

Hello,
Can any one help me by providing me the scripts to Enable the
UNRESTRICTED FILE GROWTH FOR A DATABASE.
As i dont have access for the enterprise manage to open and do it
Thanks in Advance
Please it is very urgent
Cheers,
SaranALTER DATABASE Test1
MODIFY FILE
(NAME = test1dat3,
MAXSIZE = UNLIMITED,
FILEGROWTH = 10%)
GO
HTH. Ryan
<csesaravana@.gmail.com> wrote in message
news:1147705749.879232.101310@.j73g2000cwa.googlegroups.com...
> Hello,
> Can any one help me by providing me the scripts to Enable the
> UNRESTRICTED FILE GROWTH FOR A DATABASE.
> As i dont have access for the enterprise manage to open and do it
> Thanks in Advance
> Please it is very urgent
> Cheers,
> Saran
>|||Saran,
Use "alter database" statement.
Example:
use master
go
exec sp_helpdb northwind
go
alter database northwind
modify file (name=Northwind, MAXSIZE = 100MB)
go
exec sp_helpdb northwind
go
alter database northwind
modify file (name=Northwind, MAXSIZE = UNLIMITED)
go
exec sp_helpdb northwind
go
AMB|||Thanks for your reply
But when i try to execute the following query ,,
alter database D0015c0c_des
modify file (name=D0015c0c_des_data, MAXSIZE = UNLIMITED)
go
The following Error message is displayed
Server: Msg 226, Level 16, State 6, Line 1
ALTER DATABASE statement not allowed within multi-statement
transaction.
Please help me...
Thanks and Regards,
Saran|||Where do you execute this command? Query Analyzer? SQL Server Management Studio? Visual Studio?
Bottom line is that you seem to have opened a transaction when you execute this command, and the
error message clearly states that you cannot execute this command inside a transaction.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Saran" <csesaravana@.gmail.com> wrote in message
news:1147709905.925400.202260@.i40g2000cwc.googlegroups.com...
> Thanks for your reply
> But when i try to execute the following query ,,
> alter database D0015c0c_des
> modify file (name=D0015c0c_des_data, MAXSIZE = UNLIMITED)
> go
>
> The following Error message is displayed
> Server: Msg 226, Level 16, State 6, Line 1
> ALTER DATABASE statement not allowed within multi-statement
> transaction.
>
> Please help me...
> Thanks and Regards,
> Saran
>|||Thanks for ur reply!
I have solved the issues
Thank you once again for your help!!
Regards,
Saran

Enabling the UnRestricted File Growth option using Query

Hello,
Can any one help me by providing me the scripts to Enable the
UNRESTRICTED FILE GROWTH FOR A DATABASE.
As i dont have access for the enterprise manage to open and do it
Thanks in Advance
Please it is very urgent
Cheers,
SaranALTER DATABASE Test1
MODIFY FILE
(NAME = test1dat3,
MAXSIZE = UNLIMITED,
FILEGROWTH = 10%)
GO
HTH. Ryan
<csesaravana@.gmail.com> wrote in message
news:1147705749.879232.101310@.j73g2000cwa.googlegroups.com...
> Hello,
> Can any one help me by providing me the scripts to Enable the
> UNRESTRICTED FILE GROWTH FOR A DATABASE.
> As i dont have access for the enterprise manage to open and do it
> Thanks in Advance
> Please it is very urgent
> Cheers,
> Saran
>|||Saran,
Use "alter database" statement.
Example:
use master
go
exec sp_helpdb northwind
go
alter database northwind
modify file (name=Northwind, MAXSIZE = 100MB)
go
exec sp_helpdb northwind
go
alter database northwind
modify file (name=Northwind, MAXSIZE = UNLIMITED)
go
exec sp_helpdb northwind
go
AMB|||Thanks for your reply
But when i try to execute the following query ,,
alter database D0015c0c_des
modify file (name=D0015c0c_des_data, MAXSIZE = UNLIMITED)
go
The following Error message is displayed
Server: Msg 226, Level 16, State 6, Line 1
ALTER DATABASE statement not allowed within multi-statement
transaction.
Please help me...
Thanks and Regards,
Saran|||Where do you execute this command? Query Analyzer? SQL Server Management Stu
dio? Visual Studio?
Bottom line is that you seem to have opened a transaction when you execute t
his command, and the
error message clearly states that you cannot execute this command inside a t
ransaction.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Saran" <csesaravana@.gmail.com> wrote in message
news:1147709905.925400.202260@.i40g2000cwc.googlegroups.com...
> Thanks for your reply
> But when i try to execute the following query ,,
> alter database D0015c0c_des
> modify file (name=D0015c0c_des_data, MAXSIZE = UNLIMITED)
> go
>
> The following Error message is displayed
> Server: Msg 226, Level 16, State 6, Line 1
> ALTER DATABASE statement not allowed within multi-statement
> transaction.
>
> Please help me...
> Thanks and Regards,
> Saran
>|||Thanks for ur reply!
I have solved the issues
Thank you once again for your help!!
Regards,
Saran

Enabling file growth

I am trying to keep my log file at unrestricted file growth, but every time
I save the settings it switches back to restricted growth with a default
file size. I tried to keep it restricted, and change the size llimit, but
it changed back to it'd default limit. Why is this changing automaically by
itself.
I want to keep file growth enabled at 5% with unrestricted growth, but it
keeps changing back to 5% and resticted file growth with a default size. I
don't understand why it changes!!!!ALTER DATABASE [database_name] MODIFY FILE ( NAME = 'file_name',
FILEGROWTH = 5%)
What do you get when you run the above statement with your
database_name and file_name changed?
On Jun 14, 9:35 am, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!
On Jun 14, 9:35 am, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!|||On 14 Jun, 14:35, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!
Why do you want to grow the log at 5%? Log growth is something you
should try to avoid. My advice is to set it to a sufficient size so
that it won't grow.
If you need more help, please post the actual ALTER statements you
ran. Don't rely on the management tools to do it correctly for you.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Enabling file growth

I am trying to keep my log file at unrestricted file growth, but every time
I save the settings it switches back to restricted growth with a default
file size. I tried to keep it restricted, and change the size llimit, but
it changed back to it'd default limit. Why is this changing automaically by
itself.
I want to keep file growth enabled at 5% with unrestricted growth, but it
keeps changing back to 5% and resticted file growth with a default size. I
don't understand why it changes!!!!ALTER DATABASE [database_name] MODIFY FILE ( NAME = 'file_name',
FILEGROWTH = 5%)
What do you get when you run the above statement with your
database_name and file_name changed?
On Jun 14, 9:35 am, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every tim
e
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically
by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size.
I
> don't understand why it changes!!!!
On Jun 14, 9:35 am, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every tim
e
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically
by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size.
I
> don't understand why it changes!!!!|||On 14 Jun, 14:35, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every tim
e
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically
by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size.
I
> don't understand why it changes!!!!
Why do you want to grow the log at 5%? Log growth is something you
should try to avoid. My advice is to set it to a sufficient size so
that it won't grow.
If you need more help, please post the actual ALTER statements you
ran. Don't rely on the management tools to do it correctly for you.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Enabling file growth

I am trying to keep my log file at unrestricted file growth, but every time
I save the settings it switches back to restricted growth with a default
file size. I tried to keep it restricted, and change the size llimit, but
it changed back to it'd default limit. Why is this changing automaically by
itself.
I want to keep file growth enabled at 5% with unrestricted growth, but it
keeps changing back to 5% and resticted file growth with a default size. I
don't understand why it changes!!!!
ALTER DATABASE [database_name] MODIFY FILE ( NAME = 'file_name',
FILEGROWTH = 5%)
What do you get when you run the above statement with your
database_name and file_name changed?
On Jun 14, 9:35 am, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!
On Jun 14, 9:35 am, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!
|||On 14 Jun, 14:35, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!
Why do you want to grow the log at 5%? Log growth is something you
should try to avoid. My advice is to set it to a sufficient size so
that it won't grow.
If you need more help, please post the actual ALTER statements you
ran. Don't rely on the management tools to do it correctly for you.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx