I have faced this problem from one of our small portal so I found the solution for this issue as following:
1. Using SQLCMD with Accessories -> System Tools -> Scheduled Tasks (Windows Tasks).
For example:
link
2. Using SMO Code.
For example :
Link
3.Using third Party to do the task.
For example:
Link
No comments:
Post a Comment