I got the same error here for not able to support below SP 3, but once sql server is install, just put sp3a and the hot fix and it works...

If the login already exist on the new server, you could do:

EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary'

at the current database, and your user will start appearing one by one.

mom

It is expected, and normal, that 'dbo' user is orphaned.

Try: sp_changedbowner 'sa'

and then do sp_changedbowner 'domain\useraccount'  --the real owner.

If the owner's login does not exist on the new server, you...

I though there is also a KB on this issue as well, at least my co-worker told me to dig for it.

I was in the same shoe last week and...

If that is the case don't select the part number.  If you only select customer, date, order number, total you will only get 2 records.

mom

I am wondering what if you left off that @set_user option?  does your stuff work?

in sql 7.0 master here is how it is defined:

create procedure sp_processmail --- 1996/06/19 17:30

 @subject varchar(255)=NULL,

 @filetype...

One more things to do:

Log into the sql server using the sql service account that the sql server is running from.

Open outlook and see if you can send sample email...

here is what I mean:

declare @a int, @b-2 int

set @a=0

set @b-2 = select count(*) from tablename

while @a <= @b-2

update table where key >= @a

and key < @a+ 1000

set @a =...

I don't think it would be that bad at all.  Because the way sql 7.0 works, you can just backup your 7.0 databases and restore it to your sql 2000...

Put your update statement in a loop, update only those that fit the criteria, increment your criteria, loop, and then update again. 

mom

Have you though of the old fashion bcp.  It's been a while since I do 6.5 to 2000, but I am sure that's what I did.  sql 6.5 use syslogins,...

I wonder what happen if you send email from outlook? 

I certainly never have seen this type of problem from sql-mail before.

mom

I am having the same problem.  Has anybody found out why yet? 

mom

I took my baby to the court to show up for the jury duty and imedietly dismissed  If I'm gonna work for someone for...

I wonder why I am being taken to the suggestion forum everytime?  I am serious.  Usually it takes me SQLServerCentral.com main forum.  but for the last 2 days this is...