My knowledgee of SQL7 is limited. Is there a command I
can run in Query Analyzer that will find and replace a
line of text in all fields of all tables in the entire
database?
Here's my dilemna: I migrated my Remedy Database to a new
server with a different server name. Now I need to
replace all the instances in the database where is says
old server name and change it to the new server name. I
have more than 300 tables in the database, so i don't
want to run the command 300 times. Anyone have any ideas?
Re: Sharepoint Database falling over event 1000 ... Microsoft Small Business Server Support... > I Have Just run the SQL command from the command Line, ... > affected)1> exitDoes this say the database is Ok?If so why since we loaded ... > I/O operation has been aborted because ofeither a thread exit or an ... (microsoft.public.windows.server.sbs)
Re: NTDS ISAM DataBase Corruption ... Error on - ESENTUTL /g ... Wizard to force demotion in Windows Server 2003 and in Windows 2000 Server ... as it may not be the database that is the problem. ... Open a command prompt and run NTDSUTIL to verify the paths for the ... (microsoft.public.windows.server.active_directory)
Re: Exchange 2000 Event 704 Information Store 1760 ... Dismount each store on this server.... Open a command prompt,... Select the first database on the list, ...Offline defrag will require a disk space location that can accommodate 110% ... (microsoft.public.exchange2000.information.store)
Re: Missing table ... >Using Query Analyzer... >switch to the appropriate database... deleted the data within the table and changed the owner.... >> I have a SQL 7.0 server holding our Agency's most ... (microsoft.public.sqlserver.server)
Re: SELECT MAX(...) performance in SQL Server/ODBC ... Well Query Analyzer uses the ODBC driver to send the command to the server, ... Have you tried using SQL Profiler to profile the events on the server?... > I work on a commercial software product that is a database application. ... (microsoft.public.data.odbc)
