August 22, 2002 at 11:42 am
HI. I'm new at installing sql security patches. I put one on last night and after i ran the SECURITYHOTFIX.sql, the output said that the "configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install"
I've never run this statement before. Can i run this during the day when people are on the server or is this something done when no one is logged on? Also, does it hurt that i applied the patch last night and I didn't run this statement yet?
August 22, 2002 at 1:56 pm
Yes you can run it live. Not running it just means the changes are available yet. Sometimes its reconfigure, sometimes reconfigure with override.
Andy
August 22, 2002 at 2:26 pm
Andy,
Thank you so much for the info. I would assume if OVERRIDE is supposed to be used, the output would have stated that.When I run this in query analyzer, do I specify a database to run under?
August 22, 2002 at 5:13 pm
Normally if you run reconfigure and its not enough, it will tell you to run with override. Strange but true. Run from any db, doesnt matter, affects system settings.
Andy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply