Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-28 : 09:49:10
|
| Carina writes "Hi!I´m working as a consultant and have a problem with enterprise manager. (I´m desperate now)I have a stored procedure in my database. It´s no problem to execute the stored procedure IF I execute it from query analyzer. (Rightclick on the stored procedure, open, execute) The stored procedure move the data from one table to an other and then delete the data in the first one)BUT...when I use SQL server agent and schedule the agent toexecute the stored procedure, only a few variables are transferred. What´s the difference and what can I do to force the WHOLE stored procedure to be executed???Thank you very much in advanceRegards//Carina" |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-06-28 : 10:13:13
|
| Can you post the stored procedure so we can look at it. Is there a permissions error? |
 |
|
|
|
|
|
SQL server agent