We had a similar problem with a part of our program. Other programs had no problem. Setting the database compatibility level to 70 solved it.

Maybe the optimizer for...

David,

how do you make sure that the sid is the same on the two machines?

I just adapt the user sids with sp_change_users_login

I cannot think of a good reason tho shrink databases and logs every night. The growth back on the next day only costs extra performance.

If the trans logs fill...

The sqlserver version for dbms_utility.analyze_schema is sp_updatestats. You do not need parameters. Alamir's suggestion of autostatistics does it autmatically after some number of mutations.

I once accidentally did run transaction log backup en database backup at the same time and had no problems.

Have you tried to log the job?

Thanks for the advice

The NT administrator said he had not changed the permissions, but he had to do a forced reboot, because something did not stop on the server...

I have no experience whith arabic characters, but my experience with diacritic characters is that a question mark means that the client cannot display the character.

My guess is that you do not have a resources problem, but a locking problem. Your users are waiting on each other.

Are you sure about the nolock option?

Are tables...

We do, but that is because I do not have complete control over the servers.

There is certainly a performance issue if the databases are scanned. If files with .mdf...

This is weird. I never saw this before but had the same error yesterday. There was also a diskspace error and the server did nothing.

Like you not AWE...

Did anybody try the new SQL Critical Update utility?

You can find it at

http://www.microsoft.com/sql/downloads/securitytools.asp

If it works we can be lazy.

Joachim.

quote:

---

Can't say I am thrilled about the change to sp_change_users_login--requirement for @password. It is good thing closing potential security holes, though!