Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

Can I use SQL Server 2005 Workgroup Edition for ADO.net 2?

Good day,

We have developed an application using VS 2005 and SQL Server 2005 Developer Edition.

Currently, our client is asking if they could buy the SQL Server 2005 Workgroup Edition.

Is it ok? I'm afraid that the SP we made using CLR and any other functionality might not work.

We are suggesting our client to use the SQL Server 2005 Standard Edition instead. But for them to save money, can they use the Workgroup Edition instead?

I would really appreciate your help.

Thanks and more power,

Arthur

Yes, sure this is possible. Due to the lack of knowing of what your application concists, you should doublecheck the feature comparison on your own:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

But for the "normal" and common features and programming this should be just fine unless you did not use any BI functionality.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thank you very much Jens for the information.

Can i use sql reporting svc with asp3.0 classic

Hi ,
I have to develop an application developed in asp 3.0 and now was wondering
if i could use MSSQL reproting services instead of using Crystal Reports.?
i know for design u need to have .net framework but can i integrate it while
using asp 3.0 and IIS 5.0
Thanks.
--KingIf you can figure out what the URL would be for a report, you can put
the report in an iframe, or even it's own page (i.e. a new window). Try
looking through the Reporting Services documentation for "URL Access."
Once you get the format of the URL down, it's pretty easy to customize
how the page loads. I do this to redirect users directly to PDFs of
reports.
~Andy
king wrote:
> Hi ,
> I have to develop an application developed in asp 3.0 and now was wondering
> if i could use MSSQL reproting services instead of using Crystal Reports.?
> i know for design u need to have .net framework but can i integrate it while
> using asp 3.0 and IIS 5.0
> Thanks.
> --King|||Thanks Andy.
That was helpful. Another question i have is if want the reports be
generated whenever the user clicks on the link ( i mean i wanna see latest
report everytime is it possible to do.
Also how can i implement security so that only authorized people can see
those reports . I am thinking of providing a login page and based on login
and password a person is able to see a particular report. so on the asp side
i can do it by authenticating the user against a table in database but what
about rs side .
If a person knows the url of the report can he see the report without login
?
THanks
"Andy Hardin" wrote:
> If you can figure out what the URL would be for a report, you can put
> the report in an iframe, or even it's own page (i.e. a new window). Try
> looking through the Reporting Services documentation for "URL Access."
> Once you get the format of the URL down, it's pretty easy to customize
> how the page loads. I do this to redirect users directly to PDFs of
> reports.
> ~Andy
> king wrote:
> > Hi ,
> > I have to develop an application developed in asp 3.0 and now was wondering
> > if i could use MSSQL reproting services instead of using Crystal Reports.?
> > i know for design u need to have .net framework but can i integrate it while
> > using asp 3.0 and IIS 5.0
> >
> > Thanks.
> >
> > --King
>|||The report should be freshly generated everytime someone accesses it.
I'm still trying to wrap my head around the security stuff. Every where
I've used RS has been in a domain environment where everyone has access
to all of the reports. You may want to search on google and the
newsgroup for information about implementing your own security.
~Andy
king wrote:
> Thanks Andy.
> That was helpful. Another question i have is if want the reports be
> generated whenever the user clicks on the link ( i mean i wanna see latest
> report everytime is it possible to do.
> Also how can i implement security so that only authorized people can see
> those reports . I am thinking of providing a login page and based on login
> and password a person is able to see a particular report. so on the asp side
> i can do it by authenticating the user against a table in database but what
> about rs side .
> If a person knows the url of the report can he see the report without login
> ?
> THanks
>
> "Andy Hardin" wrote:
>
>>If you can figure out what the URL would be for a report, you can put
>>the report in an iframe, or even it's own page (i.e. a new window). Try
>>looking through the Reporting Services documentation for "URL Access."
>>Once you get the format of the URL down, it's pretty easy to customize
>>how the page loads. I do this to redirect users directly to PDFs of
>>reports.
>>~Andy
>>king wrote:
>>Hi ,
>>I have to develop an application developed in asp 3.0 and now was wondering
>>if i could use MSSQL reproting services instead of using Crystal Reports.?
>>i know for design u need to have .net framework but can i integrate it while
>>using asp 3.0 and IIS 5.0
>>Thanks.
>>--King|||You may want to look at these articles on security in Reporting Services.
http://www.devx.com/dotnet/Article/26759/0/page/1
http://www.devx.com/dotnet/Article/27133/0
~Andy
king wrote:
> Thanks Andy.
> That was helpful. Another question i have is if want the reports be
> generated whenever the user clicks on the link ( i mean i wanna see latest
> report everytime is it possible to do.
> Also how can i implement security so that only authorized people can see
> those reports . I am thinking of providing a login page and based on login
> and password a person is able to see a particular report. so on the asp side
> i can do it by authenticating the user against a table in database but what
> about rs side .
> If a person knows the url of the report can he see the report without login
> ?
> THanks
>
> "Andy Hardin" wrote:
>
>>If you can figure out what the URL would be for a report, you can put
>>the report in an iframe, or even it's own page (i.e. a new window). Try
>>looking through the Reporting Services documentation for "URL Access."
>>Once you get the format of the URL down, it's pretty easy to customize
>>how the page loads. I do this to redirect users directly to PDFs of
>>reports.
>>~Andy
>>king wrote:
>>Hi ,
>>I have to develop an application developed in asp 3.0 and now was wondering
>>if i could use MSSQL reproting services instead of using Crystal Reports.?
>>i know for design u need to have .net framework but can i integrate it while
>>using asp 3.0 and IIS 5.0
>>Thanks.
>>--King

Can I ship database developed in SQL Server 2005 to customer ?

Hi,
sure you can use the SQL Server Express edition to distribute that to
your customer. it free for distribution. There are some extra features
/ gimmics if you register at the microsoft site (Didn=B4t tried that
yet), but in common yes you can use SQL Server Express.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--Hi,
I want to ask a question whether I can ship the database created in SQL
Server 2005 to customer along with installation for free of cost or not
(just like mySQL) ? Will I have to pay something to anybody for this ?
Please let me know as this will drive my decision of database engine
selection in .NET application.
Regards,
Jigar Mehta|||Hi,
sure you can use the SQL Server Express edition to distribute that to
your customer. it free for distribution. There are some extra features
/ gimmics if you register at the microsoft site (Didn=B4t tried that
yet), but in common yes you can use SQL Server Express.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Database created in SQL Server != Sql Server. Of course you can distribute
your database (stored in *.mdf and *.ldf file usually), but not the SQL
Server (unless it is SQL Server2005 Express or MSDE). The users of your app
must have SQL Server/Express/MSDE (latter tow are free) available somewhere
on their computer/network to host your DATABASE.
All in all, your database is yours, you can distribute it at your will. Your
user can get free edition of SQL Server Express (or distributed by your app)
or buy commercial edition (when the app's functionality requires that
power).
"Jigar" <jigar.programmer@.gmail.com> wrote in message
news:1150577676.753804.214600@.g10g2000cwb.googlegroups.com...
> Hi,
> I want to ask a question whether I can ship the database created in SQL
> Server 2005 to customer along with installation for free of cost or not
> (just like mySQL) ? Will I have to pay something to anybody for this ?
> Please let me know as this will drive my decision of database engine
> selection in .NET application.
> Regards,
> Jigar Mehta
>|||Database created in SQL Server != Sql Server. Of course you can distribute
your database (stored in *.mdf and *.ldf file usually), but not the SQL
Server (unless it is SQL Server2005 Express or MSDE). The users of your app
must have SQL Server/Express/MSDE (latter tow are free) available somewhere
on their computer/network to host your DATABASE.
All in all, your database is yours, you can distribute it at your will. Your
user can get free edition of SQL Server Express (or distributed by your app)
or buy commercial edition (when the app's functionality requires that
power).
"Jigar" <jigar.programmer@.gmail.com> wrote in message
news:1150577676.753804.214600@.g10g2000cwb.googlegroups.com...
> Hi,
> I want to ask a question whether I can ship the database created in SQL
> Server 2005 to customer along with installation for free of cost or not
> (just like mySQL) ? Will I have to pay something to anybody for this ?
> Please let me know as this will drive my decision of database engine
> selection in .NET application.
> Regards,
> Jigar Mehta
>

Can I ship database developed in SQL Server 2005 to customer ?

Hi,
I want to ask a question whether I can ship the database created in SQL
Server 2005 to customer along with installation for free of cost or not
(just like mySQL) ? Will I have to pay something to anybody for this ?
Please let me know as this will drive my decision of database engine
selection in .NET application.
Regards,
Jigar MehtaHi,
sure you can use the SQL Server Express edition to distribute that to
your customer. it free for distribution. There are some extra features
/ gimmics if you register at the microsoft site (Didn=B4t tried that
yet), but in common yes you can use SQL Server Express.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Database created in SQL Server != Sql Server. Of course you can distribute
your database (stored in *.mdf and *.ldf file usually), but not the SQL
Server (unless it is SQL Server2005 Express or MSDE). The users of your app
must have SQL Server/Express/MSDE (latter tow are free) available somewhere
on their computer/network to host your DATABASE.
All in all, your database is yours, you can distribute it at your will. Your
user can get free edition of SQL Server Express (or distributed by your app)
or buy commercial edition (when the app's functionality requires that
power).
"Jigar" <jigar.programmer@.gmail.com> wrote in message
news:1150577676.753804.214600@.g10g2000cwb.googlegroups.com...
> Hi,
> I want to ask a question whether I can ship the database created in SQL
> Server 2005 to customer along with installation for free of cost or not
> (just like mySQL) ? Will I have to pay something to anybody for this ?
> Please let me know as this will drive my decision of database engine
> selection in .NET application.
> Regards,
> Jigar Mehta
>

Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there points
that should be considered in doing this replacement?
Thanks,
GG
I don't know the pure "from a software point of view", however, if the
software requires so many connections that exceeds MSDE can do, then you are
doomed. So it's not only the pure software.
"GG" <GG@.discussions.microsoft.com> wrote in message
news:3B2A4FC7-B056-4B88-9781-7777473DD7AA@.microsoft.com...
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a software
> point of view? Can I replace the standard edition with MSDE? Are there
> points
> that should be considered in doing this replacement?
> Thanks,
> GG

Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there point
s
that should be considered in doing this replacement?
Thanks,
GGI don't know the pure "from a software point of view", however, if the
software requires so many connections that exceeds MSDE can do, then you are
doomed. So it's not only the pure software.
"GG" <GG@.discussions.microsoft.com> wrote in message
news:3B2A4FC7-B056-4B88-9781-7777473DD7AA@.microsoft.com...
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a software
> point of view? Can I replace the standard edition with MSDE? Are there
> points
> that should be considered in doing this replacement?
> Thanks,
> GG

Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there points
that should be considered in doing this replacement?
Thanks,
GGI don't know the pure "from a software point of view", however, if the
software requires so many connections that exceeds MSDE can do, then you are
doomed. So it's not only the pure software.
"GG" <GG@.discussions.microsoft.com> wrote in message
news:3B2A4FC7-B056-4B88-9781-7777473DD7AA@.microsoft.com...
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a software
> point of view? Can I replace the standard edition with MSDE? Are there
> points
> that should be considered in doing this replacement?
> Thanks,
> GG

Can I replace SQL Server Standard Edition with MSDE?

Hi,
We have a software that is developed by using MS SQL Server Standard
Edition. The vendor claims that the software cannot be used with MSDE.
The question is:
Are MSDE and SQL Server Standard Edition exactly the same from a software
point of view? Can I replace the standard edition with MSDE? Are there points
that should be considered in doing this replacement?
Thanks,
GG
hi,
GG wrote:
> Hi,
> We have a software that is developed by using MS SQL Server Standard
> Edition. The vendor claims that the software cannot be used with MSDE.
> The question is:
> Are MSDE and SQL Server Standard Edition exactly the same from a
> software point of view? Can I replace the standard edition with MSDE?
> Are there points that should be considered in doing this replacement?
> Thanks,
> GG
they both share the same code base, and actually are the same, but they do
have different in-built limitations..
MSDE includes a Query Governor that kicks in when 8 (5user+3system)
concurrent workloads are executed slowing down the whole system, it limits
CPU (2) and memory use (2gb) , it limits database size (2gb), it does not
provide FullText and Analysis Services, nor does it support Reporting
Services..
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
it depends on your ISV requirements...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply