sp_password

Article View: borland.public.intrabuilder.data.sql

Article #3

Back to borland.public.intrabuilder.data.sql Previous Next

From: Josh Moss
Date: Fri, 25 Jul 1997 00:00

12 lines
940 bytes

I am trying to provide users with the ability to change their SQL Server
passwords.  It is done on SQL Server using the sp_password system stored
procedure.  I was unsure how to use the StoredProc control because when I
added it to the form, it would only show the stored procedures that were
local to the database and not system stored procedures.  So I tried using a
query object and setting the sql property to "sp_password
oldpassword,newpassword", and that didn't work.  Does anyone have any ideas
how to get this to work?

Josh Moss
Stephens Inc.

Technical Details

Message-ID: <01bc993e$47b68fa0$7ec26ecc@moss2650.stephens.cpm>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,733a35d3adab6c4d,start
X-Google-Attributes: gid101d9a,public
From: "Josh Moss" <jmoss@stephens.com>
Subject: sp_password
Date: 1997/07/25
Message-ID: <01bc993e$47b68fa0$7ec26ecc@moss2650.stephens.cpm>
X-Deja-AN: 258935338
Organization: Stephens Inc.
Newsgroups: borland.public.intrabuilder.data.sql