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 SQL Server Agent by using scripts

Hi NG,
how do I have to enable the SQL Server Agent by using command line scripts
(without the Enterprise Manager). According to SQLServer books online the
command line command sqlagent should only be used for diagnostic purposes.
thanks for help, reneRene,
To start SQL Server Agent from the commandline you can do this:
net start sqlserveragent
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Re Fo wrote:
> Hi NG,
> how do I have to enable the SQL Server Agent by using command line scripts
> (without the Enterprise Manager). According to SQLServer books online the
> command line command sqlagent should only be used for diagnostic purposes.
> thanks for help, rene
>|||Thanks,
can I set it somewhere in the registry that the service will alwyas be
started, as I can set it in the Services properties?
Thanks for help, rene
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ec0Gbwf4EHA.1976@.TK2MSFTNGP09.phx.gbl...
> Rene,
> To start SQL Server Agent from the commandline you can do this:
> net start sqlserveragent
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Re Fo wrote:
> > Hi NG,
> >
> > how do I have to enable the SQL Server Agent by using command line
scripts
> > (without the Enterprise Manager). According to SQLServer books online
the
> > command line command sqlagent should only be used for diagnostic
purposes.
> >
> > thanks for help, rene
> >
> >|||There are two places you can do this.
1)
Enterprise Manager-->General Tab, Tick AutoStart SQL Server Agent
2)
In Services Control Panel Applet, you can set the SQLServerAgent service
to AutoStart.
or if these don't work, you could even do this:
3)
CREATE PROC sp_startagent
AS
exec master..xp_cmdshell 'net start sqlserveragent', no_output
GO
exec sp_procoption N'sp_startagent', N'startup', N'true'
GO
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Re Fo wrote:
> Thanks,
> can I set it somewhere in the registry that the service will alwyas be
> started, as I can set it in the Services properties?
> Thanks for help, rene
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ec0Gbwf4EHA.1976@.TK2MSFTNGP09.phx.gbl...
>>Rene,
>>To start SQL Server Agent from the commandline you can do this:
>>net start sqlserveragent
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602m.html
>>
>>Re Fo wrote:
>>Hi NG,
>>how do I have to enable the SQL Server Agent by using command line
> scripts
>>(without the Enterprise Manager). According to SQLServer books online
> the
>>command line command sqlagent should only be used for diagnostic
> purposes.
>>thanks for help, rene
>>
>
>

Enabling SQL Server Agent by using scripts

Hi NG,
how do I have to enable the SQL Server Agent by using command line scripts
(without the Enterprise Manager). According to SQLServer books online the
command line command sqlagent should only be used for diagnostic purposes.
thanks for help, rene
Rene,
To start SQL Server Agent from the commandline you can do this:
net start sqlserveragent
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Re Fo wrote:
> Hi NG,
> how do I have to enable the SQL Server Agent by using command line scripts
> (without the Enterprise Manager). According to SQLServer books online the
> command line command sqlagent should only be used for diagnostic purposes.
> thanks for help, rene
>
|||Thanks,
can I set it somewhere in the registry that the service will alwyas be
started, as I can set it in the Services properties?
Thanks for help, rene
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ec0Gbwf4EHA.1976@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Rene,
> To start SQL Server Agent from the commandline you can do this:
> net start sqlserveragent
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Re Fo wrote:
scripts[vbcol=seagreen]
the[vbcol=seagreen]
purposes.[vbcol=seagreen]
|||There are two places you can do this.
1)
Enterprise Manager-->General Tab, Tick AutoStart SQL Server Agent
2)
In Services Control Panel Applet, you can set the SQLServerAgent service
to AutoStart.
or if these don't work, you could even do this:
3)
CREATE PROC sp_startagent
AS
exec master..xp_cmdshell 'net start sqlserveragent', no_output
GO
exec sp_procoption N'sp_startagent', N'startup', N'true'
GO
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Re Fo wrote:
> Thanks,
> can I set it somewhere in the registry that the service will alwyas be
> started, as I can set it in the Services properties?
> Thanks for help, rene
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ec0Gbwf4EHA.1976@.TK2MSFTNGP09.phx.gbl...
>
> scripts
>
> the
>
> purposes.
>
>

Enabling Replication Question

Can I enable replication from a different server that has Enterprise
Manager install than the one that hosts the SQL database without any
problems or side effects?
I cannot enable replication from my server (Server A) hosting SQL
Server because the registration name is (local) instead of the server
name. Yes I know I can delete the registration and re-register it
with the server name BUT my ERP software vendor warns me by doing I
will break some of their core processing functionality because it
relies on the SQL Server registration name.
So to avoid this problem my though would be to enable replication from
(Server B) that has SQL Server Enterprise Manager installed and points
to Server A. My question is this - Can I successfully enable
replication through this process or will I encounter other problems or
create other issues?
I'm running SQL Server 2000.
Thanks for any information, comments or generally better ideas!Hi,
You can register server A in the Enterprise Manager on ANY machine
that has Enterprise Manager (and network access) -- including server B
-- and set up replication, or any other SQL administration tasks, on
server A.
Ken
On Feb 21, 5:31 pm, "dfrazell" <dfraz...@.estoneworks.com> wrote:
> Can I enable replication from a different server that has Enterprise
> Manager install than the one that hosts the SQL database without any
> problems or side effects?
> I cannot enable replication from my server (Server A) hosting SQL
> Server because the registration name is (local) instead of the server
> name. Yes I know I can delete the registration and re-register it
> with the server name BUT my ERP software vendor warns me by doing I
> will break some of their core processing functionality because it
> relies on the SQL Server registration name.
> So to avoid this problem my though would be to enable replication from
> (Server B) that has SQL Server Enterprise Manager installed and points
> to Server A. My question is this - Can I successfully enable
> replication through this process or will I encounter other problems or
> create other issues?
> I'm running SQL Server 2000.
> Thanks for any information, comments or generally better ideas!|||On Feb 21, 9:36 pm, "KenJ" <kenjohn...@.hotmail.com> wrote:
> Hi,
> You can register server A in the Enterprise Manager on ANY machine
> that has Enterprise Manager (and network access) -- including server B
> -- and set up replication, or any other SQL administration tasks, on
> server A.
> Ken
> On Feb 21, 5:31 pm, "dfrazell" <dfraz...@.estoneworks.com> wrote:
> > Can I enable replication from a different server that has Enterprise
> > Manager install than the one that hosts the SQL database without any
> > problems or side effects?
> > I cannot enable replication from my server (Server A) hosting SQL
> > Server because the registration name is (local) instead of the server
> > name. Yes I know I can delete the registration and re-register it
> > with the server name BUT my ERP software vendor warns me by doing I
> > will break some of their core processing functionality because it
> > relies on the SQL Server registration name.
> > So to avoid this problem my though would be to enable replication from
> > (Server B) that has SQL Server Enterprise Manager installed and points
> > to Server A. My question is this - Can I successfully enable
> > replication through this process or will I encounter other problems or
> > create other issues?
> > I'm running SQL Server 2000.
> > Thanks for any information, comments or generally better ideas!
So to clarify - I can enable replication on Server A from Server B
regardless of the SQL registration name of Server A without any side
effects?
Thanks - Dave|||As the server name of Server A will be the correct one when looking from
Server B's enterprise manager, I see no problems here provided you have a
sysadmin user. Some of the settings are local to the ServerA though (eg the
distribution working folder) so you might want to use a remote desktop as
well to set up the necessary share.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Enable to start the Sql ENTERPRISE MANAGER

Can any one help me to solve this problem, I WAS ENABLE TO START THE Sql ENTERPRISE MANAGER

Anywhere i have try several way to make it right
1. unregister the sqldmo.dll file n register again
2. copy the ati.dll into antoher dir, but i fail to do it and this solution is provide by MSDN homepage.

i have reinstalll it 2 times, ....i hope i get the solution.

system using
WINDOWS XP servicepack 2
SQL SERVER 2000 Personal edition.
VS 2003 Enterprise

Thanks to microsoft and msdn forum MVP.|||

Hi,

i encountered the problem for myself several times, which was related due to an unregistered classid (whatever that triggered). Reinstalling or repairing the installation fixed the problem everytime. Are you also running the most current service pack ?

BTW: You have a very cool wallpaper on your desktop :-D

HTH, Jens Suessmeyer.

-
http://www.sqlserver2005.de
-

|||

I was failed to do it. I try all the solution provide by microsoft.

Everytime i install sql server 2000, at the end of the installation there will prompt out an error

Fail to register Active X component

Error : 0X80020009

:'(

|||

for your information

i have try to unregister n register the following dll

sqlns.dll

sqlmmc.dll

sqllex.dll

sqldmo.dll

dtsur.dll

odbcbcp.dll

but still not working

|||Have you tried adding the SQL Server Enterprise Manager by creating your own MMC Snap-In?|||

Oh yeah ....i fail to register the sqlmmc.dll. but i sucessfull unregister it.

so it is cause me this problem?

the error message is 0x80004005

EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, Bob
See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob
|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/[vbcol=seagreen]
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
than
>
>.
>
|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron
|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>
|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.

EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, Bob
See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob
|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/[vbcol=seagreen]
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
than
>
>.
>
|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron
|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>
|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.

EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, BobSee DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
than[vbcol=seagreen]
>
>.
>|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.

EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, BobSee DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
>> Anyone ever see a case where the Space Available number
>> reported in Enterprise Manager's General Database
>> Properties tab is wrong?
>> My database has the following characteristics:
>> -1- Has a Daily Backup Maintenance plan (no other
>> optimizations such as data reorg and such)
>> -2- Simple Recovery Model
>> -3- Auto Update Statistics = on
>> -4- Auto Create Statistics = on
>> -5- All other settings on Options tab = off
>> I went and increased the data file to 500 MB larger
than
>> the current size and still do not see Available space
>> increase. It's sitting at 0.
>> Any explanations/assistance would be greatly
>> appreciated. Thanks, Bob
>
>.
>|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>> Anyone ever see a case where the Space Available number
>> reported in Enterprise Manager's General Database
>> Properties tab is wrong?
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.

Empty Column ??

I am having some weird issues that I cannot figure out.
- When I right click on a table using Enterprise Manager and return all
rows I see data except that one column is showing nothing. From in
that window I do a IS NULL query verify that there is in fact data in
the column and a LENGTH to verify it's length.
- If I open up the exact same database from within EM and do a select
ont he table it returns all rows and the column is no longer empty but
is showing the correct values.
I am using SA login for both tools. The column datatyype is VARCHAR
(4000), The tools are local and connection to a DB on another server.
There is no padding whatsoever.
Please help me
Ok I did a RTRIM ont he column and now everything is fine, seems there
were some trailing spaces. WHat was weird though was that in my friend
EM he could see the column fine even when I couldn't. Any setting that
would cause this?