The prior DBA did make that suggestion, but the manager wanted the files left in place and since it is a development box anyway he chose not to go to...

Agreed, and that is exactly my point. There is no reason to tell off a manager because he wanted detached files left in a active db directory on a development...

I've worked for incompetent managers in the past as well and they usually end doing themselves in. They don't need my help. However, tellling off a manager or advising someone...

Jeff,

Although I totally agree with your premise on the way to properly do things, that was not the current situation being faced. This was the situation at hand and a...

The problem states that the manager did not want the files moved to another directory and the prior DBA honored that. However, I would have done the same as you...

GSquared,

The problem is not to identify Files in use,it is to provide a QUICK list of ALL detached database files ONLY in a directory. MS Process Explorer does not give...

Lynn,

Unfortunately after testing, your solution does not find DETACHED files in a directory I supplied. Old Hand's and mine does. Remember guys, we don't care about listing all db files...

Good job! You are very close to what I have but mine is a little different. You used a CURSOR walking all sysdatabases and selecting the singleton table sysfiles to...

Thanks very much. You really helped me out filling in the hole here..Microsoft does need to spell this out in BOL 2008 in my opinion, particularly if people start doing...

Understand, but if SQL Server 2008 SSRS is going to use that Sharepoint 2007 collation automatically when it creates its ReportServer dbs on a SQL Server db server, you would...

Understand the breakdown of the codes, but how does all that tell me or anyone else it is a SharePoint 2007 specific collation?

I still do not see that specific collation I mentioned above or SharePoint 2007 referenced in that document you just resent.

I did not find this collation referenced (Latin1_General_CI_AS_KS_WS) in BOL 2008, nor did I find it in the above link you just supplied.

Thanks again for the info. I wouldn't be surprised how many people do not know about this. That collation is probably needed in those dbs to publiish SQL 2008 SSRS...

Thanks kindly. Is that a Sharepoint 2007 collation for use with SQL 2008 SSRS? I did not find it in BOL 2008 however. Thanks again. Travis.