Perhaps it has to do with how you are setting your parameters ?

I found this at the following link

http://social.msdn.microsoft.com/Forums/fi-FI/transactsql/thread/bcd99cba-240d-4f5e-87fe-9780ed50d5e4

The meaning of the error message is that if you say:

EXEC my_sp...

What is @name ?

The query you posted above works for me with the double quotes.

I think you need double quotes around your literals:

FROM sys.dm_exec_requests r WHERE command IN (''RESTORE DATABASE'',''BACKUP DATABASE'')',

Look up sp_send_dbmail. It shows examples of how you can put your query in the @QUERY variable.

"... the ways you says will just send me an email that the job...

Hmmmm ... off the top of my head:

1) Put the query above into a job "Restore status", using sp_send_dbmail to send you the results of the query

2) Schedule it...

Sturev (4/2/2011)

---

I have a need to pull a date column from one table based on the date in another.

Example:

I have a service table that contains details about a service appointment

Then...

There are many ways, but I think more information would be useful. Are your replicated databases A nd B publishers or subscribers ?

Are you wanting to copy a few tables...

On the top menu bar of the maint plan there's an icon for "Reporting & Logging" . Is that what you want ?

does a simple

select * from EMP_VIEW_DB3 work ?

I think if you ask a precise question, you might get a precise answer.

I did a search on the error message and see a variety of causes. Perhaps you could give more details about your environment. What causes have you ruled out ?

Grant Fritchey (3/31/2011)

---

Krasavita (3/31/2011)

---

I am sorry, I didn't right this code and I don't know which statment is causing a problem, I will re write the statment after I find...

Krasavita (3/30/2011)

---

I resolved the problem,but not sure for 100%

I ran update statment 2 hours on that table (I thought update was complited) in the query analyzer and tryed to close...

You could add a datetime column with a default of getdate for future use. That would show you when it was added, but not when it was modified. You'd need...

I use shareware SQLScheduler for Express