Data Space Problem

Hello:
I have several SQL 2000 databases that displays 0 space
available when I view the properties of the database.
However when I change to the taskpad view, the view
indicates that there is space available.
Is this some kind of bug in SQL Server? Is there any fix
for it?
Any help would be appreciated?
Brennanrun DBCC UPDATEUSAGE and see if that helps.
Andrew J. Kelly SQL MVP
"Brennan" <anonymous@.discussions.microsoft.com> wrote in message
news:59ea01c40090$b4eedc60$a401280a@.phx.gbl...
> Hello:
> I have several SQL 2000 databases that displays 0 space
> available when I view the properties of the database.
> However when I change to the taskpad view, the view
> indicates that there is space available.
> Is this some kind of bug in SQL Server? Is there any fix
> for it?
> Any help would be appreciated?
> Brennan|||Thanks
That worked
Brennan

>--Original Message--
>run DBCC UPDATEUSAGE and see if that helps.
>--
>Andrew J. Kelly SQL MVP
>
>"Brennan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:59ea01c40090$b4eedc60$a401280a@.phx.gbl...
fix
>
>.
>

Data Space Problem

Hello:
I have several SQL 2000 databases that displays 0 space
available when I view the properties of the database.
However when I change to the taskpad view, the view
indicates that there is space available.
Is this some kind of bug in SQL Server? Is there any fix
for it?
Any help would be appreciated?
Brennanrun DBCC UPDATEUSAGE and see if that helps.
--
Andrew J. Kelly SQL MVP
"Brennan" <anonymous@.discussions.microsoft.com> wrote in message
news:59ea01c40090$b4eedc60$a401280a@.phx.gbl...
> Hello:
> I have several SQL 2000 databases that displays 0 space
> available when I view the properties of the database.
> However when I change to the taskpad view, the view
> indicates that there is space available.
> Is this some kind of bug in SQL Server? Is there any fix
> for it?
> Any help would be appreciated?
> Brennan|||Thanks
That worked
Brennan
>--Original Message--
>run DBCC UPDATEUSAGE and see if that helps.
>--
>Andrew J. Kelly SQL MVP
>
>"Brennan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:59ea01c40090$b4eedc60$a401280a@.phx.gbl...
>> Hello:
>> I have several SQL 2000 databases that displays 0 space
>> available when I view the properties of the database.
>> However when I change to the taskpad view, the view
>> indicates that there is space available.
>> Is this some kind of bug in SQL Server? Is there any
fix
>> for it?
>> Any help would be appreciated?
>> Brennan
>
>.
>

Data Output Tab

Does anyone know what the data output tabs are used for on all the
Properties dialogs?When you're outputting to xml, you can define xml options there.
"mjohnson1122@.hotmail.com" wrote:
> Does anyone know what the data output tabs are used for on all the
> Properties dialogs?
>

Data Link properties don't show any istance

Hi
Data Link Properties, open by test.udl file, when open don't show any
istance of MSDE sp3 installed.
By Visual Studio.NET 2003 Server Manager I can see the server and database.
If I insert manually name istance and try test connect it return me this
message:
Test connection failed because of an error initializing provider.
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access
denied.
My system is:
Windows XP pro
Visual Studio.NET 2003
MSDE sp3
MDAC 2.8
Can you help me?
I answered your later post, regarding the same issue.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Giuseppe Pezzella" <gpezzella@.yahoo.com> wrote in message
news:su31d.307127$5D1.13632538@.news4.tin.it...
> Hi
> Data Link Properties, open by test.udl file, when open don't show any
> istance of MSDE sp3 installed.
> By Visual Studio.NET 2003 Server Manager I can see the server and
database.
> If I insert manually name istance and try test connect it return me this
> message:
> Test connection failed because of an error initializing provider.
> [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access
> denied.
>
> My system is:
> Windows XP pro
> Visual Studio.NET 2003
> MSDE sp3
> MDAC 2.8
> Can you help me?
>