Assuming you already have Database Mail setup with a default profile in place you could do something like this. Just replace the use of the CTEs I created to bring...

gmaendel (2/8/2013)

---

Hi All,

First time posting to SQLservercentral.

I have a table called DataLogging that looks like the picture attached.

I would like to get only the Data where "StartSwitch" AND "Wet/DrySwitch"...

For stopping ad=nd starting a serving SQL Server Configuration Manager MMC, Windows Services MMC, WMI, PowerShell -Services cmdlets...all of those will work fine. If you're configuring services though, e.g. changing...

I just learned about the possibility in a book I am reading and thought I would pass it along either for you or future readers looking for a way to...

midnight251 (2/8/2013)

---

Our company has never backed up the transaction log file, and is now about 143 gig, with about 35 gig left on the drive, and I have to get...

PiMané (2/8/2013)

---

It's an EqualLogic SAN 🙂

So, in theory, it doesn't really matter if its 4 RAID 10 or just the one big RAID 50 with the 24 disks since the...

PiMané (2/8/2013)

---

Sure, but the implementation will only occur in a...

PS Don't forget to let us know if you get a speed increase from moving to a local path 😉

I know we're in a 2008 forum. I was just saying that "at least...

faisalfarouqi (2/8/2013)

---

I want page reads as well as io reads & writes i.e (logical & physical reads/writes). We actually show these results to our sysadmin guys, as they want usage...

Here is a very useful site.

http://sqlserverbuilds.blogspot.com/%5B/url%5D

I have run into instances where the build was not listed and it was traced back to a hotfix attained directly from Microsoft for a...

I am not sure how it would. I would not take...

The fact that it works for a while and then starts having trouble is the odd part. Everything I am seeing online talks about it never working at all when...

No problem Grasshopper 🙂 Database Mail is available on SQL 2005 but there is a limitation when it comes to setting the from or reply to addresses dynamically. If that...

If you're on SQL 2008 implement Database Mail.