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 |
|
RajJol
Starting Member
17 Posts |
 Posted - 2010-12-03 : 09:27:15
|
| Hi,I have a stored procedure that I am trying to get working. I had this working, but yesterday, it just stopped. I have created a job within the 'SQL Server Agent' option which sends out an email on completeion of the task (i.e Success or Fail). The query is very simply and is as follows:Select * from MyTableWhere InsertDate > GETDATE()When i execute the query within SQL management studio all runs fine with no errors, however, once that code has been put into the stored procedure i get the following error message:-Executed as user: NT AUTHORITY\NETWORK SERVICES. Error formatting query, probably invalid parameters [SQLSTATE 42000] [Error 22050]. The step failed.Any help on how i can fix this would be much appreciated. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-04 : 02:15:14
|
| It seems you have rights for a select statement and no rights for execution of a Stored Procedure.PBUH |
 |
|
|
|
|
|
SQL Server Agent Job/Database Mail Error