I am running into a similar problem and have been wrangling with it all day. I have inherited numerous databases that look like they were created to have a 1GB...

Well, I never did get this to work under SQL 7 on any machine or server. Same results no matter what I tried.

So, I installed a trial version of SQL...

No answers yet. Just more frustration. I have whittled the trace file (which is a SQL Server table) down to just over 2000 rows with only the EventClass and Text...

Wasn't specifically holding off on SP4 for any reason. That server is hosted so I'll take a look at having that patch installed. In the meantime the exact message is:...

Thanks. What I have done so far is run it on my machine which has 512 MB of memory and received the error. I then terminal served into the server...

Thanks for the reply. I am running SQL 7, SP 3. I have searched everywhere and can't find any info on this. Maybe I am just searching on the wrong...

No one has run into a problem like this?

I was afraid of that. And sp_helpfile gives me the same logical names as selecting from sysfiles.

Ok, since I can't change this, is there a way to avoid it in...

Shoot, is NEWNAME specific to SQL Server 2000? Am getting a syntax error on SQL 7.

Ooooh, I see. Duh, I knew about the command but was afraid it would interfere with a database with the same logical name. *Smacks self on head..Alter DATABASE..* Thanks for...

You could also try SQLDiff by Lockwood tech (www.lockwoodtech.com). I have been playing with this and looks like a pretty nice tool.

Did you ever get this resolved? I had this exact same problem between 2 linked sql servers and was never able to get it to work. I use SET XACT_ABORT...

Ok, one last question...how do I know which DTS designer I am using? I can find versions anywhere. What happened was I had installed the trial version of SQL Server...

Aaaahhhh, missed the dot. Thanks for the link again.

And I think you are absolutely correct. I logged onto the server itself and created the same package with a different name...

Thanks for the quick reply. The link seems to be incorrect. Microsoft site says that page is unavailable. If you have another link I would certainly appreciate it.

One of my...