Hi,

Thanks for your concern but the DB I dropped was not that important and the data is present and easily accessible on other servers (and has also been backed...

Hi,

The files I removed should roughly be the size of:

CDR_200810.MDF = 1,000,000 KB

CDR_200810_log.LDF = 16,000,000 KB

CDR_200810FILE.NDF = 600,000,000 KB

So they are big files. Also I am fairly sure...

Hi, yes I am using SQL server 2005.

Is there any other way of getting these details (without using a CLR). Or is this the only solution?

Hi, I have tried that, the problem is that you cannot declare variables in views (not unless you know of a way of doing this?). Do you know of...

Hi,

Worked a charm!

Cheers