Paul Hunter (7/24/2010)
Two thumbs up. We have an application (FootPrints) that we wont consolidate onto our primary SQL cluster because they insist on using the SA account for their database interaction. I'd thow using the SA account as another very dumb practice.
Is this the same FootPrints that is used for tracking trouble tickets?
The version we have doesn't use the sa password but the user account in use has elevated privileges. We can't change the password for that account on account of it breaking the application. We are in process of migrating away from that application on account of the horrendous security model it uses (as the primary reason).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events