As vikas bindra pointed out, it is xp_Sendmail. I would recommend you look up the procedure in books online. It requires you configure a MAPI profile on the...

Ok, here is a few screen prints of the behavior I think you want.

The control flow has three data flow components. I have a variable "MyVar".

Task 1 will always...

Yes.

Read the licensing information on the MSDN website.

Make sure you license it correctly. You need to buy the appropriate MSSQL Server licenses for BOTH servers.

My font is bigger than your font

Sorry - that was unnecessary, but can we tone down the fonts.

I'd post a thoughtful response, but I'm heading out for a Guinness.

The error is telling you that the datatype of ["Column"] is incorrect. The REPLACE functions needs this to be a string and your column is an integer. You...

If I am following you correctly, you want to run reporting services an one server and have the ReportingServices and ReportingServicesTempDB databases on another server.

This is pretty easy, actually. ...

I stopped at one in NH a few years (possibly like 7) back that had a drive through window. I was on my way to Maine - which explains...

All I know is they have drive through liquor stores.

Lynn Pettis (1/7/2009)

Grant Fritchey (1/7/2009)

I guess you can't argue with that. The worst part is that so many of them have moved North to NH and corrupted a perfectly...

Just add a WHERE to your dsv and full-process the cube.

What do you mean restrict it? You could use security to prevent users from accessing the dimension members for older years. You could filter data out of the...

Mass could be may fault.

I own a place in Vermont, so I drive through Mass a lot.

Plus, the states are pretty small out here.

I lived in Parker for a few years, so apparently, it's not my fault. Or Colorado was so nice, it was completely immune to my ability to increasing the...