I have inherited a mess in the SQL Server Report Monitor and the current company that I have recently started.
There are hundreds of reports spread out accross many directories with names like (ad hoc) or (Live), and a number of other non-descript names for the folders within Reporting Manager, also the way the actual rdl's are named is equally confusing making it almost impossible to find a report or figure out what the report is supposed to contain by looking at the name.
Can someone point me to or suggest some directory and file naming standards that I can put into place so that a user could look at a file or directory and tell what it's for and or what it contains?
I'm hoping someone works in an environment that has some pretty good standards in place that I can imulate...
Any help would be appreciated,
Thanks in advance,