The unresponsive behaviour is while opening the connection. Ironically this happens only when the SQL Server Service takes a very very long time to Shut Down. If the Service is...

Thanks for the feedback. I know that we could have used a Trigger, but in order to maintain these triggers, we need to go through an extra process, which we...

Thanks. I have also contacted Microsoft for more information on this as well as for Training. Although I like the way it is turning out, I felt that there was...

Thanks.

Best Regards,

Trevor Benedict R

Microsoft Certified Professional (VB)

The Pay is calculated based on some formula like Basic Pay, then we add the Rent Allowance, after this we will deduct the loan etc and then the Tax etc...

Here is the Update. I have scheduled the Job to run at 9 AM with a 5 retry attempts when the Job Fails.

When I view the History Information, it fais...

I would agree with Brian on this. You can have a Script file, either with a .vbs extension for VBScript or .js for JavaScript and use Scheduler to Schedule (Win...

I will wait for the Upgrade. In the meantime, I would like to thank all of you for the tons of Information here. I will go through them slowly. I...

Hi,

Thanks for the reply.

When I execute the Job, it fails. After I execute it from QA (it works) and then if I execute the Job from EM immediately, it...

Hi Simion,

That was an interesting article. I think the focus should be on the term "Engineer" and "Systems Engineer".

Thanks for the ideas. Simon, I think I would really benefit from the Indexed View for the timebeing.

Best Regards,

Trevor Benedict R

Microsoft Certified Professional (VB)

I feel that Experience is important. This will enable one to perform when the requirement calls for it. On the other hand Certification will also be important because, this proves...