HELP required

I am deleting a database but I am not seeing any entry in server logs or in event viewer. and same thing is happens when I am deatching a database.

Can any body tell me the way through which I can know when a particualr database was deleted or deatched.

Hi derek3060,

Informatin should be logged to master.ldf when you delete one database from your database engine. Likewise, when you detach a database from a server, same information should be logged to the database's ldf file. However, ldf file is designed to be used by sql server system only and we have no way to read/write file(microsoft does not supply such an approach).

As a work around, i would suggest you try sql server profile. You can create a new trace with sql profil, set up some filters, then all the delete database\detach database behavior will be logged (if you do want to log those behaviors)

Hope my suggesiton helps

|||

Yes surely your suggestion has helped.Thanks

Help referencing Report Path in SharePoint Report Viewer

I put in a Report Viewer in one one my webpart buckets. I'm trying to set the properties now. I set the Report manager URL to:

http://myservername/Reports

The problem comes when trying to specify the report path. I'm not sure where this is stored...I just tried taking it from my URL when I ran the report but this doesn't work:

Pages/Report.aspx?ItemPath=%2fa_dashboard%2fa_dashboard

Where exactly is the directory or path I need to poitn to and how do I figure out how it should be formed?

screen shot: http://www.webfound.net/reportpath.jpg

Report Manager URL

http://myserver/reports/

Report Path

/myfolder/myreport

|||I understand this but I tried that. /myfolder/myreport where does this stem from? I tried pasting in the foldername that shows in Report manager for my report (the yellow folder you see) but that's not working.|||You know what, thanks it worked. I was missing the other half..the report name!