front end for cubes

currently i use MSInsight as my cubes front end. its an asp page that users can build reports from cubes. its pretty old, and since ive started upgrading to AS2005, it doesnt work properly, leading me to think that it is not compatiable with AS2005 cubes. so im wondering, whats a good front end that can be used by many users? this rules excel out, as i need a front end that can be used my many users.

I can't speak to whether it's good, as I haven't used it, but here's one:

http://www.radarcube.com/products/radaraspnet_msas.aspx

their WinForms OLAP viewer control looked decent when I evaluated it a couple months ago.

|||

There's a lot out there to choose from; see

http://www.mosha.com/msolap/util.htm

as a good starting point. What kind of front end are you after?

You should also check out what's coming in the medium term with PerformancePoint, which is based in part on the technology that Microsoft acquired from Proclarity last year. See

http://office.microsoft.com/en-us/performancepoint/FX101680481033.aspx

Regards,

Chris

from sql2005express to sql2000 & vice versa

My asp.net website is using sqlexpress2005. I am planning to use sql2000 with this existing website. My questions:

1. How can I transfer the database definitions and actual data from 2005 to 2000? is this possible?
2. What if I have exisiting database in sql2000, can I convert it to be used in sql2005?
3. should I manually recreate the database when converting from one version of sqlserver to another? and how abt the actual data?

PLS HELP. big thanks!

There are lots of options and lots of caveats...

When a SQL2000 database is attached/touched by a SQL 2005 instance it can not easy be moved back. To go from SQL2000->SQL2005 its as simple as back/restore or detach, move file, attach.

Moving data from one place there are lots of options, DTS is probably the easiest but it is not included in SQL2005 express, but it is included in full SKUs of SQL 2000 and the dev edition of SQL 2005.

Its also possible to use scripting to move meta data definitions, a 2000 script should work really easily with 2005, going back the other way is harder and there will be some enhancements coming in a future service pack of SQL Server 2005 to make the generate script wizard more useful here.

|||thanks for the info man! :)sql

From local to Inet server

Hi..

First of all im a super newb in asp.net and MSSQL.
I had a guy program a website with database, but the guy just stood me up and left me with the files and the server as a file.

Now I need to get them online and working.

The files are FTP on the server so I "just" need the server running

I got the following files:

Justgeek_data.mdf and Justgeek_log.ldf

The server admin interface is:myLittleAdmin.

Any walktrough help or simular would be highly appreciated.

The web is:http://www.bodyplanning.dk

have alook at SQL Server "attach database" process on MSDN

http://msdn2.microsoft.com/en-us/library/ms190794.aspx

|||

Got the database up and running but still errors:

Main page:http://www.bodyplanning.dk/default.aspx

Sub pages:

http://www.bodyplanning.dk/frmLogin.aspx

|||

It is likley that there is a user set up in the database, which also needs to exist at the global level in SQL Server.

Look in Security/Logins in SQL server, then add any users in the database you have attached, and set the passwords.

In the web.config file for the site, ensure that the usernames and passwords match up

From excel file into MS SQL server

I need to find a way to upload an Excel file into an MS SQL database
using a web control front end. I have my ASP.Net control (using C#)
uploading a file to a directory, but the server people now tell me that
I cannot have a writeable area for the web and have a DTS see it as this
is too much of a security risk. So, I need a way to read the file
directly into the database. I've no idea how to do this. Does anyone
have ideas? I know loading MS Office into the web server is out of the
question. The webserver and database server are not the same physical
machine.
Thanks.
Yes you can upload any file directly into SQL Server.
Here's an example:
http://SteveOrr.net/Articles/EasyUploads.aspx
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"no one" <noone@.yahoo.com> wrote in message
news:41FEF4E4.7EED35A4@.yahoo.com...
>I need to find a way to upload an Excel file into an MS SQL database
> using a web control front end. I have my ASP.Net control (using C#)
> uploading a file to a directory, but the server people now tell me that
> I cannot have a writeable area for the web and have a DTS see it as this
> is too much of a security risk. So, I need a way to read the file
> directly into the database. I've no idea how to do this. Does anyone
> have ideas? I know loading MS Office into the web server is out of the
> question. The webserver and database server are not the same physical
> machine.
> Thanks.
>
|||Thanks for the link, but this is not what I want to do. I want to put the
data from the file into a table, not the file itself.
"Steve C. Orr [MVP, MCSD]" wrote:
[vbcol=seagreen]
> Yes you can upload any file directly into SQL Server.
> Here's an example:
> http://SteveOrr.net/Articles/EasyUploads.aspx
> --
> I hope this helps,
> Steve C. Orr, MCSD, MVP
> http://SteveOrr.net
> "no one" <noone@.yahoo.com> wrote in message
> news:41FEF4E4.7EED35A4@.yahoo.com...
|||"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:
>
|||"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:
>
<snip>
Have a look at DTS - it can load directly from Excel (or most other things)
to MSSQL, and you can change the source and destination connections at
runtime. This link discusses executing a package from ASP:
http://www.sqldts.com/default.aspx?207
Otherwise, you can parse the file and generate your own INSERT statements
(slow), or convert it to a flat text file and then use bcp.exe or BULK
INSERT to load the data.
Simon
|||I'm not sure what all security restrictions they want you to
follow, but one option is to use Openrowset and read the
file into a table using T-SQL, e.g.
insert into YourTable
SELECT * FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0; HDR=NO;Database=C:\YourFilet.xls',
'SELECT * FROM [Sheet1$]')
-Sue
On Tue, 01 Feb 2005 12:25:52 GMT, no one <noone@.yahoo.com>
wrote:
[vbcol=seagreen]
>Thanks for the link, but this is not what I want to do. I want to put the
>data from the file into a table, not the file itself.
>"Steve C. Orr [MVP, MCSD]" wrote:
|||Oh, I now see your dilemma. That's fairly complex functionality.
My only idea is this 3rd party product that can open an excel file from a
memory stream and will allow you to extract data from it:
http://www.SteveOrr.net/Reviews/AsposeWord.aspx
http://www.aspose.com/Products/Aspose.Excel/
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:
>

From excel file into MS SQL server

I need to find a way to upload an Excel file into an MS SQL database
using a web control front end. I have my ASP.Net control (using C#)
uploading a file to a directory, but the server people now tell me that
I cannot have a writeable area for the web and have a DTS see it as this
is too much of a security risk. So, I need a way to read the file
directly into the database. I've no idea how to do this. Does anyone
have ideas? I know loading MS Office into the web server is out of the
question. The webserver and database server are not the same physical
machine.

Thanks.Yes you can upload any file directly into SQL Server.
Here's an example:
http://SteveOrr.net/Articles/EasyUploads.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"no one" <noone@.yahoo.com> wrote in message
news:41FEF4E4.7EED35A4@.yahoo.com...
>I need to find a way to upload an Excel file into an MS SQL database
> using a web control front end. I have my ASP.Net control (using C#)
> uploading a file to a directory, but the server people now tell me that
> I cannot have a writeable area for the web and have a DTS see it as this
> is too much of a security risk. So, I need a way to read the file
> directly into the database. I've no idea how to do this. Does anyone
> have ideas? I know loading MS Office into the web server is out of the
> question. The webserver and database server are not the same physical
> machine.
> Thanks.|||Thanks for the link, but this is not what I want to do. I want to put the
data from the file into a table, not the file itself.

"Steve C. Orr [MVP, MCSD]" wrote:

> Yes you can upload any file directly into SQL Server.
> Here's an example:
> http://SteveOrr.net/Articles/EasyUploads.aspx
> --
> I hope this helps,
> Steve C. Orr, MCSD, MVP
> http://SteveOrr.net
> "no one" <noone@.yahoo.com> wrote in message
> news:41FEF4E4.7EED35A4@.yahoo.com...
> >I need to find a way to upload an Excel file into an MS SQL database
> > using a web control front end. I have my ASP.Net control (using C#)
> > uploading a file to a directory, but the server people now tell me that
> > I cannot have a writeable area for the web and have a DTS see it as this
> > is too much of a security risk. So, I need a way to read the file
> > directly into the database. I've no idea how to do this. Does anyone
> > have ideas? I know loading MS Office into the web server is out of the
> > question. The webserver and database server are not the same physical
> > machine.
> > Thanks.|||"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:

<snip
Have a look at DTS - it can load directly from Excel (or most other things)
to MSSQL, and you can change the source and destination connections at
runtime. This link discusses executing a package from ASP:

http://www.sqldts.com/default.aspx?207

Otherwise, you can parse the file and generate your own INSERT statements
(slow), or convert it to a flat text file and then use bcp.exe or BULK
INSERT to load the data.

Simon|||Oh, I now see your dilemma. That's fairly complex functionality.
My only idea is this 3rd party product that can open an excel file from a
memory stream and will allow you to extract data from it:
http://www.SteveOrr.net/Reviews/AsposeWord.aspx
http://www.aspose.com/Products/Aspose.Excel/

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"no one" <noone@.yahoo.com> wrote in message
news:41FF763D.6BFF199A@.yahoo.com...
> Thanks for the link, but this is not what I want to do. I want to put the
> data from the file into a table, not the file itself.
> "Steve C. Orr [MVP, MCSD]" wrote:
>> Yes you can upload any file directly into SQL Server.
>> Here's an example:
>> http://SteveOrr.net/Articles/EasyUploads.aspx
>>
>> --
>> I hope this helps,
>> Steve C. Orr, MCSD, MVP
>> http://SteveOrr.net
>>
>> "no one" <noone@.yahoo.com> wrote in message
>> news:41FEF4E4.7EED35A4@.yahoo.com...
>> >I need to find a way to upload an Excel file into an MS SQL database
>> > using a web control front end. I have my ASP.Net control (using C#)
>> > uploading a file to a directory, but the server people now tell me that
>> > I cannot have a writeable area for the web and have a DTS see it as
>> > this
>> > is too much of a security risk. So, I need a way to read the file
>> > directly into the database. I've no idea how to do this. Does anyone
>> > have ideas? I know loading MS Office into the web server is out of the
>> > question. The webserver and database server are not the same physical
>> > machine.
>>> > Thanks.
>|||DTS has been mentioned.
3rd parties that also do the job: SQLWays , DBUnit.|||"no one" <noone@.yahoo.com> wrote in message
news:41FEF4E4.7EED35A4@.yahoo.com...
>I need to find a way to upload an Excel file into an MS SQL database
> using a web control front end. I have my ASP.Net control (using C#)
> uploading a file to a directory, but the server people now tell me that
> I cannot have a writeable area for the web and have a DTS see it as this
> is too much of a security risk. So, I need a way to read the file
> directly into the database. I've no idea how to do this. Does anyone
> have ideas? I know loading MS Office into the web server is out of the
> question. The webserver and database server are not the same physical
> machine.
> Thanks.

Did you know cross-posting is one of the things some ISPs pick to identify
spam?

This'd be a whole lot easier if your app was windows rather than web.
Coz you don't have any way to be running c# on our client machine.

Is this really an extranet app?
I'd be concerned about who's loading what out a spreadsheet onto my database
server.
It does sound like a good way to open up a hole for hackers to walk in
through.
Uploading excel spreadsheets is also a good way to get a big heap of bad
data into a system.

Anyhow, it piqued my interest so I did a search on "javascript excel"
Here's an interesting page I found.
http://www.planet-source-code.com/v...d=2180&lngWId=2

Some gotchas but maybe they're not a problem for you.

--
Regards,
Andy O'Neill

from asp classic & asp.net to Access database changing to sql server

Hello,
We are re-writing our site in asp.net using sql server. Most of the site uses asp classic and it was to an access database. During the conversion we have everything working correct to SQL Server except for the asp.net connection string. There is an important part of the application using asp.net which works fine with our connection string to the access database. To recap our problem is the connection string from asp.net to sql server.

This code works fine for the asp.net to access in the web.cnfg file
</microsoft.web>
<connectionStrings>
<add name="SalesConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb" providerName="System.Data.OleDb"/>
<add name="ODBCSalesConnectionString" connectionString="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb"/>
<add name="RawConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb" providerName="System.Data.OleDb"/>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\inventoryStatus.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web
The code in the global.asa which works fine for classic asp to sql server also works fine and is as follows

'--Project Data Connection
Application("sales_ConnectionString") = "Driver={SQL Native Client};Server=DMSERVER01;Database=SQLsalesMain;UID=nTrack;PWD=nTrack2k3"
Application("sales_ConnectionTimeout") = 15
Application("sales_CommandTimeout") = 30
Application("sales_CursorLocation") = 3
Application("sales_RuntimeUserName") = ""
Application("sales_RuntimePassword") = ""

Our programmer who set this up is out for a couple of weeks and I would appreciate any help in the correct connection string from asp.net to the sql server database in the web.cnfg file

Thanks

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\inventoryStatus.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>

The above is your problem and your developer not knowing the meaning of User instance because it is for development only database unless you plan to deploy in Express the reason there is no such thing as User instance in full edition SQL Server so read the content of the MSDN link carefully or your code will not run. The text below is from the MSDN link. Hope this helps.

(SQL Server Express Edition allows only a single connection to an .mdf file when you connect with a connection string that has User Instance set to true.)

http://msdn2.microsoft.com/en-us/library/ms228037.aspx
http://www.connectionstrings.com/?carrier=sqlserver2005

|||

<add name="SalesConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb" providerName="System.Data.OleDb"/>

The above is the connection we are talking about.

Thanks...

|||That is not a SQL Server connection string that is the reason I gave you the link to the connection string site. Hope this helps.|||

Thanks,

I know that is not a SQL Server connection string. I was asking for help based on the way the salesMain connection string for SQL in the posted. I have how asp classic connects to SQL, which works fine and was asking how to get it to work with asp.net. I have both connection strings shown in the code in the first post.

Dave

|||

<add name="SalesConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\inetpub\vhosts\themarketingvp.com\subdomains\vp\httpdocs\fpdb\salesMain.mdb" providerName="System.Data.OleDb"/>

<connectionStrings>
<add name="salesMain" connectionString="Server=(local);Integrated Security=True;Database=salesMain;"
providerName="System.Data.SqlClient" />
</connectionStrings>

I have started the correct connection string but you have to add your server name to get it right because you cannot put SQL Server database in inetpub in a network drive because SQL Server decides where the database goes and it is the location below. What I mean is in RDBMS(relational database management systems) the server controls where the database goes. You still have to correct the previous connection string I pointed out to you because again there is no user instance in full SQL Server. You or your developer have to spend time to know connection strings and SQL Server permissions or your application will not run. Hope this helps.

C:\Program Files\Microsoft SQL Server\MSSQL\DATA

http://forums.asp.net/thread/1491403.aspx

freeze header

Hello,
I am using ReportViewer control in my asp.net application. It works fine,
however is it possible to keep header frozen when I scroll-down?
Thanks,
Jim.Not presently - you might be able to solve this by creating two browser
controls one above the other. The first which shows the headers and the
second to show the data. This would be pretty hacky.
We're look at this feature for a future version.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:7B5913F6-72E2-4AC4-97EA-A77AF945F3F9@.microsoft.com...
> Hello,
> I am using ReportViewer control in my asp.net application. It works fine,
> however is it possible to keep header frozen when I scroll-down?
> Thanks,
> Jim.
>

FreeTextTable Search limitations

Hi,
I'm currently writing a search system in ASP with Javascript connected in to
SQL to search a product database. I'm using the FreeTextTable command to
search a number of fields and bring back results in rank order which is
working fine. However when the user submits a word in the noise list or
leaves the search blank and submits SQL returns a nice friendly ODBC
'80040e14' error.
I've read in FAQs and other posts etc to clear the noise filter and just
leave a space but if the user enters a space then hits search we have the
same issue. I'm not happy with that being the resolution and client side
code to correct this would have to cover the blank, space or multiple space
querystring. Instead of this is there not a way in the stored procedure to
throw something else back before returning what ever it does to bring up the
ODBC error? I'm new to stored procedures so not sure if there would be a way
to do this breaking out from a statement if it is yeilding a nasty ODBC
error. If anyone else has any suggestions or examples as to how they use the
FreeTextTable predicate to implement a search system through an ODBC driver
please let me know.
Regards
Nick Scott
MCSE 2003
Do a replace, replacing these illegal characters. Then check to see if the
resulting string is =0 characters, if so exit immediately with a return code
that will be interpreted by the calling application as an invalid search
string.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nick Scott" <scottpin@.xXxhotmailxXx.com> wrote in message
news:uG5pVO1oFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm currently writing a search system in ASP with Javascript connected in
to
> SQL to search a product database. I'm using the FreeTextTable command to
> search a number of fields and bring back results in rank order which is
> working fine. However when the user submits a word in the noise list or
> leaves the search blank and submits SQL returns a nice friendly ODBC
> '80040e14' error.
> I've read in FAQs and other posts etc to clear the noise filter and just
> leave a space but if the user enters a space then hits search we have the
> same issue. I'm not happy with that being the resolution and client side
> code to correct this would have to cover the blank, space or multiple
space
> querystring. Instead of this is there not a way in the stored procedure to
> throw something else back before returning what ever it does to bring up
the
> ODBC error? I'm new to stored procedures so not sure if there would be a
way
> to do this breaking out from a statement if it is yeilding a nasty ODBC
> error. If anyone else has any suggestions or examples as to how they use
the
> FreeTextTable predicate to implement a search system through an ODBC
driver
> please let me know.
> Regards
> Nick Scott
> MCSE 2003
>
|||set a filter to stop certain charactors such as space.
ok?
"Hilary Cotter" <hilary.cotter@.gmail.com> д?
news:%233EnWf1oFHA.3120@.TK2MSFTNGP09.phx.gbl...
> Do a replace, replacing these illegal characters. Then check to see if the
> resulting string is =0 characters, if so exit immediately with a return
> code
> that will be interpreted by the calling application as an invalid search
> string.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Nick Scott" <scottpin@.xXxhotmailxXx.com> wrote in message
> news:uG5pVO1oFHA.3936@.TK2MSFTNGP10.phx.gbl...
> to
> space
> the
> way
> the
> driver
>
|||This would work, as long as the filter would permit these characters when
there was something in addition to them. So the phrase "this is a test"
would pass even though it contains the space characters. Whereas " " would
be filtered out as it only contains the space character.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"zgw" <gwdotnet@.hotmail.com> wrote in message
news:u2KqA8MpFHA.420@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> set a filter to stop certain charactors such as space.
> ok?
> "Hilary Cotter" <hilary.cotter@.gmail.com> д?
> news:%233EnWf1oFHA.3120@.TK2MSFTNGP09.phx.gbl...
the[vbcol=seagreen]
in[vbcol=seagreen]
to[vbcol=seagreen]
just[vbcol=seagreen]
the[vbcol=seagreen]
side[vbcol=seagreen]
up[vbcol=seagreen]
a[vbcol=seagreen]
use
>

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.

Framework Equivalent in MSSQL?

Introduction:
I want to put database based asp.net web site on a windows server.
For the asp.net files there is a free framework that will run the asp.net
files on the server.
The Question:
Is there any free PROGRAM that can run the .mdf and .ldf files on the
server?
And what is the name of that program?
Bishoy George
bishoy@.bishoy.com"Bishoy George" <bishoy@.bishoy.com> wrote in message
news:%23OPKnGAVGHA.5900@.tk2msftngp13.phx.gbl...
> Introduction:
> I want to put database based asp.net web site on a windows server.
> For the asp.net files there is a free framework that will run the asp.net
> files on the server.
> The Question:
> Is there any free PROGRAM that can run the .mdf and .ldf files on the
> server?
> And what is the name of that program?
SQL Server 2005 Express Edtion.
David|||it's name is MSDE (now SQL server express) if you're not planning on
more than a few concurrent connections. Otherwise you have to pay - or
SQL server would be free.|||Are you saying that there's a limit to the number of concurrent users in MSD
E
and SQL Server 2005 Express?
ML
http://milambda.blogspot.com/|||"ML" <ML@.discussions.microsoft.com> wrote in message
news:B8808488-053B-4525-9546-7C67A32A6F22@.microsoft.com...
> Are you saying that there's a limit to the number of concurrent users in
> MSDE
> and SQL Server 2005 Express?
>
There is no user limit in either product, but both products have baked-in
performance limitations.
In MSDE there is a workload throttle that slows down performance beyond 5
concurrent workloads. In SQL Server 2005 Express Edition you can only use 1
CPU and 1 GB of memory.
David|||There's no such limit in either of them. MSDE has a performance throttling f
unctionality which added
a wait for each I/O when you had more than 8 concurrently executing queries.
No such in Express. But
there are limits on db size, number of processors and memory, of course.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ML" <ML@.discussions.microsoft.com> wrote in message
news:B8808488-053B-4525-9546-7C67A32A6F22@.microsoft.com...
> Are you saying that there's a limit to the number of concurrent users in M
SDE
> and SQL Server 2005 Express?
>
> ML
> --
> http://milambda.blogspot.com/|||Yes. Of course there's a limit. Otherwise everyone could just run sql
servers for free. I believe that they've slackened it a bit from the 5
for MSDE, but it's still limited. Last thing I read on it said that as
connections go above 5 MSDE massively throttles the performance of the
SQL server, so it's not an error thrown kind of limit, but your SQL
server becomes rubbish.|||The workload governor is said to be removed in the SQL 2005 Ecpress version.
Not trying to argue, just want clear facts. :)
ML
http://milambda.blogspot.com/|||Ecpress = Express
(in this particular case ;)|||> Yes. Of course there's a limit. Otherwise everyone could just run sql
> servers for free. I believe that they've slackened it a bit from the 5
> for MSDE, but it's still limited.
There is no longer any limitation that has aything to do with the number of
users, number of connections, or number of concurrent queries. The limit is
that Express will only be able to use 1 GB of memory, a single CPU, and the
database size is limited to 4GB. So, if one or more of those criteria do
not meet the requirements of your app, look elsewhere. I imagine there are
pleny of apps out there that could have 1000 concurrent users on Express and
work fine. On the flip side, if I tried real hard, I could design an
application that would completely suck wind with more than 1 concurrent
user, even if deployed to Enterprise edition with 32 GB of RAM. So the
question is more about design and requirements than any artificial
limitation.

> connections go above 5 MSDE massively throttles the performance of the
> SQL server,
[It's actually 8, not 5/]

> so it's not an error thrown kind of limit, but your SQL
> server becomes rubbish.
Have you actually experienced performance throttling THAT BAD on MSDE? Or
is it just hearsay? Granted, I would not personally deploy MSDE or Express
to a production application (because I want to sleep at night), but I have
not been able to reproduce this "rubbish" in some pretty serious testing.
A

Framework Equivalent in MSSQL?

Introduction:
I want to put database based asp.net web site on a windows server.
For the asp.net files there is a free framework that will run the asp.net
files on the server.
The Question:
Is there any free PROGRAM that can run the .mdf and .ldf files on the
server?
And what is the name of that program?
Bishoy George
bishoy@.bishoy.com
SQL Server Express?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Bishoy George" <bishoy@.bishoy.com> wrote in message
news:Od2l9CAVGHA.2444@.TK2MSFTNGP14.phx.gbl...
> Introduction:
> I want to put database based asp.net web site on a windows server.
> For the asp.net files there is a free framework that will run the asp.net
> files on the server.
> The Question:
> Is there any free PROGRAM that can run the .mdf and .ldf files on the
> server?
> And what is the name of that program?
> Bishoy George
> bishoy@.bishoy.com
>