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

Word Update

P: n/a
Hi all,

I'm trying to figure out if it's possible to simply replace instances
of a given string of text wherever it occurs in all tables and columns
for a given database. I'm using SQL Server 2000 sp3.

All the update/replace commands I've looked at so far seem to require
up-front knowledge of the schema. What I need is something that
wouldn't treat the database as structured. For example, it would be
idealif SQL Server could dump out the database in an XML format (since
we don't have a lot of data and lots of disk space I'm not too worried
about space/performance issues), which I could then run sed or
something similar to do the replacement and re-import the XML back in.

That would be ideal, but so far I haven't seen anything that would let
me do that. Am I barking up the wrong tree here? Is there a simpler
way?

thanks,

--dan

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Take a look at this:
http://vyaskn.tripod.com/sql_server_...nd_replace.htm

--
David Portas
SQL Server MVP
--
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.