You could create a new step which is run if the CheckIfFilePresent step fails which will add a new one time schedule entry for 5 minutes time and then end...

As an additional complication.

I'd suggest you also store the invoice date.

Tax rates can change and in general the tax payable will be charged at the rate applicable at the time...

I'd have to agree that removing tha ability to remotely log on to the server will hinder the ability for the DBA to do their work.

As long as SQL Server...

Has anyone changed that ID column to an Identity column without telling you?

One option would be to change the applications so that they connect to the database using an application specific service account which the users will not know the credentials for....

Also if the server is a virtual you should check into how the physical server hosting them is updated.

The updates could also be distributed via some other means - most...

Could this have happened following a reboot of the Windows box hosting SQL Server?

So overnight on a Tuesday. First thing I'd check would be was this due to an automatic reboot triggered by Windows Update?

SQLRNNR (11/1/2013)

---

Which timezone? Here in the states we are looking at the time change to...

The issue of the clock going forward can usually be totally avoided by scheduling your job to not run exactly on the hour. Running the 2am job at 01:59 would...

have the disabling job create another job scheduled to run at 01:50 which will enable the original job.

madhu-686862 (10/25/2013)

---

That means, clearly some OS process is taking lot of memory. But how to find what it is?

In Task manager, I did NOT see any OS process taking...

I would expect that behind the scenes the LEN function is implemented as a set of overloaded function prototypes and there is no implicit conversion occurring.

Definitely check you have connectivity to the server during that period.

There may be a job (SQL or OS) or a system update running on a different server which means the...

assuming your c: drive is only used for the OS could you use disk quotas in windows to limit the amount of disk space visible such that attempting to take...