I found the problem, because I didn't set the right default database for that user. my default database is master. But I have three databases to manupilate , How can...
I met the same problem 'Can not find dtored procedure...', this problem occurs when only 'EXEC [stored procedure]' , but SQL can find the stored procedure when execute the following...
I met the same problem too, when I ran the DTS package which loads many data into the database. some time the DTS hungs forever, and the job is in 'executing'...