PDA

View Full Version : Best way to install a MS SQL db?



NewsArchive
10-12-2009, 01:51 AM
Got an app using MS SQL server. At the moment I'm installing a couple of
scripts on the machine which is then being processed by OSQL.

However whilst OSQL is processing these scripts its possible for someone to
copy them and then know everything about the db before I delete them again.

So anyway to run these sql scripts where prying eyes can not copy or gain
access to the scripts?

TIA

--
--
Cheers
Richard

NewsArchive
10-12-2009, 01:51 AM
"Security through obscurity" is justly mocked.

That said, if you include the scripts as "support files", SB will unpack
them into a temporary folder that it creates on-the-fly.
The folder will be inside the user's Temp folder, and its own folder name
will be a GUID. (See sample in pic)

Someone who knows what he's looking for might find the script file, but it's
slightly obscure.

Jane

NewsArchive
10-13-2009, 01:27 AM
Hi Jane

Good point and theres no reason why the script file doesnt have to have a
different file extension making that also a little more obscured, maybe even
giving it a .exe extension. Will have to see if the OSQL will take a script
file with a .exe.<g>

--
--
Cheers
Richard