Wow, this a blast from the past! Don't think I've ever had a reply to a post as old as 8 years before!

Thanks for the response, but this has long...

• This reply was modified 3 years, 3 months ago by  RossRoss.

Thanks!

Jeff, I was hoping someone would say pretty much exactly what you did, and that I've not missed the boat completely with where my skills lay lol. Thanks for...

Thanks for the interesting post.

Genuine question to someone who uses this method frequently (without trying to sound argumentative):

Do you find this more useful than just highlighting the block and clicking...

Sneaky :Whistling:

Thanks 😀

Don't bother with linked servers.

You can make a full backup with copy only (this ensures it doesn't break your backup chain on the primary server), move the backup file to...

Lowell (3/24/2014)

---

i am sure that everything revolves around sp_send-dbmail; nothing else does the same work via a different name, but certainly jobs and procs could exist, but they all call...

lol no problem 🙂

Don't suppose you know of any other SPs that can send emails without using sp_send_dbmail?

I'm currently checking through xp_cmdshell calls like you suggested earlier, and...

Lowell (3/24/2014)

---

...you cannot change the receipient of an email that was sent to sp_send_dbmail. it's stuck in the service broker asychronously, and processed, and i don't think there is any...

Lowell (3/24/2014)

---

i've done a CLR which sends email, but that assumes you have the ability to install CLR assembleis on your machine; .NET has the built in classes to do...

thava (3/24/2014)

---

If you closely watch the link the store procedure is in msdb did you update it in msdb Database, please don't do that , create a wrapper proc for...

Yes, I'm using my email address, I'm asking if there are any other stored procedures that need to be changed, so that live clients do not get staging emails sent...

Thanks thava, I'd seen that page and it only mentions sp_send_dbmail, so I'm just wondering if there are any other procedures that can send email too? Anything not mentioned...

Thanks TheJrDBA, that's a very useful solution.

I tried something else which seems to work on my dev server to actually remove the jobs from any reports that show...

Hi Perry, thanks for the reply ...

Detach / Attach would require downtime which we don't want, the production version is a large...

webrunner (9/11/2013)

---

The correct answer given the original question is 0 rows. Noticing that by reviewing the code in your head is not cheating. Copying and pasting the code and running...