Garbage clean up inside the function:

create function fn_reverse (@strin varchar(4000))

returns varchar(4000)

as

begin

 declare @return varchar(4000)

 declare @ascii smallint, @numeric bit, @space smallint, @start smallint, @garbage varchar(30)

 declare @i smallint, @j-2 smallint

 select @i...

check article PSS ID Number: 152806

A temp table to hold ER, ER2, OK and join with searching table would be much easier.

I would prefer to cut them before calling the function for two reasons.

1. the list can be changing.

2. outside the reverse logic.

You may want to use REPLACE (or combine with...

Rename will not work after the first day. It can not be renamed to an existing table.

Method of backup table depends on amount of data and tracking design.

insert, bcp out/in...

BOL article "Expanding Hierarchies" may help.

Are you talking

set noexec on

or

set parseonly on

You can use the function directly in query.

SELECT     TAGNAME, dbo.fn_reverse(TAGDESC), EUDESC

FROM         tbtxt

Not sure about the second one?

create function fn_reverse (@strin varchar(4000))

returns varchar(4000)

as

begin

 declare @return varchar(4000)

 declare @ascii smallint, @numeric bit, @space smallint, @start smallint

 declare @i smallint, @j-2 smallint

 select @i = 1, @start = 1

 while @i...

Profiler is an option.

GroupHierarchies table can hold your company structure.

Script it and then apply to SQL7.

Log shipping is live, or call hot standby. The standby server can be accessed although it is in read only mode. It is whole database level.

Snapshot replication is for one...

crdate and schema_ver in sysobjects table may help you.

One way of doing:

alter table add

update the new column with identity column

alter table drop