sql server 2008 express one row write problem
- by bojanskr
Hi everyone,
I have the most bizarre problem(at least it is bizarre to me) with MSSQL Server Express 2008.
The problem is the following:
On the development machine I use MS SQL Server 2008 Enterprise....I get some data from a WCF service and write that data to the db (simple as it can be)....I should point out however that the writing, it is done in a separate thread. BUt, anyway no problems during development...all the data is there.
Then I set everything up(connection strings .\SQLEXPRESS, other settings) build in Release and copy that to a test machine that has MS SQL Server Express installed(because my application is a client application and it should work with Express)...I run the program....the program retrieves the data from the service...and when I look at the database...I'm in for a big suprise...there's only one row written(the first row received from the WCF service).
I would really appreciate any help...I'm in a deadlock here.
Thanks in advance.
Bojan
