in the report server, browse to your report and then select the subscriptions tab > new subscription ...

Red Gate has a LOT of DB tools, and Dependency Tracker is one of them.

Free for 14 days.

http://www.red-gate.com/products/SQL_Dependency_Tracker/index.htm?utm_source=google&utm_medium=cpc&utm_content=brand_aware&utm_campaign=sqldependencytracker&gclid=CKnulP7Hn6ICFSQ65QodIkl4xw

vba-dev (5/17/2010)

---

I have to believe this question has been asked, and answered, probably many times. But, I can't seem to find the right combination of keywords to find anything useful...

This may not answer your question directly, but may offer an alternative solution if you can't get the answer you need elsewhere....

http://www.sqlservercentral.com/articles/Development/2824/

and the question is.....?

In your ODBC setup/properties, make sure you have the default database set to the correct DB. Sounds like you have it set to be master.

Create a job that runs every 60 minutes that checks the date/time and send your response from there.

select * from personnel

where hiredate >= '20080415'

enclose the date in apostrophes '

😀

It doesn't APPEAR to be in the proc. One of your functions maybe?

itskumar2004 (4/9/2010)

---

I did search the site and found this article but...

Try

HAVING DIRECTORATE_CODE LIKE CASE WHEN @Directorate = 'ALL' THEN DIRECTORATE_CODE ELSE @Directorate END)

Do you have a batch terminator "GO" at the very END of the procedure and function code window?

I recommend that you use the Search feature on this site before you post in the future. 😀

SELECT DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)

Can be found from yesterday's article here --> http://www.sqlservercentral.com/articles/Date+Manipulation/69694/ 😉

Jeff Moden (4/7/2010)

---

Heh... you sure about that ol' friend?

SELECT ISNUMERIC(LEFT('$Howdy',1)),

ISNUMERIC(LEFT(',Howdy',1)),

...

shannonjk (4/7/2010)

---

The '05 Instance has security, however I am not the reporting person I am the DBA, however seeing as our reporting person left 2 weeks ago...I have picked up...