Forum Replies Created

Viewing 9 posts - 46 through 54 (of 54 total)

  • RE: SQL Unit Testing

    Hi Jonathan,

    I see your point, I misunderstood the "integration test" line. Actually, it's a good observation, and I partially agree with you. If you just run the test as if,...

  • RE: SQL Unit Testing

    Hi Jonathan,

    I'm confused about what you mean with integration tests. Why you think this is the case ? It's true that I used it to test different systems, as mentioned...

  • RE: Search SQL Error Log

    Hi James,

    That means that one of the log files is not there. I'll review the script to validate that the log file exists.

    Cheers,

    Alejandro

  • RE: SQL Unit Testing

    Hey Brian,

    totally agree about the complexity. I guess the first thing to do before using this is knowing how deep you want / can go. For brand new projects is...

  • RE: SQL Unit Testing

    Hi Brian,

    This is a good observation, and I agree with you about the system testing if you just run it out-of-the-box.

    This tool saves tons of time writing the queries from...

  • RE: SQL Unit Testing

    Hi Mike,

    The test will validate if it runs without errors. Because you're executing stored procedures or t-sql commands, if there's an error, the unit test will fail, so the overall...

  • RE: SQL Unit Testing

    Hi karthikshanth,

    You can actually test the calls to the database, so in a certain way you are testing the SSRS backend.

    If you want to test the reports, there's a free...

  • RE: SQL Unit Testing

    Hi there,

    GermanDBA is right, you should create some sort of backup/restore strategy or include the DB creation / data population prior to run the tests and then just drop the...

  • RE: Search SQL Error Log

    Hi Nancy,

    sorry the delay but I'm on a trip and just saw your post. First of all, it won't work on SQL 2000 because I create a table variable, which...

Viewing 9 posts - 46 through 54 (of 54 total)