I don't have script ready to give you..

Read the below topics (links) they will give you an idea what I was suggesting to..

http://forums.asp.net/t/1724525.aspx/1

http://www.datasprings.com/resources/articles-information/creating-email-triggers-in-sql-server-2005

And about the sms application you have, it...

Can't give suggestions without knowing the reason for the failure..

As mentioned by the previous user, post the error description for the restore jobs..

I would recommend you to explore Triggers to send the alerts.

That way you don't have to worry about the source code of that program that is trying to update /...

Yes sadly that is the only option...

lol 🙂

I wrote an article which does a similar task but the email is sent using database mail.

The article is here.. http://www.mssqltips.com/sqlservertip/2347/send-email-in-a-tabular-format-using-sql-server-database-mail/%5B/url%5D

May be it might need customizing as per your need.

Once you open the package to edit it, can you not change the package Protectionlevel to EncryptSensitivewithpassword and give your own password.

I haven't been in this scenario, but trying to...

winston Smith (2/5/2012)

---

Bru Medishetty (2/2/2012)

---

From Books Online, what it says is a full backup contains the data and the rest (logins, stored procs, etc) at the time the backup is...

You are welcome !!!

Add where clause

SELECT srvname

FROM

master.dbo.sysservers

where srvid > 0

I haven't had much trouble with my SQL Servers on Virtual Environment.

Back to Winter Temps..

Well, it is not going to be easy without any knowledge on the tables structure (table description) and what is the criteria to know if an existing record is updated,...

That's it? nothing else is in your query execution plan, well even though it uses Index seek, it might be the least % of the...

Well I think, I understood what is wrong with your code that is causing this format. After each day of the week, you are adding 20 space values and that...