sticky wrote:
I just started on writing a stored procedure to use to delete reports - and it occurred to me that you most likely have one already, as the previous version of Report Builder included the option to delete reports. If so, would you be able to share it with us?.
The sql was coded in the application.
Something like
"delete from tsysreportsoftware where homepagequery = @viewname"
"delete from tsysreportserver where homepagequery = @viewname"
"delete from Tsysreporthomepage where homepagequery = @viewname"
"delete from tsysreporthardware where homepagequery = @viewname"
"delete from tsysreportgeneral where homepagequery = @viewname"
"delete from tsysreports where reportquery = @viewname"