Hi,

you can follow this link to achieve your task.

This link also shares some useful information about generating comma/delimiter separated string.

This link has got a good compilation of the possible ways to do it.

Adding any User objects to the Master DB is a very BAD idea. There are many ways you could achieve the backups -

1. Schedule the Backups using SQL Jobs.

2....

Hi, you can even go for using SMO to get your task done in a more easy way. Please refer this msdn link.

Great handy article !!

However, we can also achieve the same through -

SELECT CONVERT(DATETIME,DATEDIFF(dd,0,GETDATE()))

This way we can save the time taken to perform DATEADD operation though it would be quite...