Re: ASP and SQL

Vexander wrote:
My mistake I want to use a view, not a stored procedure.

"Vexander" wrote:

A few questions that might be followed with more. Firstly I want to
run a stored procedure in an SQL server from a asp page. How this.

Is there a way to create a user on an SQL server from a ASP page,
and if there is is there a way to add that user to a group on in the
SQL server.

Thanx

For some reason, I did not see your original post. However, this followup
seems unnecessary because it is not really relevant to your question about
adding users via ADO from ASP.

Do you have SQL Books Online (BOL)? If so, look up the system stored
procedures for managing users. If not, you can download BOL from the
Microsoft web site:
http://www.microsoft.com/downloads/Browse.aspx?displaylang=en&productID=261BA873-F3AB-420E-96D6-E3004596A551

You will need to use an account with sysadmin privileges in order to execute
these procedures from ASP. Just don't fall into the trap of using the sa
acount. Create a new account that has the needed privileges: never use the
sa account in client applications that may be breached.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Connection.Execute and SQL stored procedures
    ... ..asp, the connection object and MS SQL Server as the DB can help me out. ... Five of the six calls execute as expected. ... This particular stored procedure does quite a bit of work within the DB, ...
    (microsoft.public.sqlserver.odbc)
  • Return value from Stored Procedure
    ... I've posted this question on the aspnet NG where I got some useful responses but they've yet solved my problem, then I find this classic asp NG, and hopefully, someone can spot the error right away. ... I inherited some legacy ASP codes in my office. ... The original code's back-end is using the SQL Server 2000 and I am testing to use it on the Express edition. ... Here is the shorten version of the stored procedure code: ...
    (microsoft.public.data.ado)
  • Re: SQL Server problem
    ... > between ASP .NET worker process and the SQL server. ... I could be wrong, but I believe that account is a local account, not a ...
    (microsoft.public.dotnet.languages.vb)
  • RE: SA Account Cant Access Views After Password Change
    ... changed the password for the sa account in the connection string on the ASP ... SQL Server does not cache standard login passwords locally so this cannot ...
    (microsoft.public.sqlserver.clustering)