On the server?

SQL Server is 64 bit, office 2010 32 bit...

From what i recall of the issue, there were couple hundred that needed deleted.

I appreciate your help and your comments.

Thank,

Mike

Anyone know how to find a one timed subscription?

I think i figure it out.

Delete

FROM ReportServer.dbo.Subscriptions

FROM ReportServer.dbo.Subscriptions S

INNER JOIN ReportServer.dbo.Catalog C

ON S.Report_OID = C.ItemID

INNER JOIN ReportServer.dbo.Users U

ON S.OwnerID = U.UserID

WHERE path like '/XXXXXX/%' and CreationDate <'10/01/2013'

If someone...

I replaced the select with a delete, it is not working.

delete

C.Name

,C.Path

,U.UserName

,S.InactiveFlags

,C.CreationDate

FROM ReportServer.dbo.Subscriptions S

INNER JOIN ReportServer.dbo.Catalog C

ON S.Report_OID = C.ItemID

INNER JOIN ReportServer.dbo.Users U

ON S.OwnerID = U.UserID

WHERE path...

One more when you have a chance.

mikejone_99@yahoo.com

Thanks!

Who wrote your Joke?

John Kerry