Ad-hoc reporting

We have a web application using SQL Server 2000, and we'd like to add ad-hoc
reporting. Here are the options we thought of so far:
1. Use SQL Server 2000 Reporting Services - but we're not sure how "ad-hoc"
we can get using SSRS. Has anyone tried?
2. Use a 3rd party reporting software package. Does anyone know of any?
3. Build a custom .NET ad-hoc app that is fine tuned for this application.
This is likely the most costly.
The goal is to have the users build and save report templates, and the be
able to select any combination of fields in the relational schema to include
in the reports, and select on any fields as well.
Does anyone have any other suggestions?
Thank you!!My suggestion is to investigate Report Builder which comes with RS 2005. It
is an ad hoc reporting solution that came out with RS 2005. This is
non-trivial to create on your own and from a cost perspective you will be
better off paying for the upgrade. Plus RS 2005 is much faster for Excel and
PDF output, has multi-select parameters, end user sorting and date picker.
Note that as long as you pay the license you can upgrade just RS and leave
your database at 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:uUTBa8qrHHA.5028@.TK2MSFTNGP05.phx.gbl...
> We have a web application using SQL Server 2000, and we'd like to add
> ad-hoc
> reporting. Here are the options we thought of so far:
> 1. Use SQL Server 2000 Reporting Services - but we're not sure how
> "ad-hoc"
> we can get using SSRS. Has anyone tried?
> 2. Use a 3rd party reporting software package. Does anyone know of any?
> 3. Build a custom .NET ad-hoc app that is fine tuned for this application.
> This is likely the most costly.
> The goal is to have the users build and save report templates, and the be
> able to select any combination of fields in the relational schema to
> include
> in the reports, and select on any fields as well.
> Does anyone have any other suggestions?
> Thank you!!
>

Ad-hoc reporting

Is the ad-hoc reporting available for SQL Server 2005 reporting
services a web based environment or is it an application that has to be
installed?
Thanks
Robertits a clickonce application.
this required that the user have the .Net Framework 2.0 installed locally.
then the reportbuilder application is downloaded automatically without any
install process.
but its not a webbased application. its a client/server application which
use webservices calls to the server to execute andrender queries.
"rhoenig" <rhoenig@.charter.net> wrote in message
news:1158956048.392781.78140@.m7g2000cwm.googlegroups.com...
> Is the ad-hoc reporting available for SQL Server 2005 reporting
> services a web based environment or is it an application that has to be
> installed?
> Thanks
> Robert
>

Adhoc Query Tool for Sql Server

Hi !!
We are developing an application where we need a Query tool which allows customer to do Ad-Hoc or random query.. something similar to lets sayhttp://salebyowner.com/advancedSearch.php
We have few more options than this on which customer can do search.
I don't think dynamic query in C# code or something like that is going to help me. Am I right? Do we have to use any type of query tool or something for doing this?Hi love_luv,
Your example link shows a reasonably sophisticated query form written in PHP. But that doesn't mean PHP is a better database query tool than C# (or any other language for that matter).
PHP is just an application layer over top of some database. That database requires a completely different query language known as SQL (that has no direct link to PHP, C# or any other language).
The programmer in your example is simply using PHP to dyanmically costruct a SQL query statement (in text form) and passing it to their database to retrieve a result. C# (i.e., ASP.NET) can do that too.
In fact, with C# you can utilizeparameterized SQL queries for cleaner and safer SQL construction and execution.
The real trick behind sophisticated queries, of the type you're hoping to achieve, is a good familiarity with the SQL language (of the type native to your database brand,e.g., MS SQL Server uses a form of SQL known as Transact-SQL (a.k.a. TSql), and the knowledge to transform the user input from a webpage into said SQL.
Hope that helps.|||know, I understand that, its sophisticated query. I thought do we need to get some tool like Cognos etc etc for doing such query? More than parameterized query, I think its Dynamic or Adhoc query.|||You don't "need" a query tool at all, if you are familiar with SQL - regardless of how complex a query is. Visual Studio also query tools built in.

A special query tool or not, sophisticated or simple requirements - it all still comes down to a SQL statement to get your database results.
I found query tools useful once-upon-a-time for learning SQL, but I generally don't use them in my day-to-day programming now. You might find a tool useful to get an example of what your SQL text should look like, but once you have that then you use a language like C# to dynamically build the SQL text.
As an aside, "nearly" all database queries are dynamic (or adhoc) in nature. And using a parameterized query is just an optional format to make your dynamic (i.e., adhoc) queries easier to build (and safer to execute).
Hope that helps.|||So mean to say such a complex query is Dynamic Query written in C# code?
We really don't need any Commercial Query tool for Client end? We can use Web Forms to generate such query?
In couple of projects we implemented complex dynamic query, and that made us think if we need any tool or what? In our dynamic query, most of the time (99%) Select clause returns fix number of columns however, From Clause has base table and based on Where Conditions it may or may not join with other tables in data base.
In our version of dynamic query we builded WHERE clause in C#.
But how can we implement Join and WHERE using some proper structure.
Thanks|||

How one can handle dynamic SQL which has to perform JOIN with other tables.

Example I showed in my first post say has 2 - 3 tables:

PropertyListings and PropertyFeatures, PropertyLotFeatures

PropertyListings table gives me basic information I need to display.
PropertyFeatures and PropertyLotFeatures has information I need for advance search. I don't know which table to use and Join till user selects some features. based on Features selected for advance search I may have to Join:
1) PropertyListings with PropertyFeatures
2) PropertyListings with PropertyLotFeatures
3) PropertyListings with propertyFeatures and PropertyLotFeatures
I know once can right such query in C#, but is that how they do it or there is a better way? Am I missing something?

|||

Let me give an Example :

How about when there is Join Present. How whould you build Dynamic SQL? Do you need Dynamic SQL or there is a Better Way?
For Eg.
Table1 = Customers
Table2 = Interests
Table3 = Customers_Interests
Table4 = Activities
Table5 = Customers_Activities
Table3 holds Customers Interests.
Table5 holds Customers Activities
Lets say Customers Table has Data: C1, C2, C3, C4
Interests Table has Data: I1, I2, I3, I4
Cusomters_Interests has Data:
C1, I1
C1, I3
C1, I4
C2, I2
C2, I4
C3, I3
Activities Table has Data: A1, A2, A3, A4
Customers_Activities has Data:
C1, A1
C1, A4
C2, A3
C4, A1
Now lets say on my webpage I represent Interests and Activities as CheckBoxes.
Case 1:
I select Interests I1, I3, I4 but No Activities Selected. In this case my query has to join Customers, Interests and Customers_Interests Table
So query will be: Give me list of Customers with Interests I1, I3, I4
Case 2:
If I select Activities A1, A3 and No Interests, query whas to join Customers, Activities and Customers_Activities Table
Case 2:
If I select Interests I1 and Activities A1, in this case Query has to join Customers, Interests, Customers_Interests, Activities and Customers_Activities tables(all tables)
How would you write Query?
Looking for help!!!!!!!!!!!!!!!!!!!!!!!!!!!

addning roles to a user

being used to how Oracle works with users and roles I am confused as to how I
can create an application role and then give it to a user such as dbo. Can
anyone point me in the right direction?
Thanks,
Steve
An application role is built at the database level., Not server level. is
built in the same way as a database user. Doesn't need to be attached to a
login account. This kind of role only have access to that database. Is
commonly used to allow programmers to add it to applications when they don't
want the authentication of the user.
"Steven.Dahlin" wrote:

> being used to how Oracle works with users and roles I am confused as to how I
> can create an application role and then give it to a user such as dbo. Can
> anyone point me in the right direction?
> Thanks,
> Steve
|||Let me explain what I need. The app will have some people who can be admins
for the application. I wanted to test for the role to see if they were an
"admin". Those who had the role could access the admin functions, those who
did not would find the admin menu option greyed out. How could I accomplish
this?
Thanks,
Steve
|||Database roles define the security at the database level. Perhaps you can
match those application admin functions with database permissions and do
something like this:
Create your database roles
Give permissions to the roles
Add users to your roles
In your application use is_member to validate role membership and decide if
the admin functions will be enabled or disabled
Hope this helps,
Ben Nevarez, MCDBA, OCP
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:688B48A7-BC6F-47FF-AA66-3184D432C21D@.microsoft.com...
> Let me explain what I need. The app will have some people who can be
> admins
> for the application. I wanted to test for the role to see if they were an
> "admin". Those who had the role could access the admin functions, those
> who
> did not would find the admin menu option greyed out. How could I
> accomplish
> this?
> Thanks,
> Steve
|||I created a "standard" role called "TestRole". Then I went to the list of
users and selected "dbo". I tried adding "TestRole" but I received a message
"Error 15405: Cannot use the reserved user or role name 'dbo'". I have
looked thru various sources to try to understand this but nothing really
straightforward explains what the problem is.
Steve
|||Hi Steve
I didn't realize your other post was part of this bigger thread.
But my response still holds. The point of an app role is to give someone
temporarily more privileges than they usually have, and since the user dbo
has full privileges in a db, it is not a good one to test with.
Please look again at Ben's suggestions and if you don't have any other users
than dbo, you'll have to create a user with NO privileges, then set the app
role, then check to see that users enhanced permissions.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:8B5B3ADA-F6AF-44FA-9DAC-940C5930A682@.microsoft.com...
>I created a "standard" role called "TestRole". Then I went to the list of
> users and selected "dbo". I tried adding "TestRole" but I received a
> message
> "Error 15405: Cannot use the reserved user or role name 'dbo'". I have
> looked thru various sources to try to understand this but nothing really
> straightforward explains what the problem is.
> Steve
>

addning roles to a user

being used to how Oracle works with users and roles I am confused as to how
I
can create an application role and then give it to a user such as dbo. Can
anyone point me in the right direction?
Thanks,
SteveAn application role is built at the database level., Not server level. is
built in the same way as a database user. Doesn't need to be attached to a
login account. This kind of role only have access to that database. Is
commonly used to allow programmers to add it to applications when they don't
want the authentication of the user.
"Steven.Dahlin" wrote:

> being used to how Oracle works with users and roles I am confused as to ho
w I
> can create an application role and then give it to a user such as dbo. Ca
n
> anyone point me in the right direction?
> Thanks,
> Steve|||Let me explain what I need. The app will have some people who can be admins
for the application. I wanted to test for the role to see if they were an
"admin". Those who had the role could access the admin functions, those who
did not would find the admin menu option greyed out. How could I accomplish
this?
Thanks,
Steve|||Database roles define the security at the database level. Perhaps you can
match those application admin functions with database permissions and do
something like this:
Create your database roles
Give permissions to the roles
Add users to your roles
In your application use is_member to validate role membership and decide if
the admin functions will be enabled or disabled
Hope this helps,
Ben Nevarez, MCDBA, OCP
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:688B48A7-BC6F-47FF-AA66-3184D432C21D@.microsoft.com...
> Let me explain what I need. The app will have some people who can be
> admins
> for the application. I wanted to test for the role to see if they were an
> "admin". Those who had the role could access the admin functions, those
> who
> did not would find the admin menu option greyed out. How could I
> accomplish
> this?
> Thanks,
> Steve|||I created a "standard" role called "TestRole". Then I went to the list of
users and selected "dbo". I tried adding "TestRole" but I received a messag
e
"Error 15405: Cannot use the reserved user or role name 'dbo'". I have
looked thru various sources to try to understand this but nothing really
straightforward explains what the problem is.
Steve|||Hi Steve
I didn't realize your other post was part of this bigger thread.
But my response still holds. The point of an app role is to give someone
temporarily more privileges than they usually have, and since the user dbo
has full privileges in a db, it is not a good one to test with.
Please look again at Ben's suggestions and if you don't have any other users
than dbo, you'll have to create a user with NO privileges, then set the app
role, then check to see that users enhanced permissions.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:8B5B3ADA-F6AF-44FA-9DAC-940C5930A682@.microsoft.com...
>I created a "standard" role called "TestRole". Then I went to the list of
> users and selected "dbo". I tried adding "TestRole" but I received a
> message
> "Error 15405: Cannot use the reserved user or role name 'dbo'". I have
> looked thru various sources to try to understand this but nothing really
> straightforward explains what the problem is.
> Steve
>

addning roles to a user

being used to how Oracle works with users and roles I am confused as to how I
can create an application role and then give it to a user such as dbo. Can
anyone point me in the right direction?
Thanks,
SteveAn application role is built at the database level., Not server level. is
built in the same way as a database user. Doesn't need to be attached to a
login account. This kind of role only have access to that database. Is
commonly used to allow programmers to add it to applications when they don't
want the authentication of the user.
"Steven.Dahlin" wrote:
> being used to how Oracle works with users and roles I am confused as to how I
> can create an application role and then give it to a user such as dbo. Can
> anyone point me in the right direction?
> Thanks,
> Steve|||Let me explain what I need. The app will have some people who can be admins
for the application. I wanted to test for the role to see if they were an
"admin". Those who had the role could access the admin functions, those who
did not would find the admin menu option greyed out. How could I accomplish
this?
Thanks,
Steve|||Database roles define the security at the database level. Perhaps you can
match those application admin functions with database permissions and do
something like this:
Create your database roles
Give permissions to the roles
Add users to your roles
In your application use is_member to validate role membership and decide if
the admin functions will be enabled or disabled
Hope this helps,
Ben Nevarez, MCDBA, OCP
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:688B48A7-BC6F-47FF-AA66-3184D432C21D@.microsoft.com...
> Let me explain what I need. The app will have some people who can be
> admins
> for the application. I wanted to test for the role to see if they were an
> "admin". Those who had the role could access the admin functions, those
> who
> did not would find the admin menu option greyed out. How could I
> accomplish
> this?
> Thanks,
> Steve|||I created a "standard" role called "TestRole". Then I went to the list of
users and selected "dbo". I tried adding "TestRole" but I received a message
"Error 15405: Cannot use the reserved user or role name 'dbo'". I have
looked thru various sources to try to understand this but nothing really
straightforward explains what the problem is.
Steve|||Hi Steve
I didn't realize your other post was part of this bigger thread.
But my response still holds. The point of an app role is to give someone
temporarily more privileges than they usually have, and since the user dbo
has full privileges in a db, it is not a good one to test with.
Please look again at Ben's suggestions and if you don't have any other users
than dbo, you'll have to create a user with NO privileges, then set the app
role, then check to see that users enhanced permissions.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steven.Dahlin" <StevenDahlin@.discussions.microsoft.com> wrote in message
news:8B5B3ADA-F6AF-44FA-9DAC-940C5930A682@.microsoft.com...
>I created a "standard" role called "TestRole". Then I went to the list of
> users and selected "dbo". I tried adding "TestRole" but I received a
> message
> "Error 15405: Cannot use the reserved user or role name 'dbo'". I have
> looked thru various sources to try to understand this but nothing really
> straightforward explains what the problem is.
> Steve
>sql

addlogin & grantdbaccess for a user

We are developing an application and we need to create a
user called "Application" which must be capable to create
new logins and grant permissions to they, so it must be
capable to run sp_addlogin and sp_grantdbaccess stored
procedures.
Can anyone help us?
Thanks.You can add the login to predefined server and database roles in order to
manage security:
--add security admin login
EXEC sp_addlogin 'Application', 'ApplicationPassword'
EXEC sp_addsrvrolemember 'Application', 'securityadmin'
GO
--grant security admin login database access
EXEC sp_adduser 'Application'
EXEC sp_addrolemember 'db_accessadmin', 'Application'
EXEC sp_addrolemember 'db_securityadmin', 'Application'
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter" <pedrojpz@.terra.es> wrote in message
news:015401c3c757$fd83eeb0$a601280a@.phx.gbl...

quote:

---

> We are developing an application and we need to create a
> user called "Application" which must be capable to create
> new logins and grant permissions to they, so it must be
> capable to run sp_addlogin and sp_grantdbaccess stored
> procedures.
> Can anyone help us?
> Thanks.

---

Adding Users SqlServer2000

More of a SQL Server problem than a ASP one but hope you can help me :)

Im tryin to do my first data based application using ASP.net and silly me I forgot to add users when I created then database so now Visual Studio can't access it.

Can someone tell me the syntax to add/create a user to MSSQL database so I can then grant them privelidges to the tables.

thanks very much

Tomif you go to enterprise manager, xpand on databases then yourdatabase, theres a tab called users. there you cann add/modify users permissions.

hth

Adding subscibers periodically.

Hi,

In my application, i am sending mails to the respective approvers who have to approve the pending requests allocated to them.

Currently,i am adding the subscriber using the sql statement : select distinct users from requestapprover.

For every user i am adding the subscriber device info and subscription data.

So, this way it will send mails to only those approvers (subscribers) whose ids are stored. How do I add new subscribers? because this statement will run only once.

Is there a way to add subscribers periodically or a way to run the AddSubscriber.cs periodically, so that the new subscriber can be added.

Currently, only those subscriber which are added at the first are added.

Is this approach good , if not , please suggest one.

Thanks in advance,

Hi navbhan -

>>For every user i am adding the subscriber device info and subscription data.

That sounds right. Each approver would become a subscriber. The device would tell SQLNS how to notify that approver. And the subscription indicates what the approver is interested in. Since you're automatically adding subscribers, you'll want to check to make sure they are not already in the system first.

>>So, this way it will send mails to only those approvers (subscribers) whose ids are stored.

This is where the match rule comes in to play. Rather than sending notifications to all subscribers, the match rule merges the subscription data with the event data and creates notifications.

>>How do I add new subscribers?

I've blogged about creating subscribers in v2.0 and 2005.

http://sqlns.blogspot.com/2006/08/creating-test-subscriptions-in-sqlns.html

http://sqlns.blogspot.com/2005/10/creating-subscribers-in-2005.html

http://sqlns.blogspot.com/2005/09/creating-subscribers-in-v20.html

HTH...

Joe

Adding subscibers periodically.

Hi,

In my application, i am sending mails to the respective approvers who have to approve the pending requests allocated to them.

Currently,i am adding the subscriber using the sql statement : select distinct users from requestapprover.

For every user i am adding the subscriber device info and subscription data.

So, this way it will send mails to only those approvers (subscribers) whose ids are stored. How do I add new subscribers? because this statement will run only once.

Is there a way to add subscribers periodically or a way to run the AddSubscriber.cs periodically, so that the new subscriber can be added.

Currently, only those subscriber which are added at the first are added.

Is this approach good , if not , please suggest one.

Thanks in advance,

Hi navbhan -

>>For every user i am adding the subscriber device info and subscription data.

That sounds right. Each approver would become a subscriber. The device would tell SQLNS how to notify that approver. And the subscription indicates what the approver is interested in. Since you're automatically adding subscribers, you'll want to check to make sure they are not already in the system first.

>>So, this way it will send mails to only those approvers (subscribers) whose ids are stored.

This is where the match rule comes in to play. Rather than sending notifications to all subscribers, the match rule merges the subscription data with the event data and creates notifications.

>>How do I add new subscribers?

I've blogged about creating subscribers in v2.0 and 2005.

http://sqlns.blogspot.com/2006/08/creating-test-subscriptions-in-sqlns.html

http://sqlns.blogspot.com/2005/10/creating-subscribers-in-2005.html

http://sqlns.blogspot.com/2005/09/creating-subscribers-in-v20.html

HTH...

Joe

Adding SSMSE 2005 as a Prerequisite to a Visual Studio Setup Project

Hi,

I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.

I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)

There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.

Has anyone does this for SSMSE? Or am I going about this in the wrong way?

Thanks in advance,

Keith

Hi Keith,

You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.

One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.

Mike

|||

Thanks Mike! I am deploying it with SQL Express as well.

Take care,

Keith

Adding SSMSE 2005 as a Prerequisite to a Visual Studio Setup Project

Hi,

I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.

I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)

There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.

Has anyone does this for SSMSE? Or am I going about this in the wrong way?

Thanks in advance,

Keith

Hi Keith,

You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.

One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.

Mike

|||

Thanks Mike! I am deploying it with SQL Express as well.

Take care,

Keith

Adding SSMSE 2005 as a Prerequisite to a Visual Studio Setup Project

Hi,

I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.

I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)

There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.

Has anyone does this for SSMSE? Or am I going about this in the wrong way?

Thanks in advance,

Keith

Hi Keith,

You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.

One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.

Mike

|||

Thanks Mike! I am deploying it with SQL Express as well.

Take care,

Keith

adding sqlexpress sp1/2 into setup project

Hi All,

How can I add sql server express sp1 or sp2 into a setup project I created for an application. Normally sqlserver express is a prerequisite for my app and in deployment vs only adds sqlexpress not the sqlexpress with sp1 or sp2. I know that I need those to make my application run on vista. Any suggestion?

Thanks

The prerequisites in VS are driven by a set of manifests installed with VS that only target SQL Express RTM. Microsoft has not released updates to these prerequisites, but you can build your own prerequisite for SQL Express SP2 by following the directions in the SQL Express blog. Check out the instructions here.

Mike

|||After a long wait I knew that you will reply. I haven't tried your instructions yet but I am sure this is the answer. Thanks for the reply.

adding sqlexpress sp1/2 into setup project

Hi All,

How can I add sql server express sp1 or sp2 into a setup project I created for an application. Normally sqlserver express is a prerequisite for my app and in deployment vs only adds sqlexpress not the sqlexpress with sp1 or sp2. I know that I need those to make my application run on vista. Any suggestion?

Thanks

The prerequisites in VS are driven by a set of manifests installed with VS that only target SQL Express RTM. Microsoft has not released updates to these prerequisites, but you can build your own prerequisite for SQL Express SP2 by following the directions in the SQL Express blog. Check out the instructions here.

Mike

|||After a long wait I knew that you will reply. I haven't tried your instructions yet but I am sure this is the answer. Thanks for the reply.

Adding photos to SQL table

Hello all I am new to this site.
I am trying to use ASP.NET to build an application but I am not surehow to add photos and other data to the sql table that I have created.

Thanks in advance.If you are using SQL 2005 I would store the image as BINARY(MAX) or if 2000 us IMAGE for the field type. However, you would need to write some sort of handler to read the SQL table and write the image to a stream, an HttpHandler might work best for that. As for storing the image, you would need to convert the image into a byte array (byte[] or byte()).|||

You can take a look at this post:

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

adding new users

SQL 2005 Express;
Win XP/2003
Our app defines an Admin for the application.
He has a database login.
An Admin can add users, which then get created on
the server and added to the database.
This appears to require that he have sysadmin.
We don't want them to be able to log directly into
the database with sysadmin priviledges.
We thought about using Application roles, but we
are reluctant to hardcode the password in the
application, thus having the same password across
installations.
Any other ideas on how to let then create users on the
server without the Admin having sysadmin?
--
Thanks,
Brad.Look at the fixed server and database roles. See 'Roles' in Books Online.
For example:
The securityadmin role can add Logins -but cannot provide any access or perm
issions. That is left up to the appropriate database role.
Could that serve your purpose?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Brad White" <bwhite at inebraska . com> wrote in message news:%23CL1EQq$GHA.4328@.TK2MSFTNGP
03.phx.gbl...
> SQL 2005 Express;
> Win XP/2003
>
> Our app defines an Admin for the application.
> He has a database login.
>
> An Admin can add users, which then get created on
> the server and added to the database.
> This appears to require that he have sysadmin.
>
> We don't want them to be able to log directly into
> the database with sysadmin priviledges.
>
> We thought about using Application roles, but we
> are reluctant to hardcode the password in the
> application, thus having the same password across
> installations.
>
> Any other ideas on how to let then create users on the
> server without the Admin having sysadmin?
> --
> Thanks,
> Brad.
>
>|||Look at the fixed server and database roles. See 'Roles' in Books Online.
For example:
The securityadmin role can add Logins -but cannot provide any access or perm
issions. That is left up to the appropriate database role.
Could that serve your purpose?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Brad White" <bwhite at inebraska . com> wrote in message news:%23CL1EQq$GHA.4328@.TK2MSFTNGP
03.phx.gbl...
> SQL 2005 Express;
> Win XP/2003
>
> Our app defines an Admin for the application.
> He has a database login.
>
> An Admin can add users, which then get created on
> the server and added to the database.
> This appears to require that he have sysadmin.
>
> We don't want them to be able to log directly into
> the database with sysadmin priviledges.
>
> We thought about using Application roles, but we
> are reluctant to hardcode the password in the
> application, thus having the same password across
> installations.
>
> Any other ideas on how to let then create users on the
> server without the Admin having sysadmin?
> --
> Thanks,
> Brad.
>
>|||Looks promising. I'll check it out.
Thanks,
Brad.
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23i5oJYr$GHA.4740@.TK2MSFTNGP03.phx.gbl...
> Look at the fixed server and database roles. See 'Roles' in Books Online.
> For example:
> The securityadmin role can add Logins -but cannot provide any access or
> permissions. That is left up to the
> appropriate database role.
> Could that serve your purpose?
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
"Brad White" <bwhite at inebraska . com> wrote in message
news:%23CL1EQq$GHA.4328@.TK2MSFTNGP03.phx.gbl...
> SQL 2005 Express;
> Win XP/2003
> Our app defines an Admin for the application.
> He has a database login.
> An Admin can add users, which then get created on
> the server and added to the database.
> This appears to require that he have sysadmin.
> We don't want them to be able to log directly into
> the database with sysadmin priviledges.
> We thought about using Application roles, but we
> are reluctant to hardcode the password in the
> application, thus having the same password across
> installations.
> Any other ideas on how to let then create users on the
> server without the Admin having sysadmin?
> --
> Thanks,
> Brad.
>|||In initial tests, it looks like that does the trick.
--
Thanks,
Brad.
"Arnie Rowland" <arnie@.1568.com> wrote in message news:%23i5oJYr$GHA.4740@.TK
2MSFTNGP03.phx.gbl...
Look at the fixed server and database roles. See 'Roles' in Books Online.
For example:
The securityadmin role can add Logins -but cannot provide any access or perm
issions. That is left up to the appropriate database role.
Could that serve your purpose?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Brad White" <bwhite at inebraska . com> wrote in message news:%23CL1EQq$GHA.4328@.TK2MSFTNGP
03.phx.gbl...
> SQL 2005 Express;
> Win XP/2003
>
> Our app defines an Admin for the application.
> He has a database login.
>
> An Admin can add users, which then get created on
> the server and added to the database.
> This appears to require that he have sysadmin.
>
> We don't want them to be able to log directly into
> the database with sysadmin priviledges.
>
> We thought about using Application roles, but we
> are reluctant to hardcode the password in the
> application, thus having the same password across
> installations.
>
> Any other ideas on how to let then create users on the
> server without the Admin having sysadmin?
> --
> Thanks,
> Brad.
>
>|||We have a database user that has SecurityAdmin on the
server and on the database.
It can add users to the Server, but
a) can't run sp_adduser: not enough permissions to run SPs.
b) can't add the user to the DB directly:
Create user 'username' for login 'loginname'
No permissions to add user to the DB.
Tried giving this user permission to exec the SP, and
that failed as well.
Making this user an owner of the DB, obviously solves
the problem, but we'd really rather not. 8:-)
What other minimum server roles or db roles can we add
to get this?
--
Thanks,
Brad.
"Brad White" <bwhite at inebraska . com> wrote in message news:OlwDcbt$GHA.4
992@.TK2MSFTNGP03.phx.gbl...
In initial tests, it looks like that does the trick.
--
Thanks,
Brad.
"Arnie Rowland" <arnie@.1568.com> wrote in message news:%23i5oJYr$GHA.4740@.TK
2MSFTNGP03.phx.gbl...
Look at the fixed server and database roles. See 'Roles' in Books Online.
For example:
The securityadmin role can add Logins -but cannot provide any access or perm
issions. That is left up to the appropriate database role.
Could that serve your purpose?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Brad White" <bwhite at inebraska . com> wrote in message news:%23CL1EQq$GHA.4328@.TK2MSFTNGP
03.phx.gbl...
> SQL 2005 Express;
> Win XP/2003
>
> Our app defines an Admin for the application.
> He has a database login.
>
> An Admin can add users, which then get created on
> the server and added to the database.
> This appears to require that he have sysadmin.
>
> We don't want them to be able to log directly into
> the database with sysadmin priviledges.
>
> We thought about using Application roles, but we
> are reluctant to hardcode the password in the
> application, thus having the same password across
> installations.
>
> Any other ideas on how to let then create users on the
> server without the Admin having sysadmin?
> --
> Thanks,
> Brad.
>
>|||As I indicated earlier, the securityadmin role can add logins -but cannot gi
ve permissions to the databases, or to the objects in the databases. I sugge
sted that you check in Books Online about the use of the fixed server roles
and the fixed database roles.
It sounds like you need both a server fixed role AND a database fixed role.
When you finally check in Books Online, check out the capabilities of the db
_accessadmin and the db_securityadmin database roles.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Brad White" <bwhite at inebraska . com> wrote in message news:%237KjVe2$GHA
.1196@.TK2MSFTNGP02.phx.gbl...
We have a database user that has SecurityAdmin on the
server and on the database.
It can add users to the Server, but
a) can't run sp_adduser: not enough permissions to run SPs.
b) can't add the user to the DB directly:
Create user 'username' for login 'loginname'
No permissions to add user to the DB.
Tried giving this user permission to exec the SP, and
that failed as well.
Making this user an owner of the DB, obviously solves
the problem, but we'd really rather not. 8:-)
What other minimum server roles or db roles can we add
to get this?
--
Thanks,
Brad.
"Brad White" <bwhite at inebraska . com> wrote in message news:OlwDcbt$GHA.4
992@.TK2MSFTNGP03.phx.gbl...
In initial tests, it looks like that does the trick.
--
Thanks,
Brad.
"Arnie Rowland" <arnie@.1568.com> wrote in message news:%23i5oJYr$GHA.4740@.TK
2MSFTNGP03.phx.gbl...
Look at the fixed server and database roles. See 'Roles' in Books Online.
For example:
The securityadmin role can add Logins -but cannot provide any access or perm
issions. That is left up to the appropriate database role.
Could that serve your purpose?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Brad White" <bwhite at inebraska . com> wrote in message news:%23CL1EQq$GHA.4328@.TK2MSFTNGP
03.phx.gbl...
> SQL 2005 Express;
> Win XP/2003
>
> Our app defines an Admin for the application.
> He has a database login.
>
> An Admin can add users, which then get created on
> the server and added to the database.
> This appears to require that he have sysadmin.
>
> We don't want them to be able to log directly into
> the database with sysadmin priviledges.
>
> We thought about using Application roles, but we
> are reluctant to hardcode the password in the
> application, thus having the same password across
> installations.
>
> Any other ideas on how to let then create users on the
> server without the Admin having sysadmin?
> --
> Thanks,
> Brad.
>
>

Adding New Languages

I have a SQL Server 2000 application that must return raiserrors in multiple
languages. One of the languages is not in the list of supported languages
in master..syslanguages.
In SQL 6.5, there was a procedure sp_addlanguage that could be used to add
unsupported languages. This procedure is no longer available in SQL 2000.
The upgrade documentation suggests removing all references to sp_addlanguage
... as if to suggest that adding languages to SQL 2000 is not supported and
should not be done.
I could add the language directly to syslanguages (it works, I've tried it).
My question is: Is there actually a risk in adding a new language to
syslanguages? Are there any factors that I should be aware of?
Thanks,
BB
There may not be problem for the time being, but the structure of system
tables may change between versions of SQL Server, and selecting directly
from system tables is discouraged.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "bbofloma" <bbofloma@.online.nospam>
>Subject: Adding New Languages
>Date: Mon, 4 Apr 2005 15:55:03 -0400
>Lines: 20
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
>Message-ID: <e7$DLDVOFHA.3848@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: d150-29-198.home.cgocable.net 24.150.29.198
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP14.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:51233
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I have a SQL Server 2000 application that must return raiserrors in
multiple
>languages. One of the languages is not in the list of supported languages
>in master..syslanguages.
>In SQL 6.5, there was a procedure sp_addlanguage that could be used to add
>unsupported languages. This procedure is no longer available in SQL 2000.
>The upgrade documentation suggests removing all references to
sp_addlanguage
>... as if to suggest that adding languages to SQL 2000 is not supported and
>should not be done.
>I could add the language directly to syslanguages (it works, I've tried
it).
>My question is: Is there actually a risk in adding a new language to
>syslanguages? Are there any factors that I should be aware of?
>Thanks,
>BB
>
>

Adding New Languages

I have a SQL Server 2000 application that must return raiserrors in multiple
languages. One of the languages is not in the list of supported languages
in master..syslanguages.
In SQL 6.5, there was a procedure sp_addlanguage that could be used to add
unsupported languages. This procedure is no longer available in SQL 2000.
The upgrade documentation suggests removing all references to sp_addlanguage
... as if to suggest that adding languages to SQL 2000 is not supported and
should not be done.
I could add the language directly to syslanguages (it works, I've tried it).
My question is: Is there actually a risk in adding a new language to
syslanguages? Are there any factors that I should be aware of?
Thanks,
BBThere may not be problem for the time being, but the structure of system
tables may change between versions of SQL Server, and selecting directly
from system tables is discouraged.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "bbofloma" <bbofloma@.online.nospam>
>Subject: Adding New Languages
>Date: Mon, 4 Apr 2005 15:55:03 -0400
>Lines: 20
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
>Message-ID: <e7$DLDVOFHA.3848@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: d150-29-198.home.cgocable.net 24.150.29.198
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:51233
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I have a SQL Server 2000 application that must return raiserrors in
multiple
>languages. One of the languages is not in the list of supported languages
>in master..syslanguages.
>In SQL 6.5, there was a procedure sp_addlanguage that could be used to add
>unsupported languages. This procedure is no longer available in SQL 2000.
>The upgrade documentation suggests removing all references to
sp_addlanguage
>... as if to suggest that adding languages to SQL 2000 is not supported and
>should not be done.
>I could add the language directly to syslanguages (it works, I've tried
it).
>My question is: Is there actually a risk in adding a new language to
>syslanguages? Are there any factors that I should be aware of?
>Thanks,
>BB
>
>

Adding New Languages

I have a SQL Server 2000 application that must return raiserrors in multiple
languages. One of the languages is not in the list of supported languages
in master..syslanguages.
In SQL 6.5, there was a procedure sp_addlanguage that could be used to add
unsupported languages. This procedure is no longer available in SQL 2000.
The upgrade documentation suggests removing all references to sp_addlanguage
... as if to suggest that adding languages to SQL 2000 is not supported and
should not be done.
I could add the language directly to syslanguages (it works, I've tried it).
My question is: Is there actually a risk in adding a new language to
syslanguages? Are there any factors that I should be aware of?
Thanks,
BBThere may not be problem for the time being, but the structure of system
tables may change between versions of SQL Server, and selecting directly
from system tables is discouraged.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "bbofloma" <bbofloma@.online.nospam>
>Subject: Adding New Languages
>Date: Mon, 4 Apr 2005 15:55:03 -0400
>Lines: 20
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
>Message-ID: <e7$DLDVOFHA.3848@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: d150-29-198.home.cgocable.net 24.150.29.198
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:51233
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I have a SQL Server 2000 application that must return raiserrors in
multiple
>languages. One of the languages is not in the list of supported languages
>in master..syslanguages.
>In SQL 6.5, there was a procedure sp_addlanguage that could be used to add
>unsupported languages. This procedure is no longer available in SQL 2000.
>The upgrade documentation suggests removing all references to
sp_addlanguage
>... as if to suggest that adding languages to SQL 2000 is not supported and
>should not be done.
>I could add the language directly to syslanguages (it works, I've tried
it).
>My question is: Is there actually a risk in adding a new language to
>syslanguages? Are there any factors that I should be aware of?
>Thanks,
>BB
>
>