RAISEERROR statement is not in the stored procedure. I have got the error like this:

Executed as user: xxxcorp\sqladmn. ...X] = 'x' Where Client = '4600' And SequenceNumber = '1020'...

I know 50000 is a user defined Error, but i dont even find anything in sysmessages-table in Master. What is the best way to debug this Job to find the...

Job Failed With Error 50000

how can get more information about the Failed Job with error 50000

Check out this link: http://support.microsoft.com/kb/314546

Forgot to move the Operators first, i got it. once I run the script for Operators, then I ran the script for Jobs. All jobs are copied on the destination...

thanks, gud idea

yes, I see 19 rows on the sql 2000 dest server, but i run the same query on sql 2000 source, it shows 71 rows. so It seems to me...

the servers are not side by side, wht I did was, Selected all jobs(ctrl+A)->Rt.Click on it-> open script. Copied this script and executed on SQl 2000 server, but I can...

Hi Guys, I am trying to migrate all the sql agent jobs from 2000 to 2005, can somebody give me step by step process? thanks in adavance

I tried to move each dts package, rt. click on it-> Open -> Save as storagefile on source server(2000)

On the destination server(2005), rt click on DTS package folder-> Import ->...

can u pls give me step by step to copy the packages from sql 2000 to 2005

Hi I am trying to copy DTS Packages from sql 2000 to 2005? what is the process i can do it?

how to copy DTS packages from one server to another(2000 to 2005)

How do we refresh schema and data in a database? and move to test server to UAT Server?