Here's some code to create a temp table with the values I have in the interval table (M = Months, D = Days in the pay_sched_code column to signify the...

Thanks. Just what I needed! Double genius!!!

As a matter of interest, did you generate the create table and insert statement electronically or did you type it all out? I'm currently trying to log another call and...

That's brilliant! Many thanks for that. Genius!!!

That's great thanks MANU. Will look in there...

Thanks MANU. Think this shows how the tables link together etc although I can't see (correct me if I'm wrong) sysjobhistory or sysjobs strangely enough. It also doesn't show...

Does anyone know of an equivalent page for SQL Server 2005 DBA's please? I can't download that one for 2000 anymore, seems the help page no longer exists.

Thanks Greg. Will look in to that.

Gift Peddie (2/25/2009)

---

There is a SnapshotData table and Subscription table and I found getsnapshot and getsubscription stored procedures. If you spend time with the database you will find all...

We don't have SCOM here, but it sounds like monitoring it that way is quite labour intensive and could get unmanageable with many subscriptions set up if looking at the...

Doesn't that just list jobs that are currently running? A view of the execution results is what I was trying to do in effect, but don't know the meaning of...

Wasn't creating an application really, I was only writing a reporting services report to mail to my support team on a daily basis so that they can add to their...

Sorry, what I meant was what does each field in the tables signify rather than the schema itself. For example, what does ReportAction mean in the ReportSchedule table. Basically a...

I've seen numerous blogs and sites sharing my issue with package size and microsoft have confirmed it (see http://support.microsoft.com/?kbid=952110). My original package got to around 16MB in size...

Anyone got any pointers here for me please?