Does SQL Express have a Simultaneous Connections Limit?

I have used MSDE in the past & it had a limit on the number of simultaneous
connections per the Microsoft paid support folks. I found various articles
on SQL Express with the limitations but nothing referencing the number of
connections. Has anyone already found this out?"BCW" <nospam@.cfl.rr.com> wrote in message
news:uiyafD9PGHA.2912@.tk2msftngp13.phx.gbl...
>I have used MSDE in the past & it had a limit on the number of
>simultaneous
> connections per the Microsoft paid support folks. I found various
> articles
> on SQL Express with the limitations but nothing referencing the number of
> connections. Has anyone already found this out?
There is no limitation on connections in MSDE or in SQL Express. MSDE was
optimized for a "typical" load of upto 25 users I believe but this wasn't a
hard limit it was just a potential throttle on scalability. AFAIK there is
no such constraint on SQL Express. If you check out the feature comparison
however you'll see that Express supports only a single processor and 1GB
RAM. So those are the limits you have to work within:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Does SQL Express have a Simultaneous Connections Limit?

I have used MSDE in the past & it had a limit on the number of simultaneous
connections per the Microsoft paid support folks. I found various articles
on SQL Express with the limitations but nothing referencing the number of
connections. Has anyone already found this out?
"BCW" <nospam@.cfl.rr.com> wrote in message
news:uiyafD9PGHA.2912@.tk2msftngp13.phx.gbl...
>I have used MSDE in the past & it had a limit on the number of
>simultaneous
> connections per the Microsoft paid support folks. I found various
> articles
> on SQL Express with the limitations but nothing referencing the number of
> connections. Has anyone already found this out?
There is no limitation on connections in MSDE or in SQL Express. MSDE was
optimized for a "typical" load of upto 25 users I believe but this wasn't a
hard limit it was just a potential throttle on scalability. AFAIK there is
no such constraint on SQL Express. If you check out the feature comparison
however you'll see that Express supports only a single processor and 1GB
RAM. So those are the limits you have to work within:
http://www.microsoft.com/sql/prodinf...-features.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

Does SQL Express have a Simultaneous Connections Limit?

I have used MSDE in the past & it had a limit on the number of simultaneous
connections per the Microsoft paid support folks. I found various articles
on SQL Express with the limitations but nothing referencing the number of
connections. Has anyone already found this out?"BCW" <nospam@.cfl.rr.com> wrote in message
news:uiyafD9PGHA.2912@.tk2msftngp13.phx.gbl...
>I have used MSDE in the past & it had a limit on the number of
>simultaneous
> connections per the Microsoft paid support folks. I found various
> articles
> on SQL Express with the limitations but nothing referencing the number of
> connections. Has anyone already found this out?
There is no limitation on connections in MSDE or in SQL Express. MSDE was
optimized for a "typical" load of upto 25 users I believe but this wasn't a
hard limit it was just a potential throttle on scalability. AFAIK there is
no such constraint on SQL Express. If you check out the feature comparison
however you'll see that Express supports only a single processor and 1GB
RAM. So those are the limits you have to work within:
http://www.microsoft.com/sql/prodin...e-features.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

documentation on SQL OLE methods...Where to find?

I've seen a few examples in BOL and various websites where sp_OAMethod is
used to generates scripts, return rows, etc. For example:
SET @.exec_str = 'Databases("'+@.dbname+'").Tables("'+RTRIM(UPPER(@.tbname))+'").Script(74077,"
'+ @.filename +'")'
EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
I can't seem to find any documentation that explains the possible methods
(like databases().Tables().Script).
Can someone point me to where I could find a list of these methods?
Thanks in advancesp_OACreate invokes an extermal program that has a COM OO interface.
The documentation you're looking for will reside with whichever external COM
application you're referring to.
You haevn't given us the name of the particular application you're looking
for in your post, so it's a bit hard to answer this. Your post only gives us
information on a method - perhaps if you go back to whever you got that code
snippet from & give us the part that has "sp_OACreate" in it, we may be able
to help you further.
Regards,
Greg Linwood
SQL Server MVP
"TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
news:#$OwJjrsDHA.1680@.TK2MSFTNGP12.phx.gbl...
> I've seen a few examples in BOL and various websites where sp_OAMethod is
> used to generates scripts, return rows, etc. For example:
> SET @.exec_str =>
'Databases("'+@.dbname+'").Tables("'+RTRIM(UPPER(@.tbname))+'").Script(74077,"
> '+ @.filename +'")'
> EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
> I can't seem to find any documentation that explains the possible methods
> (like databases().Tables().Script).
> Can someone point me to where I could find a list of these methods?
> Thanks in advance
>|||Hi Greg,
Thanks for the reply. Here's the sp_OACreate statement:
EXEC @.hr = sp_OACreate 'SQLDMO.SQLServer', @.object OUT
Thanks,
Tom
"Greg Linwood" <g_linwoodremovethisbeforeemailingme@.hotmail.com> wrote in
message news:uIDLvwrsDHA.2416@.TK2MSFTNGP10.phx.gbl...
> sp_OACreate invokes an extermal program that has a COM OO interface.
> The documentation you're looking for will reside with whichever external
COM
> application you're referring to.
> You haevn't given us the name of the particular application you're looking
> for in your post, so it's a bit hard to answer this. Your post only gives
us
> information on a method - perhaps if you go back to whever you got that
code
> snippet from & give us the part that has "sp_OACreate" in it, we may be
able
> to help you further.
> Regards,
> Greg Linwood
> SQL Server MVP
> "TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
> news:#$OwJjrsDHA.1680@.TK2MSFTNGP12.phx.gbl...
> > I've seen a few examples in BOL and various websites where sp_OAMethod
is
> > used to generates scripts, return rows, etc. For example:
> > SET @.exec_str => >
>
'Databases("'+@.dbname+'").Tables("'+RTRIM(UPPER(@.tbname))+'").Script(74077,"
> > '+ @.filename +'")'
> > EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
> >
> > I can't seem to find any documentation that explains the possible
methods
> > (like databases().Tables().Script).
> >
> > Can someone point me to where I could find a list of these methods?
> >
> > Thanks in advance
> >
> >
>|||Most COM (or Automation) objects come with their own
documentation. For instance, the object hierarchy of SQL-
DMO can be found in SQL Server Books Online. If you need
to interact with an object hierarchy that doesn't seem to
have online/printed documentation, you can try tools such
as OLE-COM Object Viewer that comes with NT Resource kit.
The object viewer allows you browse the object hierarchy
and see all the objects, methods, and proerties.
By the way, if you can stay away from sp_OAxxx stuff, stay
away from it. It's pretty ugly and you can't import the
symbolic constants.
Linchi
>--Original Message--
>I've seen a few examples in BOL and various websites
where sp_OAMethod is
>used to generates scripts, return rows, etc. For example:
>SET @.exec_str =>'Databases("'+@.dbname+'").Tables("'+RTRIM(UPPER(@.tbname))
+'").Script(74077,"
>'+ @.filename +'")'
>EXEC @.hr = sp_OAMethod @.object, @.exec_str, @.return OUT
>I can't seem to find any documentation that explains the
possible methods
>(like databases().Tables().Script).
>Can someone point me to where I could find a list of
these methods?
>Thanks in advance
>
>.
>

Document Storage

Hello Everyone and thanks for your help in advance. I am developing a document storage application for an intranet that will store various Word, Excel, and PDF documents. Most of the examples I see utilize SQL Server and an image field rather than the FileSystem Object to store documents. My concern with this method is that some of the documents may be several hundred pages (not exactly sure of the actual file size yet, but they must be fairly large). My question is, where does the use of SQL Server become impractical for this type of application? Any insight would be greatly appreciated. Thanks.I'm no expert on this but the guy quoted below is :) Image is the right data type for your purpose. You should do some reading on this because there are some considerations about transferring the large amount of data along with storing it.

"In short, should you consider storing images in a database? If you need to frequently edit the images, I suggest storing the images as separate files. If the size of the images are very large (for example, hundreds of megabytes), I suggest storing the images as separate files. If your images are essentially read-only and relatively static, and if you measure the size in kilobytes or a few megabytes, you can consider storing your images in the database."

Programming Microsoft ASP.NET
Chapter 22 - Working with Images in ASP.NET
by Dino Esposito

Joe