Thank you. I believe this will address my dilemma.

Thanks. That is helpful.

Since I've decided to use the file creation date and time, I am not using the code I created for this ticket. Still happy to consider alternatives to...

We are receiving daily backup files. I need to select the correct one from a folder and automate the restore process. It makes sense to use...

Thanks Team.

can I say well duh!

Thank you gentlemen!

I needed a domain account for the SQL server service. The editions did not matter.

Success!

PERFECT! thank YOU!

The detach and attach commands worked. Just had to reference the correct files.:hehe:

I solved this. All I can say is stupid is as stupid does

Nice. I found a solution using a correlated sub-query but yours is simpler.

Done.

Nice feedback. I appreciate it.

Thanks. I probably won't bother.

Thanks Luis. I took some code from the link and tweaked it. It seems to be working. For this small fix, a cursor...