On the latest SQL 6.5 with the latest SQL 6.5 service pack, what's the
trick to creating an account besides sa that has the power to create
databases? I was thinking of calling this account 'sa2'. Why do this?
Well, my boss asked me to do it because of a SOX audit + SAS-70 audit
kind of thing.
I tried using the GUI to do it, but then when using the GUI as sa2, I
find the "Create Database" has been greyed out.
I have a funny feeling that the only way to get this is to hack the
sys* tables, which is a little risky.
Oh, and trust me, if I had the political weight in my company to get
off SQL 6.5, I would, but I don't. And mgmt already knows that SQL 6.5
is past support timeframe and is a ticking timebomb.