December 2009 - Posts

11 December 2009
Does this folder exist?
Today I tripped over a problem that was new to me. I wanted to find out, in SQL, whether a folder existed in the file system. I knew about using xp_fileexist to check for existence of a file but what about a folder? Well, it doesn't work on a folder name and there's no sign of xp_folderexist... Read More...
no comments
Filed under:
01 December 2009
Reporting security audit
Today I set out to produce a list of who has access to each report so I could get this audited by the business management. I didn't think it would take long. Download a couple of scripts, evaluate them, pick a good one, execute it, and on with the next job. After all, this is crucial stuff. There's... Read More...
1 comment(s)
Filed under: , , ,