SQL Server 2000
There are 2 entries for the tag SQL Server 2000
This week I had a need for NUnit based unit testing against a class that depended on a provided SqlConnection. Up to this point I had been able to mock external objects and their behavior based on interfaces, but with a SqlConnection I could not mock. There are some options for mocking the SqlConnection such as TypeMock, but I needed a realistic connection to test against. This also proved as a good method for building the expected DB interface. The solution that worked best for my environment (only...
This tip might not fix everyone's issue, but for the problem I was facing today this worked out just fine. We have a scheduled weekly DTS package that is failing for the reason specified in this title: "Protocol error in TDS stream". For weeks we've just been running the thing manually, but that's not a solution, just a delay of the problem. I decided to investigate. I found an article on the SQLTeam.com forums that helped get this working finally. For us, all that was necessary was to switch the...