Find Jobs
Hire Freelancers

Write a TSQL stored procedure

$30-250 USD

Pågår
Lagt ut over 6 år siden

$30-250 USD

Betalt ved levering
Need to centrally change SQL Login passwords for a number of sql servers. The spreadsheet explains what is required. Scenario is that we have a central sql server with database dba_db which contains a table with SQL servernames and connection details. I want you to write a sproc to run through (RUNID=1) each row and pick out the servename, connect to it using sqlcmd and populate the other table called tbl_SQLLogonPWDs. Please create the following sprocs: 1. usp_GetHashCurrentPWDs - use the ([sp_dba_help_revlogin] in the dba_db) to get the hash of the logins and put in field [CurrentPWD] of tbl_SQLLogonPWDs table. Also populate the column [SQLQuery to Backout to OLDPWD] with this hash. Next someone will manually put in NewPWD in the newly created rows (by this sproc) of the table. Once we have the NewPWD values in the rows we use the next sproc to apply the new pwds. 2. usp_ApplyNewPWDs - Dynamic sqlcmd query to each server from tbl_SQLLogonPWDs and run ALTER LOGIN statement for each [Login] with NewPWD Store the statement run in the column [SQLQuery to Backout to OLDPWD], apply it to the server or login (if input parameter =apply), and update RUNID and the daterun. 3. usp_BackoutPWDs - "Dynamic sqlcmd query to each server from tbl_SQLServers and run script in field [SQLQuery to Backout to OLDPWD] " 4. tbl_SQLServerServiceAccounts Dynamic sqlcmd query to each server from tbl_SQLServers and populate the Service account fields 5. usp_TestPWD - Create a Stored Procedure to Test passwords for Logins Please quote asap. Thanks Aasim
Prosjekt-ID: 15344784

Om prosjektet

3 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber

Om klienten

UNITED KINGDOMs flagg
London, United Kingdom
5,0
32
Medlem siden jul. 15, 2005

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.