Please God Please remove the On Error GoTo!
Don't make the baby Jesus cry [:'(]
Please God Please remove the On Error GoTo!
Don't make the baby Jesus cry [:'(]
A few years ago, working on a large series of interconnected Sql Server 7 dB's on the same instance Sql Server box, we found we were having disk space issues. Basically the huge DTS that ran weekly, (and I'm not going to scare you with what it did) was using so much Temp Db space the disk on the Sql Server box was filling up and everything was falling over.
We had to have a meet with the ops guys so along we went, with my boss. His suggestion, at the meeting, in front of all of us and the ops guys was in order to save money;
'Can't we use some disk space from the ICL mainframe to beef up the Sql Server box?'
You're lucky, your boss only thinks he knows about one technology!