I have been asked to run a script against a databse in SQL Server 2005.
My clients use a custom Web base application. one of the user accounts has become corrupt and they need to reset the "supervisor" account. The other day I received an email from the web-based application support team to run the following script against one of the databases, named "EvolutionConfig" (the name is not really relevant). I knew how to run scripts in the older SQL Servers but with 2005 I am somewhat lost.
Here is the body of the script:
declare @userid uniqueidentifier
SELECT @userid = (SELECT UserId FROM aspnet_Users WHERE LoweredUserName = 'supervisor')
if @userid IS NULL
begin
PRINT 'Supervisor user record can not be found.'
return
end
DELETE FROM aspnet_Membership WHERE UserId = @userid
DELETE FROM aspnet_Users WHERE UserId = @userid
DELETE FROM aspnet_Profile WHERE UserId = @userid
GO
Can someone give me the instructions on how to run this script agaginst the particular database?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thank you.
I ran the Query and it said Completed with an error:
(1 row(s) affected)
Msg 547, Level 16, State 0, Line 16
The DELETE statement conflicted with the REFERENCE constraint "FK__aspnet_Pr__UserI__6DC
The statement has been terminated.
(1 row(s) affected)
Can you please tell what that means?
run this
declare @userid uniqueidentifier
SELECT @userid = (SELECT UserId FROM aspnet_Users WHERE LoweredUserName = 'supervisor')
if @userid IS NULL
begin
PRINT 'Supervisor user record can not be found.'
return
end
--DELETE FROM aspnet_Membership WHERE UserId = @userid
--DELETE FROM aspnet_Users WHERE UserId = @userid
DELETE FROM aspnet_Profile WHERE UserId = @userid
GO
try this order
declare @userid uniqueidentifier
SELECT @userid = (SELECT UserId FROM aspnet_Users WHERE LoweredUserName = 'supervisor')
if @userid IS NULL
begin
PRINT 'Supervisor user record can not be found.'
return
end
DELETE FROM aspnet_Profile WHERE UserId = @userid
DELETE FROM aspnet_Membership WHERE UserId = @userid
DELETE FROM aspnet_Users WHERE UserId = @userid
GO
if u face the same problem, then provide the schema for above 3 tables
Business Accounts
Answer for Membership
by: selva_konguPosted on 2009-11-05 at 07:20:54ID: 25750385
open the sql server management studio and connect the server in file context menu select new and select the database and run your query