object '_hypmv_0_2772' is most likely a foreign key constraint which won't allow the table to be dropped.  Drop the constraint and the table can then be dropped.

I ran into this same problem.  SSRS allows functions in the text box (like Moe's IIF example).  But if you have a large nested IIF function, it can get really ugly. ...

Here's a trimmed down version of my step.  Checks for the file and reschedules the job.  On success it continues with the file load, on failure it branches to reschedule...

I do this by using the FileSystemObject to check for the existance.  If the files are there, I report success for that step and then use DMO commands (oJob, oJobSchedule)...

I have this problem too.  I went back and spent an hour going through every question and they all say I have already answered them.  Yet under Data Warehousing it...

In the Reporting Services books online, under "Configuring a Report Server for E-Mail Delivery", and under "RSReportServer Configuration File Settings", it states:

"The following settings are in the rsreportserver.config configuration...

I got it wrong because I was keying on the phrase: 'format like this "2003-10-12 10:03:39.123"'

Answers 2 and 3 do give in that format although you will never get the...

Supplying the password in sp_change_users_login is new with SP3. I guess to be completely up to date they should have included that.