By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,461 Members | 2,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,461 IT Pros & Developers. It's quick & easy.

Microsoft SQL Server Management Studio Express

P: n/a
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

Jan 13 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.