ah hmmm
thanks Rasika. yeh i wanna do this :-) because this is for installation
purposes. it is done by the installation program and not by users, if thats
what you mean by your last point?
is there another easier way of deploying databases?
Thanks
Jason
"Rasika" <ra**********@luckymail.com> wrote in message
news:A6**********************************@microsof t.com...
you can pass the sql string to a stored proc in MSSQL and use the exec
function to execute it. But do you really want to do that. People can drop
tables and play all srot of havoc with your DB?
Rasika