here's a find and replace for a TEXT field in SQL 2000;

in this example, i'm replacing a relative link with a full link, so it's a good example:

DECLARE @reviewid int,...

you mean like a substring?

declare @sample table(col1 varchar(10),Col2 varchar(30) )

insert into @sample

select '.com' ,'www.whatever.com' union

select '.net','www.whatever.com' union

select '.net','www.whatever.net'

--charindex [string to find], [column or value to find...

in TSQL, it's simply setting the SET FMTONLY ON/OFF setting; it returns the datatable with no rows, so it can them be displayed with whatever the column definitions are;

CREATE PROC...

just be sneaky and rename it twice then...that should fix it:

sp_renamedb [HR_TRACKING ],[HR_TRACKINGTMP]

sp_renamedb [HR_TRACKINGTMP],[HR_TRACKING]

there s a stored proc just for it; you'll get an error if anyone is connected to it when you try to rename.

sp_renamedb [old name with spaces],[newname]

I believe the issue is that the server has not been set up to allow remote connections (what we used to call mixed mode in sql 2000, right?)

i think you...

to add to what Prasad said, you can see the results for yourself. create a temp table, and peak at tempdb: a table unique to your session gets created...it may...

i believe that the results from a stored procedure must go into an existing table; ie:

create table #results(boatid varchar(30) ,otherstuff varchar(30))

insert into #results(boatid)

EXEC [DB0004]..[DB2INST1].[SP_ITM_UPDATE_TIME]

that should work;

if you want to go the cheapie route, the last shareware/free version of PKZip 2.5 was all command line, and works fine as long as the files were under 2...

no it's not trappable, because it's an error raised BEFORE it enters the procedure, because it's a syntax and parameter checking error.

all sql statements are at least evaluated prior to...

it might not be dts.dll, it could be a dependancy that it happens to use.

i went to my server and my sql 2005 express instance on my dev machine, but...

error loading DLL is a typical .NET error. it's pretty much one of 3 things:

1. if you are running this on the server, the DLL is not in the folder,...

just guessing at this point without more information as to what the step was actually doing, but...

could it be the login that is being used has had it's password changed?

or...

you can only do that with dynamic sql.

dynamic sql has some advantages, but you loose the speed advantage of compiled execution plans.

here's the example i always use:

--for users who are...

i can think of two important issues right now, aside from all the others raised.... how could you do a partial recovery? supposed you need to restore a backup from...