THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » Database Testin... » Database Unit Testing   (RSS)
  • Fun with DBCC CHECKIDENT

    <Denis Gobo’s mode on> Suppose you have an empty table:   SELECT COUNT(*) FROM SampleTable --- 0   What would be the result of the following query:   DBCC CHECKIDENT('SampleTable', RESEED, 1) INSERT SampleTable(j) SELECT 1 SELECT SCOPE_IDENTITY()   <Denis Gobo’s mode ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 26, 2008
  • Database Unit Testing: Impersonation

     When you run NUnit/C# unit tests against your local instance, you are a dbo. As such, you are not getting any errors caused by missing permissions. However, you can impersonate another user, and run your unit tests in the context of that other user. The following test harness demonstrates the ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 18, 2008
  • Unit Testing Tips: Reproduce a Lock Timeout

    Well, I have just finished a series of articles about unit testing on simple-talk.com, and some techniques were not included, just to keep the articles short. Still problems such as reproducing a lock timeout and unit testing the retry after it (lock timeout) are interesting, at least to me, so I am continuing. You will need the ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on May 30, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement