From Developers edition to Enterprise?

Hi,
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.
Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
|||Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>

From Developers edition to Enterprise?

Hi,
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>

From Developers edition to Enterprise?

Hi,
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>

French Canadian in France that needs help

Peaked a look, hey?
now try answering this

I've got on my computer
- SQL Server 2K
- my database

I open SQL Enterprise Manager

How can I create a new - L O C A L - Server under my Server Group
WITHOUT using the computer name (computername\instancename)Do you mean register one server twice? Not sure it can be done. Several folks around here have tried to do it, in order to have two different logins in Enterprise Manager (I don't even want to know why). You could try setting up an alias for the local machine in the Client Network Utility. I do not think anyone here has tried that out, yet. Good luck.|||how do you put an alias on the computer name with windows XP ?|||Are you asking how to create a share?|||nope

I don't want to have the computer name in the server name
to have an identical Server name for all the computers
installed with my program

(remember the 2000 dbs ?)|||I was trying to forget...

Damn...now I need to go shake up a pitcher...

I would start a list of all the Issues you run in to because of this design...

Did we say if this was MSDE or not? Gotta be, right?

Also what was the front end in? Is it also a local install just like the db?

Can the front end determine where it is and the establish it's own connection to the db?|||I want to able to connect to SQL Server with

driver={SQL Server};server=UniqueMachineName\Mercure;uid=sa;pw d=xxxx

OR

driver={SQL Server};server=(local);uid=sa;pwd=xxxx

I was able to add a LOCAL server with SQL Server 7
but not with SQL Server 2K|||Just to get this straight...this is because they are all stand alone database...or no?

And if they are do they talk to a single backend repository?|||yes they are all stand alone database
and yes I could get the machine name to build my connection string

BUT i've got Crystal reports directly connected to the database
and I don't want to have 2000 reports saved with different
connection string|||Over here we call them "Freedom Canadians".|||Nice !

you've been to Quebec ?
nicest city in the olllllllllllll world !

but icy-cold skiing|||I was planning to visit Quebec, but my buddy Conan O'Brien advised me not to!|||Ok ok ok ok ok...

Conan's a jackass who has never been funny.

Je me souviens!|||If you go, take a drink for me at the Chateau Frontenack|||I should be so lucky. Maybe we can hold a conference there and get our companies to pay for it.

Brett, do you suppose they serve Margaritas?
www.chateaufrontenac.com|||It's a nice hotel
but you don't have to pay for a room to enter and have a drink at the
panoramic bar

Beer is cheaper than usual bars...
and they even serve it with bols of free peanuts !|||Originally posted by Karolyn
It's a nice hotel
but you don't have to pay for a room to enter and have a drink at the
panoramic bar

Beer is cheaper than usual bars...
and they even serve it with bols of free peanuts !

They have many Books online AND Free peanuts!

Holy Sh-t

That's a cool bar.

Do they server Margarittas?|||In Quebec we drink beer
but if you want to play it "shobish"
with the little finger up
you can , OF COURSE, order a margaritta|||Hey now....

You've never had one of my Margarittas...

You'd never taste the booze...and there ain't much mix

...8...9...10...OUT|||And if it's to froo-froo...then I'll have

Beefeater...up...dry...olive...

Actually...you know what my favo(u*)rite drink is?

The one in front of me...

* for the continent|||Originally posted by Karolyn
It's a nice hotel
but you don't have to pay for a room to enter and have a drink at the
panoramic bar

Beer is cheaper than usual bars...
and they even serve it with bols of free peanuts !

I definitely need to be there ...

Now would that be a printed edition ? I have been searching too long for one.

Brett ... do you have any recipie to go along with Bacardi Limon ...|||Originally posted by Karolyn
In Quebec we drink beer


...but you're not in Kansas anymore....

What do you drink in France...beer?|||It's the country of alcool

Wine
Cognac
Calvados
Cider
Champagne
Pastis
...

But never all together (basic principle)

But nothing better than a nice cold beer in summer in your hammac|||Originally posted by Enigma
I definitely need to be there ...

Now would that be a printed edition ? I have been searching too long for one.

Brett ... do you have any recipie to go along with Bacardi Limon ...

Have you tried Tonic?

Very refreshing...and I bet the lemon rum would make a nice mix...

just plain run and tonic (with lime) is nice, especially at the beach...

Cheers

Dr. Mixology

Hey Karolyn...do you ski?|||Will try that ... i m thinking of trying something new (other than the whiskeys i normally have)|||I ski
the specialty in Quebec is icy skiing
'cause it's soooooooo cold the snow freezes|||Originally posted by Karolyn
I ski
the specialty in Quebec is icy skiing
'cause it's soooooooo cold the snow freezes

yeah...but some of the best skiiers in the world come out of the east...why? Because you had better know very good, sound fundamental techniques...otherwise your toast...

AND you have to LOVE skiing to go out and ski when it's -7F...wothout windchill...

am I right?

Hey, had the family on the slopes yesteday in the catskills...a balmy 25F, with a 1/2 foot of fresh snow...

jammin in the pow-pow...blues sky and sun...awesome...|||yah...
bah...
and you get a raccoon-suntan 'cause of the sunglasses
no way for me

(just jealous)|||Brett,

It's 26F in Montreal today. I'm sure that Quebec is just a few degrees lower. It can be cold, but we're not all Eskimos. Mind you I did survive a -90 windchill (-50 without) in Saskatoon one year.

-7 would have been balmy ;)

Originally posted by Brett Kaiser
yeah...but some of the best skiiers in the world come out of the east...why? Because you had better know very good, sound fundamental techniques...otherwise your toast...

AND you have to LOVE skiing to go out and ski when it's -7F...wothout windchill...

am I right?

Hey, had the family on the slopes yesteday in the catskills...a balmy 25F, with a 1/2 foot of fresh snow...

jammin in the pow-pow...blues sky and sun...awesome...|||Originally posted by SimSoph
Brett,

It's 26F in Montreal today. I'm sure that Quebec is just a few degrees lower. It can be cold, but we're not all Eskimos. Mind you I did survive a -90 windchill (-50 without) in Saskatoon one year.

-7 would have been balmy ;)

I don't know about you...but this has been a cooooooooooooooold winter...I don't remeber one being so cold for so long...

I mean the weather just warmed up (into the 20's) what a week or 2 ago...

Never experied -50 though...saw -22 one year though...the lifts froze...

Not that I was going skiing in that...the day before at -7 was quite brisk enough...with 20 mph winds...brrrrrrr...no skin exposed that day...

I gotta get up to tremblant one of these days...|||Use IP adresses as of server name !|||Huh?|||Good call Brett,
.
Tremblant is one of the most beautiful places I've ever been to. My wife and I get away for a weekend there every year. Golf there is amazing too.

I don't ski but apparently it is amazing there. It's a pretty quick drive from here in Ottawa.

Originally posted by Brett Kaiser
I don't know about you...but this has been a cooooooooooooooold winter...I don't remeber one being so cold for so long...

I mean the weather just warmed up (into the 20's) what a week or 2 ago...

Never experied -50 though...saw -22 one year though...the lifts froze...

Not that I was going skiing in that...the day before at -7 was quite brisk enough...with 20 mph winds...brrrrrrr...no skin exposed that day...

I gotta get up to tremblant one of these days...|||Originally posted by SimSoph
Good call Brett,
.
Tremblant is one of the most beautiful places I've ever been to. My wife and I get away for a weekend there every year. Golf there is amazing too.

I don't ski but apparently it is amazing there. It's a pretty quick drive from here in Ottawa.

Cool...now I gotta get there...you and the wife...are you BC? Before Children..if so go skiing now...a lot less to mobilize...but hey...we got the routine down now...and we all love it...

don't forget to take a lesson or 2...and if it's as beautiful as you say...try looking at it 4000ft up...awseome....

damn...now I'm jonse'n again...

Free Tool for MSSQL Admin

I'm looking for a free tool akin to SQL Server Enterprise Admin that i can use to administrate some of my databases on remote hosting from my home PC... any recommendations?

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Use the free Sql Management Studio you will be able to connect other database. Its free !!!

|||

hi,

check this

http://www.codeplex.com/SqlWebAdmin

Free space information in Management Studio

In Enterprise Manager, the taskpad view showed me how much space is available in the data and log files. Is this information available anywhere in SSMS?

For instance, in one database EM shows me that I have 1200MB free in the data file and 400MB free in the log file. It also says, at the top of the taskpad view, that I have 0 free space in the database - I'm not sure how they relate, but in SSMS the only number that I can see is the 0. It also takes several mouse clicks and scrolling over to see the breakdown of the data and log sizes.
In the object browser, highlight your database. On the right pane, click on the Summary tab. (If it is not there, hit F7.) Take a look at the Report dropdown. I think you'll like the Disk Usage report a little bit better than EM's archaic taskpad view. A wrote in message news:c99645b4-1bd4-45d3-8a71-46591c4597dd@.discussions.microsoft.com...
> In Enterprise Manager, the taskpad view showed me how much space is
> available in the data and log files. Is this information available
> anywhere in SSMS? >
> For instance, in one database EM shows me that I have 1200MB free in the
> data file and 400MB free in the log file. It also says, at the top of
> the taskpad view, that I have 0 free space in the database - I'm not
> sure how they relate, but in SSMS the only number that I can see is the
> 0. It also takes several mouse clicks and scrolling over to see the
> breakdown of the data and log sizes. >
>|||Thanks for the suggestion. However, the Report dropdown is greyed out on my Summary tab. I guess that's because we didn't install Reporting Services?
|||No, I don't have reporting services installed either. Are you sure the focus in the object browser is on a database name, like I originally suggested? >> In the object browser, highlight your database. The Summary tab is context sensitive, so if in the object browser you have highlighted "assemblies" or an individual stored procedure or table or the database diagrams node or server objects, the reports dropdown will be greyed out, because there are no reports relevant to those objects. A wrote in message news:6134a1d2-8631-434a-897c-6308dc7fef63@.discussions.microsoft.com...
> Thanks for the suggestion. However, the Report dropdown is greyed out on
> my Summary tab. I guess that's because we didn't install Reporting
> Services? >
>|||You're right - I must have had the focus in the wrong place. It is a nice report and contains a lot of useful information, but it took 2 minutes to run on an otherwise idle server (with 4 Xeon 3.6 processors in 64 bit mode, 4GB of RAM, and data and log on separate RAID 5 spindles). I would still like to have something that quickly gives me total size and free space at the file level.|||

> nice report and contains a lot of useful information, but it took 2
> minutes to run on an otherwise idle server The first time you ran it? Was that the only time you've run it? It may have had to do some background processing and/or caching the first time. My server is less powerful than that (virtual machine with 2 CPUs and 3 GB allocated), and it resides 60 miles away in our data center, and the report took 4 seconds to load on my paltry workstation (dual xeon 3.4, 2 GB). And I use this report all the time; if it was slow by nature and this instance wasn't a freak phenomenen, I'm sure I would have observed this issue before? A

|||It consitently takes over 2 minutes for our main databases. I suspect it has something to do with the size of the database or number of tables - our database has over 1100 tables. When I tried it on a much smaller database, it came back within a few seconds.|||

> our database has over 1100 tables. Ah, I see. Well, "quick" is a pretty lofty goal, then, unless you want relatively stale data. You could run queries on the hour that store this information into your own tables, then that query will be quick, but it won't be up-to-the-minute. A

|||So, in summary, if I am monitoring a SQL2000 server in SSMS 05 then there is no way for me to see the free space on my data files. AND if it's a large 2005 database I have to wait a long time for the report because it wants to give me details on every table. So much for a quick check of my systems!|||

I agree. Monitoring free space in data files is something a DBA does frequently, and so in SQL2000 Enterprise Manager I often used the Taskpad view for a quick check (even though it was buggy and would sometimes throw interface errors). I had been hunting for the same kind of quick reporting in SQL 2005 Management Studio, and thanks to this thread I figured it out... but I am STILL waiting for my first report to come up on Disk Usage, and it has been over 5 minutes now! I manage a large number of SAP databases, and this is the first one to be configured on SQL 2005 (the others are still 2000, but they will be upgraded soon). This is one of the smaller ones, at only 20 GB in size, but it still has 27,000 tables. I wonder what will happen when I move our 70 GB R/3 database onto this platform? Also, although I haven't checked this out yet, it appears that this disk usage report may be putting a certain amount of load on the server, based on anecdotal observation. That can't be good, if true.

It's true that I can get the information I want on any given single database very quickly by logging into the SAP application and running application-specific database monitor tools (and if the application can do it so quickly, why can't the Disk Usage report? After all, it's just a collection of system stored procedures like sp_spaceused with the output presented graphically). However, when trying to quickly get status on 20+ servers, it's a little tedious to log into each one individually, whereas the Taspad could move through them a little quicker (even though it's still one at a time).

Ok, after more than 10 minutes of execution time while writing this post, the Disk Usage report finally came back with something. However, the information is not what I had hoped for. It tells me "the information needed to display a summary page for the selected object is not available" and throws an error about "object reference not set to an instance of an object." It took 10 minutes to get to that?

|||

I can do you one better. I used the TaskPad the way you did -- space problems can be seen at a glance. I moved a db instance from 2000 to 2005, but we are running in 2000 compatibility mode until we can make some code changes. When I try to run the space report in Management Studio, it barks at me for being in 2000 compatibility mode. I can't hit the dbs from EM and I can't get the data in Managment Studio until I switch compatibility mode (and then I'll have a long running on-line report...lucky me).

I think in an effort to use their own framework and tools, Microsoft has taken away the beauty of quick access to data in this case. That's a lot of extra work to break something that already worked really pretty well.

|||

OK, further research uncovered the following:

http://www.sqlservercentral.com/columnists/bBaliner/quicklyviewingavailablespace.asp

I tweaked it by adding total space to the mix:

SELECT name AS NameOfFile, size/128.0 AS TotalSpaceInMB,size/128.0 -CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS AvailableSpaceInMB

FROM dbo.SYSFILES

Kudos to Boris Baliner!

Free space information in Management Studio

In Enterprise Manager, the taskpad view showed me how much space is available in the data and log files. Is this information available anywhere in SSMS?

For instance, in one database EM shows me that I have 1200MB free in the data file and 400MB free in the log file. It also says, at the top of the taskpad view, that I have 0 free space in the database - I'm not sure how they relate, but in SSMS the only number that I can see is the 0. It also takes several mouse clicks and scrolling over to see the breakdown of the data and log sizes.In the object browser, highlight your database.

On the right pane, click on the Summary tab.

(If it is not there, hit F7.)

Take a look at the Report dropdown. I think you'll like the Disk Usage

report a little bit better than EM's archaic taskpad view.

A

wrote in message

news:c99645b4-1bd4-45d3-8a71-46591c4597dd@.discussions.microsoft.com...

> In Enterprise Manager, the taskpad view showed me how much space is

> available in the data and log files. Is this information available

> anywhere in SSMS?

>

> For instance, in one database EM shows me that I have 1200MB free in the

> data file and 400MB free in the log file. It also says, at the top of

> the taskpad view, that I have 0 free space in the database - I'm not

> sure how they relate, but in SSMS the only number that I can see is the

> 0. It also takes several mouse clicks and scrolling over to see the

> breakdown of the data and log sizes.

>

>|||Thanks for the suggestion. However, the Report dropdown is greyed out on my Summary tab. I guess that's because we didn't install Reporting Services?|||No, I don't have reporting services installed either. Are you sure the

focus in the object browser is on a database name, like I originally

suggested?

>> In the object browser, highlight your database.

The Summary tab is context sensitive, so if in the object browser you have

highlighted "assemblies" or an individual stored procedure or table or the

database diagrams node or server objects, the reports dropdown will be

greyed out, because there are no reports relevant to those objects.

A

wrote in message

news:6134a1d2-8631-434a-897c-6308dc7fef63@.discussions.microsoft.com...

> Thanks for the suggestion. However, the Report dropdown is greyed out on

> my Summary tab. I guess that's because we didn't install Reporting

> Services?

>

>|||You're right - I must have had the focus in the wrong place. It is a nice report and contains a lot of useful information, but it took 2 minutes to run on an otherwise idle server (with 4 Xeon 3.6 processors in 64 bit mode, 4GB of RAM, and data and log on separate RAID 5 spindles). I would still like to have something that quickly gives me total size and free space at the file level.|||

> nice report and contains a lot of useful information, but it took 2

> minutes to run on an otherwise idle server

The first time you ran it? Was that the only time you've run it? It may

have had to do some background processing and/or caching the first time.

My server is less powerful than that (virtual machine with 2 CPUs and 3 GB

allocated), and it resides 60 miles away in our data center, and the report

took 4 seconds to load on my paltry workstation (dual xeon 3.4, 2 GB). And

I use this report all the time; if it was slow by nature and this instance

wasn't a freak phenomenen, I'm sure I would have observed this issue before?

A

|||It consitently takes over 2 minutes for our main databases. I suspect it has something to do with the size of the database or number of tables - our database has over 1100 tables. When I tried it on a much smaller database, it came back within a few seconds.|||

> our database has over 1100 tables.

Ah, I see. Well, "quick" is a pretty lofty goal, then, unless you want

relatively stale data. You could run queries on the hour that store this

information into your own tables, then that query will be quick, but it

won't be up-to-the-minute.

A

|||So, in summary, if I am monitoring a SQL2000 server in SSMS 05 then there is no way for me to see the free space on my data files. AND if it's a large 2005 database I have to wait a long time for the report because it wants to give me details on every table. So much for a quick check of my systems!|||

I agree. Monitoring free space in data files is something a DBA does frequently, and so in SQL2000 Enterprise Manager I often used the Taskpad view for a quick check (even though it was buggy and would sometimes throw interface errors). I had been hunting for the same kind of quick reporting in SQL 2005 Management Studio, and thanks to this thread I figured it out... but I am STILL waiting for my first report to come up on Disk Usage, and it has been over 5 minutes now! I manage a large number of SAP databases, and this is the first one to be configured on SQL 2005 (the others are still 2000, but they will be upgraded soon). This is one of the smaller ones, at only 20 GB in size, but it still has 27,000 tables. I wonder what will happen when I move our 70 GB R/3 database onto this platform? Also, although I haven't checked this out yet, it appears that this disk usage report may be putting a certain amount of load on the server, based on anecdotal observation. That can't be good, if true.

It's true that I can get the information I want on any given single database very quickly by logging into the SAP application and running application-specific database monitor tools (and if the application can do it so quickly, why can't the Disk Usage report? After all, it's just a collection of system stored procedures like sp_spaceused with the output presented graphically). However, when trying to quickly get status on 20+ servers, it's a little tedious to log into each one individually, whereas the Taspad could move through them a little quicker (even though it's still one at a time).

Ok, after more than 10 minutes of execution time while writing this post, the Disk Usage report finally came back with something. However, the information is not what I had hoped for. It tells me "the information needed to display a summary page for the selected object is not available" and throws an error about "object reference not set to an instance of an object." It took 10 minutes to get to that?

|||

I can do you one better. I used the TaskPad the way you did -- space problems can be seen at a glance. I moved a db instance from 2000 to 2005, but we are running in 2000 compatibility mode until we can make some code changes. When I try to run the space report in Management Studio, it barks at me for being in 2000 compatibility mode. I can't hit the dbs from EM and I can't get the data in Managment Studio until I switch compatibility mode (and then I'll have a long running on-line report...lucky me).

I think in an effort to use their own framework and tools, Microsoft has taken away the beauty of quick access to data in this case. That's a lot of extra work to break something that already worked really pretty well.

|||

OK, further research uncovered the following:

http://www.sqlservercentral.com/columnists/bBaliner/quicklyviewingavailablespace.asp

I tweaked it by adding total space to the mix:

SELECT name AS NameOfFile, size/128.0 AS TotalSpaceInMB,size/128.0 -CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS AvailableSpaceInMB

FROM dbo.SYSFILES

Kudos to Boris Baliner!

Free space information in Management Studio

In Enterprise Manager, the taskpad view showed me how much space is available in the data and log files. Is this information available anywhere in SSMS?

For instance, in one database EM shows me that I have 1200MB free in the data file and 400MB free in the log file. It also says, at the top of the taskpad view, that I have 0 free space in the database - I'm not sure how they relate, but in SSMS the only number that I can see is the 0. It also takes several mouse clicks and scrolling over to see the breakdown of the data and log sizes.

I agree. Monitoring free space in data files is something a DBA does frequently, and so in SQL2000 Enterprise Manager I often used the Taskpad view for a quick check (even though it was buggy and would sometimes throw interface errors). I had been hunting for the same kind of quick reporting in SQL 2005 Management Studio, and thanks to this thread I figured it out... but I am STILL waiting for my first report to come up on Disk Usage, and it has been over 5 minutes now! I manage a large number of SAP databases, and this is the first one to be configured on SQL 2005 (the others are still 2000, but they will be upgraded soon). This is one of the smaller ones, at only 20 GB in size, but it still has 27,000 tables. I wonder what will happen when I move our 70 GB R/3 database onto this platform? Also, although I haven't checked this out yet, it appears that this disk usage report may be putting a certain amount of load on the server, based on anecdotal observation. That can't be good, if true.

It's true that I can get the information I want on any given single database very quickly by logging into the SAP application and running application-specific database monitor tools (and if the application can do it so quickly, why can't the Disk Usage report? After all, it's just a collection of system stored procedures like sp_spaceused with the output presented graphically). However, when trying to quickly get status on 20+ servers, it's a little tedious to log into each one individually, whereas the Taspad could move through them a little quicker (even though it's still one at a time).

Ok, after more than 10 minutes of execution time while writing this post, the Disk Usage report finally came back with something. However, the information is not what I had hoped for. It tells me "the information needed to display a summary page for the selected object is not available" and throws an error about "object reference not set to an instance of an object." It took 10 minutes to get to that?

|||

I can do you one better. I used the TaskPad the way you did -- space problems can be seen at a glance. I moved a db instance from 2000 to 2005, but we are running in 2000 compatibility mode until we can make some code changes. When I try to run the space report in Management Studio, it barks at me for being in 2000 compatibility mode. I can't hit the dbs from EM and I can't get the data in Managment Studio until I switch compatibility mode (and then I'll have a long running on-line report...lucky me).

I think in an effort to use their own framework and tools, Microsoft has taken away the beauty of quick access to data in this case. That's a lot of extra work to break something that already worked really pretty well.

|||

OK, further research uncovered the following:

http://www.sqlservercentral.com/columnists/bBaliner/quicklyviewingavailablespace.asp

I tweaked it by adding total space to the mix:

SELECTnameAS NameOfFile,size/128.0 AS TotalSpaceInMB,size/128.0 -CAST(FILEPROPERTY(name,'SpaceUsed')ASint)/128.0 AS AvailableSpaceInMB

FROM dbo.SYSFILES

Kudos to Boris Baliner!

|||In the object browser, highlight your database. On the right pane, click on the Summary tab. (If it is not there, hit F7.) Take a look at the Report dropdown. I think you'll like the Disk Usage report a little bit better than EM's archaic taskpad view. A wrote in message news:c99645b4-1bd4-45d3-8a71-46591c4597dd@.discussions.microsoft.com...
> In Enterprise Manager, the taskpad view showed me how much space is
> available in the data and log files. Is this information available
> anywhere in SSMS? >
> For instance, in one database EM shows me that I have 1200MB free in the
> data file and 400MB free in the log file. It also says, at the top of
> the taskpad view, that I have 0 free space in the database - I'm not
> sure how they relate, but in SSMS the only number that I can see is the
> 0. It also takes several mouse clicks and scrolling over to see the
> breakdown of the data and log sizes. >
>|||Thanks for the suggestion. However, the Report dropdown is greyed out on my Summary tab. I guess that's because we didn't install Reporting Services?
|||No, I don't have reporting services installed either. Are you sure the focus in the object browser is on a database name, like I originally suggested? >> In the object browser, highlight your database. The Summary tab is context sensitive, so if in the object browser you have highlighted "assemblies" or an individual stored procedure or table or the database diagrams node or server objects, the reports dropdown will be greyed out, because there are no reports relevant to those objects. A wrote in message news:6134a1d2-8631-434a-897c-6308dc7fef63@.discussions.microsoft.com...
> Thanks for the suggestion. However, the Report dropdown is greyed out on
> my Summary tab. I guess that's because we didn't install Reporting
> Services? >
>|||You're right - I must have had the focus in the wrong place. It is a nice report and contains a lot of useful information, but it took 2 minutes to run on an otherwise idle server (with 4 Xeon 3.6 processors in 64 bit mode, 4GB of RAM, and data and log on separate RAID 5 spindles). I would still like to have something that quickly gives me total size and free space at the file level.|||

> nice report and contains a lot of useful information, but it took 2
> minutes to run on an otherwise idle server The first time you ran it? Was that the only time you've run it? It may have had to do some background processing and/or caching the first time. My server is less powerful than that (virtual machine with 2 CPUs and 3 GB allocated), and it resides 60 miles away in our data center, and the report took 4 seconds to load on my paltry workstation (dual xeon 3.4, 2 GB). And I use this report all the time; if it was slow by nature and this instance wasn't a freak phenomenen, I'm sure I would have observed this issue before? A

|||It consitently takes over 2 minutes for our main databases. I suspect it has something to do with the size of the database or number of tables - our database has over 1100 tables. When I tried it on a much smaller database, it came back within a few seconds.|||

> our database has over 1100 tables. Ah, I see. Well, "quick" is a pretty lofty goal, then, unless you want relatively stale data. You could run queries on the hour that store this information into your own tables, then that query will be quick, but it won't be up-to-the-minute. A

|||So, in summary, if I am monitoring a SQL2000 server in SSMS 05 then there is no way for me to see the free space on my data files. AND if it's a large 2005 database I have to wait a long time for the report because it wants to give me details on every table. So much for a quick check of my systems!

Free space in SQLServer

Hi,

I have SQL*Server 6.5.
In a database, I saw only 20MB of the 600MB datasegment was free (in Enterprise manager, I clicked on properties). I did recalculate, and it showed 0MB free.
When I issue a sp_spaceused on the same database, I get
database_name database_size unallocated space
---------- ------ ------
falonprod 800.00 MB 344.80 MB

reserved data index_size unused
------ ------ ------ ------
466120 KB 309606 KB 153164 KB 3350 KB

Why does it say I have 344 MB unallocated space ? Which one should I believe?Try this:

USE MyDB
sp_spaceused @.updateusage = 'TRUE'

(Remarks
sp_spaceused computes the amount of disk space used for data and indexes, and the disk space used by a table in the current database. If objname is not given, sp_spaceused reports on the space used by the entire current database.

When updateusage is specified, Microsoft SQL Server scans the data pages in the database and makes any necessary corrections to the sysindexes table regarding the storage space used by each table. There are some situations, for example, after an index is dropped, when the sysindexes information for the table may not be current. This process can take some time to run on large tables or databases. Use it only when you suspect incorrect values are being returned and when the process will not have an adverse effect on other users or processes in the database. If preferred, DBCC UPDATEUSAGE can be run separately.
) -- from MSDN

--John|||Thanks!

free distribution of "Database Engine"

Hi:

I'm an asp.net programmer and my database is in access format.
My server is Windows Server 2003 Enterprise Edition Service Pack 1.
I do not need microsoft access installed on my server to access my database through asp.net.

I want migrate my database to sql server 2005

Could I access my database in sql server 2005 format (mdf) through asp.net without sql server 2005 installed on the server?

could I buy to microsoft only "Database Engine"? or
Is there a free distribution of "Database Engine"?

Thanks!!

There is a free version of SQL Server 2005, SQL Server Express..

http://msdn.microsoft.com/vstudio/express/sql/

The data does need to be on some machine somewhere with SQL Server installed.

|||

Hi,

You do not need Access installed on the server, only the runtime (which I think ships with Windows these days, at the very worst the runtime is freely distributable if you have VSTO). You should take a look at SQL Server 2005 Express edition (http://msdn.microsoft.com/vstudio/express/sql/download/). Free, and as easy (or easier) to use as Access.

Hope this helps.

Free CR w/VS6 Enterprise

The folder info is:

Crystal Reports is shipped and installed as part of
the VB installation package except in VB6. This can
be found in \common\tools\crysrep
double click on crystl32.exe to install.Just be aware of the License Agreement (http://msdn2.microsoft.com/en-us/library/aa288179(vs.71).aspx)

4.2 You may not use the Software or a Server/Web Application on a rental or timesharing basis or to operate a service bureau facility for the benefit of third-parties unless you first acquire an Application Service Provider License from Crystal Decisions. The Runtime Software may be installed on only one server in each Server Environment, and only one instance of the Runtime Software per Server/Web Application may be utilized on that Server at any one time.

4.3 This license agreement does not in itself give you any right to distribute Server/Web Applications to third parties.

There are other restrictions (see the link), but these are the two that most often come into play.|||oddly enough, I couldn't find it in the Tools folder.

Seems to me that I installed it on the old machine, but never used it.