Gus,

I'd be interested in Alias DVD's. Used to watch it semi-faithfully, but missed many because I also played basketball that night. Season's 1 and 2 were the only...

Hey,...

I'm a little jealous. My wife isn't a big movie fan so we don't go, and I don't have NetFlix because it's just not the same if your wife...

I think this might help you:

http://msdn.microsoft.com/en-us/library/ms189075(SQL.90).aspx

Merge Join only accepts 2 inputs. Have you looked at the UNION ALL Transformation?

Here's all BOL has to say:

The DataSources collection represents the data sources referenced in a published report definition. You may get different values for these properties in preview mode than...

I have always hated meetings. Mainly because I have rarely been in a meeting where there was someone actually leading the meeting. The person calling the meeting should...

Have you tried sending using google/yahoo/hotmail as the smtp server?

Let me preface this by saying that I have not yet attended PASS, will be this fall, but I have attended other conferences that have a similar format.

For the PASS...

I definitely agree with Steve that you should post your choice. Especially why you chose that route.

I've never seen that before, could it be an AV rule? What's the account you are sending too? Maybe their mailbox is full. Have you tried sending...

I've never tried to get a count of the pages a group has repeated before, so I don't know if there is a way to do it. I can't...

Do you have anti-virus software running on the SQL Server? I know for a fact that McAfee blocks database mail unless you add an exception to the "Prevent Mass...

Hey no problem. I'd probably do the same thing if I was running everything in SSMS 2005. This exercise is quite a bit more difficult in 2000 than...

I'd make one change to Matt's script.

I'd put something like this in the WHERE clause to avoid touching rows that you are not going to update:

UPDATE #temp

SET ...