Since you are using SQL 2000 you will probably find this easier.

UPDATE d_description SET RequestId = con.RequestId, FormId = Con.FormId,

DescriptionId = CASE WHEN IdDescription =

(SELECT MIN(IdDescription) FROM d_description d

WHERE...

You could also add a GO after the use statement

:connect MyServer

use MyDB

go

sp_helptext spGetCustomer

go

I'll try to get it written up as an article next week. In the mean time maybe you can answer another quick question. If I am going to...

I've actually been working on the "Double-Hop" problem for over a year now, even with help from someone else who had solved it. And I finally came down to...

Its a full install of SQL Server Standard, including SSIS. Could it be the method we are using to call the package? IE DTEXEC instead of using a...

Well I read the article but I'm not sure I understand it. How do you set a package to run "in process" I've seen in/out of process when...

Ok I'm getting the following errors. Can any of you think another reason why I would be getting these? Other than needing an Enterprise version of SSIS that...

Gift Peddie,

That was actually why I was asking. I want the Enterprise version of SSIS so I can do the Advanced transform but don't want to upgrade the existing...

I'm running SP2CU7 on most of my servers. Anyone have any opinions on what level is best to go to? CU9, 10, 11, SP3 or SP3 CU1? ...

Unfortunatly that just sets the rules for password creation. The password...

RP_DBA,

Thanks for the suggestion but I've tried TRUNCATE_ONLY. Unfortunately the defrag moves the data to the end of the file so TRUNCATE_ONLY doesn't do much.

Gila,

I have around 80gig...

You are missing a ) at the end of the line.

You have your closing paran for the CONVERT but not for the VALUES on the insert. It should look...

That's basically the path I'm taking at the moment. I'm buliding in a "BatchMode" that turns off the interactive part so that we can pass in the variables.

Its used by DBAs only who run it interactivly. It is a set of 2 packages although the interactive part is all in 1 package. It's mostly a...

Unfortunatly same subnet, different IP addresses. Also same TNS files. We copied them from the working server.

Any other suggestions?

Thanks for the help BTW

Kenneth