We have used WAST in the past. If you have a web based application this might work for you. There are better tools but the price is right....

Sounds like you might have a trigger that is firing and updating the same row that the stored procedure is updating. Did you try using SQL Profiler with...

I agree up to a point. But if you inherit an environment where someone has created a number of tables with no primary keys, then this can be useful...

If you have purged a lot of data then you will have a lot of partially filled pages. By creating (as ALZDBA states) or rebuilding the clustered index...

Yes, this is useful. In fact I ran into a case yesterday where I was able to employ this method to remove duplicates from a table. And as...

I think the same idea applies to the SQL Native client. Everything is still SQL 2005. When you set the compatability level of a database to...

Your English is fine. It is probably more the medium that we are using. Same problem with email. Good luck with what you are doing. ...

I am not sure I understand what you mean by upgrading your clients connections, but yes the mechaninsm that you use to connect to the database must be compatible with...

After re-reading your question, perhaps I should add that you can only connect to SQL 2005 using the methods that SQL 2005 supports. Changing the compatibility level of...

No it should not effect your network connections. You are still connecting to the SQL 2005 database engine. By setting the compatibility level to 80 on your database...

Yes, generally they are complex quereies involving both inner and outer joins. SQL 2000 would join the Inner Join tables first since they were the most likely to reduce...

We are the vendor for our product. Our requirement was that the product still had to run on SQL 2000 and also on SQL 2005. We discovered...

Actually, that is what we did as...

Some vendors are like that. But be sure and test thoroughly as there will most likely be things that you encounter that will cause some problems. We have...

jim.powers (4/29/2008)

---

The unfortunate thing is that simply importing the database to 2005 and changing the compatibility mode to 90 won't tell you of these types of problems. You won't know...