Hi
We would like in the SQL task, to be able to prevent users from creating SQL statements. So basically, these users can create a SQL task, but only with procedures or jobs, and no direct SQL statements. Because of our setup we must run VC with som fairly powerful rights on the database. Unfortunately we cannot get around this. We don't want users to be able to write DELETE or DROP staments by mistake, and instead force them to use prewritten procs.
Thomas