When I work with MS-SQL Server in Access I keep MSSMSE open at the same
time. I use it to do all my work on the SQL database. It has many
strengths.
One is a search and replace feature in T-SQL. Decide you don't need those
[Active] boolean fields? You've removed them and now want to purge your SQL
strings of them? Script all your SQL (first to a file for safety) as Alter
to a another File (or new Query Window if it's not a whole lot), do the
search and remove the phrases that refere to the Active Fields. Run the
revised SQL. Presto you're done. With a whole bunch of Tables and Sprocs
and using the Access interface this could take a very long time, and result
in many syntax errors, and quite possibly, you could miss some of the
"Active" references.
Microsoft SQL Server Management Studio Express is a free download. I like
it.
--
lyle fairfield
