Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applications but don't do the SQL maintenance but do build db (my dba checks everything and sets all the permissions, etc). Anyway, a nonprofit has asked me to build them a web applicati
on to collect and display information nothing too fancy but lots of data and lot of users.
What are my options? Do I have to buy the server version if I just want to build a database but it is going to be collecting and serving the information from our web host (they've agreed to the extra cost for a web host providing SQL), we aren't keeping
a local version of the records. So I just need SQL to build the db and upload it to our web host. My dba said try access but it only allows 5 concurrent connections. I've heard of MySql or something but since I am somewhat familiar with the basics of
SQL was hoping there was some option for me. They don't need to do analysis or use the info other than to display it on web pages. They estimate they have 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
I appreciate any recommendations or advice you could provide.
Thanks!!
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David
|||Hi David
So if I bought the developer edition I would be legal to build the database and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:

> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> applications but don't do the SQL maintenance but do build db (my dba checks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display information
> nothing too fancy but lots of data and lot of users.
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MySql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or use
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>
|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.

> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/do...s/download.asp
David

Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applications but don't do the SQL maintenance but do build db (my dba checks everything and sets all the permissions, etc). Anyway, a nonprofit has asked me to build them a web application to collect and display information nothing too fancy but lots of data and lot of users.
What are my options? Do I have to buy the server version if I just want to build a database but it is going to be collecting and serving the information from our web host (they've agreed to the extra cost for a web host providing SQL), we aren't keeping a local version of the records. So I just need SQL to build the db and upload it to our web host. My dba said try access but it only allows 5 concurrent connections. I've heard of MySql or something but since I am somewhat familiar with the basics of SQL was hoping there was some option for me. They don't need to do analysis or use the info other than to display it on web pages. They estimate they have 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
I appreciate any recommendations or advice you could provide.
Thanks!!"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David|||Hi David
So if I bought the developer edition I would be legal to build the database and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:
> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> > Hi All
> > At work we use SQL server to host all our databases. I develop web
> applications but don't do the SQL maintenance but do build db (my dba checks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display information
> nothing too fancy but lots of data and lot of users.
> > What are my options? Do I have to buy the server version if I just want
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MySql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or use
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> > I appreciate any recommendations or advice you could provide.
> > Thanks!!
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.
> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/downloads/download.asp
David

Newbie - What do I need

Hi All
At work we use SQL server to host all our databases. I develop web applicat
ions but don't do the SQL maintenance but do build db (my dba checks everyth
ing and sets all the permissions, etc). Anyway, a nonprofit has asked me to
build them a web applicati
on to collect and display information nothing too fancy but lots of data and
lot of users.
What are my options? Do I have to buy the server version if I just want to
build a database but it is going to be collecting and serving the informatio
n from our web host (they've agreed to the extra cost for a web host providi
ng SQL), we aren't keeping
a local version of the records. So I just need SQL to build the db and uplo
ad it to our web host. My dba said try access but it only allows 5 concurr
ent connections. I've heard of mysql or something but since I am somewhat f
amiliar with the basics of
SQL was hoping there was some option for me. They don't need to do analysis
or use the info other than to display it on web pages. They estimate they
have 5,000 - 10,000 users who will enter 10 to 20 records each including pho
tos.
I appreciate any recommendations or advice you could provide.
Thanks!!"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!
MSDE is free and is SQLServer. It comes free with many products including
the free ASP.NET web matrix.
http://www.asp.net/
You can buy a $50 copy of SQL Server developer edition.
http://www.microsoft.com/sql/howtobuy/development.asp
To get a copy of SQL Enterprise Manager and the rest of the tools.
David|||Hi David
So if I bought the developer edition I would be legal to build the database
and upload it to our web hosting server?
I purchased visual studio.net so I don't have matrix. Would you recommend I
go that way using MSDN or the developer edition?
Thanks for the FAST feedback!!
Tracie
"David Browne" wrote:

> "Tracie" <Tracie@.discussions.microsoft.com> wrote in message
> news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> applications but don't do the SQL maintenance but do build db (my dba chec
ks
> everything and sets all the permissions, etc). Anyway, a nonprofit has
> asked me to build them a web application to collect and display informatio
n
> nothing too fancy but lots of data and lot of users.
> to build a database but it is going to be collecting and serving the
> information from our web host (they've agreed to the extra cost for a web
> host providing SQL), we aren't keeping a local version of the records. So
I
> just need SQL to build the db and upload it to our web host. My dba said
> try access but it only allows 5 concurrent connections. I've heard of MyS
ql
> or something but since I am somewhat familiar with the basics of SQL was
> hoping there was some option for me. They don't need to do analysis or us
e
> the info other than to display it on web pages. They estimate they have
> 5,000 - 10,000 users who will enter 10 to 20 records each including photos
.
> MSDE is free and is SQLServer. It comes free with many products including
> the free ASP.NET web matrix.
> http://www.asp.net/
> You can buy a $50 copy of SQL Server developer edition.
> http://www.microsoft.com/sql/howtobuy/development.asp
> To get a copy of SQL Enterprise Manager and the rest of the tools.
> David
>
>|||If your company has SQL, and you have a client license, then you can load
the personal edition (from the company CD) to your desktop dev
environment...
(If it were me, I'd get the non-profit to purchase you the Development
Edition, that you keep, for the $50)... It is a great great price, (just
reduced from $500)..
Have fun!...This may the start of a great new thing for you!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:BAA314D3-FC30-4808-A27F-8C74BAAB6185@.microsoft.com...
> Hi All
> At work we use SQL server to host all our databases. I develop web
applications but don't do the SQL maintenance but do build db (my dba checks
everything and sets all the permissions, etc). Anyway, a nonprofit has
asked me to build them a web application to collect and display information
nothing too fancy but lots of data and lot of users.
> What are my options? Do I have to buy the server version if I just want
to build a database but it is going to be collecting and serving the
information from our web host (they've agreed to the extra cost for a web
host providing SQL), we aren't keeping a local version of the records. So I
just need SQL to build the db and upload it to our web host. My dba said
try access but it only allows 5 concurrent connections. I've heard of MySql
or something but since I am somewhat familiar with the basics of SQL was
hoping there was some option for me. They don't need to do analysis or use
the info other than to display it on web pages. They estimate they have
5,000 - 10,000 users who will enter 10 to 20 records each including photos.
> I appreciate any recommendations or advice you could provide.
> Thanks!!|||"Tracie" <Tracie@.discussions.microsoft.com> wrote in message
news:5EE69FF4-4DFF-4DB0-982B-EF3C5BA28896@.microsoft.com...
> Hi David
> So if I bought the developer edition I would be legal to build the
database and upload it to our web hosting server?
The hosting server must have Sql server or MSDE on it.

> I purchased visual studio.net so I don't have matrix. Would you recommend
I go that way using MSDN or the >developer edition?
MSDE comes with visual studio so you have it. In fact you can just download
it now.
http://www.microsoft.com/sql/msde/d...ds/download.asp
David

newbe question: calling function inside select

Hi!

I have a scalar function that returns integer:
xview (int)

Now, I'm trying to build a procedure that has the following select
inside:

select atr1, xview(atr2)
from tablename

But, I get the 'Invalid name' error when I try to execute that
procedure.

If I got it right, I must use user.fn_name() syntax, but I cannot use
dbo.xview() inside my procedure since it means xview will always be
executed as dbo, which is unaccaptable.

I'm a bit confused, so any hint is very welcomed.

Thanks!

Mario.Mario Pranjic (keeper@.fly.srk.fer.hr) writes:
> I have a scalar function that returns integer:
> xview (int)
> Now, I'm trying to build a procedure that has the following select
> inside:
> select atr1, xview(atr2)
> from tablename
> But, I get the 'Invalid name' error when I try to execute that
> procedure.
> If I got it right, I must use user.fn_name() syntax, but I cannot use
> dbo.xview() inside my procedure since it means xview will always be
> executed as dbo, which is unaccaptable.

But those are the rules. You must refer to a scalar function with a
two-part name.

I don't really see why this is unacceptable. Do you plan to have other
xview functions owned by other users?

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||On Mon, 13 Oct 2003 22:13:03 +0000 (UTC), Erland Sommarskog
<sommar@.algonet.se> wrote:

>But those are the rules. You must refer to a scalar function with a
>two-part name.
>I don't really see why this is unacceptable. Do you plan to have other
>xview functions owned by other users?

Ok, let's put is this way.
I have 'xview' function.

I'm connected to sql server as userX.
Now, when I (as userX) call dbo.xview(), do I execute it as userX or
dbo?

It is vital, because xview() contains code that uses msqql USER sistem
variable, and it should be noted that user userX executed that
function.

Mario.|||Mario Pranjic (keeper@.fly.srk.fer.hr) writes:
> Ok, let's put is this way.
> I have 'xview' function.
> I'm connected to sql server as userX.
> Now, when I (as userX) call dbo.xview(), do I execute it as userX or
> dbo?
> It is vital, because xview() contains code that uses msqql USER sistem
> variable, and it should be noted that user userX executed that
> function.

USER will return userX.

The "dbo." in "dbo.xview()" has nothing to do with impersonation. The
return values of funtions like USER, SYSTEM_USER, suser_snmae() etc
does not change when you call a user-defined function or stored procedure.

The point with calling a stored procedure owned by another user, is
that you can get controlled access to objects that you don't have direct
access to. For instance, in many databases, users does not have direct
access to any tables. Instead they only have access to stored procedures
and user-defined functions that make sure that the users can only access
data they have a right to see, and their updates conforms to the rule
of the database.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||On Tue, 14 Oct 2003 22:00:21 +0000 (UTC), Erland Sommarskog
<sommar@.algonet.se> wrote:

>USER will return userX.
>The "dbo." in "dbo.xview()" has nothing to do with impersonation. The
>return values of funtions like USER, SYSTEM_USER, suser_snmae() etc
>does not change when you call a user-defined function or stored procedure.
>The point with calling a stored procedure owned by another user, is
>that you can get controlled access to objects that you don't have direct
>access to. For instance, in many databases, users does not have direct
>access to any tables. Instead they only have access to stored procedures
>and user-defined functions that make sure that the users can only access
>data they have a right to see, and their updates conforms to the rule
>of the database.

Aha. That is very good. Thank you for the information!

Mario.