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.
Showing posts with label case. Show all posts
Showing posts with label case. Show all posts
Friday, February 24, 2012
Sunday, February 19, 2012
Enable and disable case sensitivity
Hi,
I use a SQL Server 2000.
Is there a chance to change the case sensitivity option for a running instance of sql server?
I know, during the install process, i can activate the case sensitivity. But can I change this option on an already installed server (to case sensitiv or back)?
ThanksYes you can,
this option is called collation. You can set it diferently as default for each database at the same SQL server. Also it can be set for each collumn in each table separately.
Marf.
Originally posted by jenswitte
Hi,
I use a SQL Server 2000.
Is there a chance to change the case sensitivity option for a running instance of sql server?
I know, during the install process, i can activate the case sensitivity. But can I change this option on an already installed server (to case sensitiv or back)?
Thanks|||I think for that you will need to rebuild master ... which is not highly recommended.|||Originally posted by MarF
Yes you can,
this option is called collation. You can set it diferently as default for each database at the same SQL server. Also it can be set for each collumn in each table separately.
Marf.
Thanks! It worked. I changed the collation of a database from case insensitive to case sensitive and back.|||ummmm...huh?
I use a SQL Server 2000.
Is there a chance to change the case sensitivity option for a running instance of sql server?
I know, during the install process, i can activate the case sensitivity. But can I change this option on an already installed server (to case sensitiv or back)?
ThanksYes you can,
this option is called collation. You can set it diferently as default for each database at the same SQL server. Also it can be set for each collumn in each table separately.
Marf.
Originally posted by jenswitte
Hi,
I use a SQL Server 2000.
Is there a chance to change the case sensitivity option for a running instance of sql server?
I know, during the install process, i can activate the case sensitivity. But can I change this option on an already installed server (to case sensitiv or back)?
Thanks|||I think for that you will need to rebuild master ... which is not highly recommended.|||Originally posted by MarF
Yes you can,
this option is called collation. You can set it diferently as default for each database at the same SQL server. Also it can be set for each collumn in each table separately.
Marf.
Thanks! It worked. I changed the collation of a database from case insensitive to case sensitive and back.|||ummmm...huh?
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.
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.
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.
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.
Subscribe to:
Posts (Atom)