Thanks Michael, I will take a look at that.

Thank you homebrew01, I didn't know I could do that but will when I revise the backup plan.

Homebrew01 - I have deleted the last "big" file but can try that if it does it again.

Micheal L John - no normal database activity. Nothing is purged unless its...

Thanks for all your responses.

No, not doing any maintenance or rebuilding of indexes before backups.  Its been about a month since I did some index maintenance.

The database is currently 670,847.75...

Thanks! You guys are the best!

Jeff Moden (9/16/2016)

---

erouse (9/16/2016)

---

Can somebody please help? Is there a fairly simple way to do this?

This is my data now.

LABORLC

152685A B C D E

152969A B

This is what I...

Dynamic SQL solved the problem. Thank you for all of your replies.

Thanks for your reply Drew but the quotes aren't stored in the tables. If we run SELECT * from #mydaterangetable WHERE tbldaterangeID =3 we get:

3Last 7 daysDATEADD(day, DATEDIFF(day,...

Thank you, that fixed my problem!

Great procedure, thank you.

If I run it on the local drive it works great.

----------

USE [master]

GO

DECLARE@return_value int

EXEC@return_value = [dbo].[GetDirDetails]

@piFullPath = N'C:\'

SELECT'Return Value' = @return_value

GO

----------

However if try to run...

Yes I can use xp_cmdshell

Attached file shows results 250 to 260. Note that after row 255 all the file details are the same yet the row number changes.

Jeff,

This procedure works great but when I use it to read a directory that has more than 255 files in it the file names and details for the row...