Did you do anything that could mess with the sequence.

I will take the easy route.

Briefly

Limit the user rights/privileges on your database Server .

Done that before and did not seem to notice any direct impact on performance.The other side to this which did not work well was that the application log was full...

First I would check my OS .Traditionally backups are not bigger than the source files. And the way transaction logs are supposed to be backed up(Inactive sections) it is hard...

Not sure exactly what errors come up as a result

but you should be aware of the SYSWOW (Windows on Windows emulation ) From Microsoft

The \Windows\SysWOW64 directory is...

My SQL Servers DBs with 100+ users have done pretty well with 32bit .The one system that had more users tried 64bit but because of prevalent locking went to...

It seems very easy to point this out probably becuase more information is needed

It will be expected to be

in the likes of item.item_name not like 'RA%'

Again seems like...

Not encountered one yet.Why the question?

What is the error message(s) you are receving ?

Thanks to everyone .

Those who answered our questions and those who posted questions for us to answer when we could.

I believe that,this aspect brings the most users to...

Thanks Greg

Got it right after posting .

The error you stated is pretty generic .

Go to the job steps,select advanced and choose a file where the errors could be logged

That could provide more information

It is assumed sql server authentication  is what is failing since the domain is not trusted ...

Thanks for your time

Not sure...How would server side traces track long running sql

Make them understand you cannot cluster now and will like to test before you set up clustering.If they believe you are familiar with clusters and should be able to set...