Erland Sommarskog (7/14/2013)

---

So I tried to repro the problem my filling up the table you posted with 10 million rows, which then exported to file in native format. Then I...

Erland Sommarskog (7/11/2013)

---

Didn't you say that you had also tried BCP? I'd rather work with BCP than writing a .Net program. So if you have the BCP command (and any...

not a problem, here tables schemas and indexes.

CREATE TABLE [dbo].[TempTable](

[DataID] [int] NOT NULL,

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[OID] [uniqueidentifier] NOT NULL,

[TypeID] [uniqueidentifier] NOT NULL,

[PropertyName] [nvarchar](100) NOT NULL,

[PropertyValue] [nvarchar](3900) NULL,

[RefID]...

Erland Sommarskog (7/11/2013)

---

There is a Service Pack2 out for SQL 2008 R2 out. I don't know whether that will resolve the issue, but you should be on the latest service...

Hi there,

My application is still at the development stage switching from regular insert statement to sql bulk import and yes so far the issue occurs consistently I couldn't get it...

Here is a detailed error:

System.Data.SqlClient.SqlException: Insert bulk failed due to a schema change of the target table.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean...

haiao2000 (4/30/2013)

---

OnlyOneRJ (4/30/2013)

---

SQL Show (4/30/2013)

---

I had the same problem few years back, no space in ldf drive. But users were able to logon. We received error only when try to...

OnlyOneRJ (4/30/2013)

---

SQL Show (4/30/2013)

---

I had the same problem few years back, no space in ldf drive. But users were able to logon. We received error only when try to run...

The fellow coworker that asked the question has been quiet since my last suggestion, so I am guessing he was able to manage the sittuation. The last question he asked...

Lowell (4/29/2013)

---

hmmm; i'd say there is always files that can be moved or deleted.

files in temp folders on the operating system, log files, , the already suggested moving of backup...

GilaMonster (4/29/2013)

---

Do Not delete the log file.

Add more space and/or remove files that aren't necessary (old backups, logs, etc)

What error do you get when you try to connect? Logging in...

sqlnaive (4/29/2013)

---

Haiao, I experienced one such issue as well with one of my friend's client. There the issue was very basic. All the DBs were configured with Full recovery but...

Mucho gracia guys. I think it means Thank you guys =)

Thanks Sean,

So after restored on a SQL 2008 R2 engine, the database being upgrated to 2008 R2 or is it still considered sort of SQL 2005 database running on compatibility...

rama.king127 (4/17/2013)

---

A string contains 3,4 suppose I want to store 3 in one parameter and 4 in another parameter similar in c# like arr[0] and arr[1]? how can i achieve...