Browse by Tags

• Database Programming
• Database Unit Testing
• Impersonation
• SQL Server

• 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 Read More... Posted Thursday, June 26, 2008 5:51 PM by Alexander Kuznetsov | 5 Comments Filed under: SQL Server, Database Unit Testing, Database Testing, Database Programming

• 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 Read More... Posted Wednesday, June 18, 2008 12:19 PM by Alexander Kuznetsov | 1 Comments Filed under: SQL Server, Impersonation, Database Unit Testing, Database Testing

• 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 Read More... Posted Friday, May 30, 2008 6:24 PM by Alexander Kuznetsov | 0 Comments Filed under: SQL Server, Database Unit Testing, Database Testing