SQLPrompt Interfering with VSTE DBPro Unit Test Creation

Wyatt70

I was attempting to create a Database Unit Test in Visual Studio Team Edition for Database Professionals. Things were going well until I got to the screen to actually design the test. The window I am referring to has the following text:

"Use this script to test the database. This script is required for every database unit test. Click here to create"

As soon as I clicked "Click here to create", I got an unhandled exception. I had to shut down VSTE and reopen the database project. When I disabled SQLPrompt, I was able to create the test.

Bart Read

Hello Wyatt,


Thanks for letting us know. We've seen this in a number of scenarios with Data Dude unfortunately. We'll be getting a fix out very shortly (within the next two weeks or so). In the meantime I'd suggest trying to workaround the issue by temporarily disabling SQL Prompt using ALT, S, D and then re-enabling once you've created the test using ALT, S, E.

Hope that helps.


Thanks,
Bart

Wyatt70

That works for me. I just wanted to get on the list of future fixes.

Bart Read

Glad to hear it. Thanks for letting us know.
Cheers,
Bart