quote:

---

You can try to set your rowterminator to '"/n'.

---

Nice idea, Thomas. Although...

You could eliminate the 2nd query, by adding records to the recordset, then checking the identity column after the update:

Set rs = db.OpenRecordset("Select * from students_table WHERE 0=1"

rs.AddNew

rs("studentname") = "John"

rs.Update

rs.Filter...

MJ, just wanted to clarify your setup, just because I think I see a conflict of terms in your original description. If you are putting the files on a...

Also, don't forget to get any other security and hotfixes after SP3a. Check at http://www.microsoft.com/technet/security/current.asp

I have done a similar type project where the web server is hosted at the ISP. But the client (and frankly, myself) did not want to put the database...

I had posted a question on this a short while ago ( http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16009&FORUM_ID=65&CAT_ID=1&Topic_Title=Max+Memory+recommendation%3F&Forum_Title=Performance+Tuning ). I had seen a reference to an "official Microsoft recommendation" in Great Plains Installation eCourse...

I was thinking this was just a test to see how many people just pick random answers without reading the question.

Paul;

Does your file also contain text (alphanumeric) data? If so, and you converted the IBM EBCDIC characters to ASCII characters during the download (almost always automatically done), then your...

Based on your descriptions, it certainly sounds like indexes are not efficiently set. A suggestion to easily help define those indexes. Run the Profiler utility to capture all...

quote:

---

...Is there any possibility that DBCC is trying to fix some minor errors, and SQL Server changing to Single User Mode &...

To followup Andy's comment;

If in your database maintenance plan, you check "Check Database Integrity", and also check "Attempt to repair minor problems", the database will set into single-user mode....

quote:

---

My fault on the English - we haven't decided what to do just yet. Clearly if can't follow the article it's of...

Also, there is a problem in SQL Server with identity column when recovering from crashes. This has existed in SQL Server since at least v4.2.

Suppose you have an identity...

quote:

---

I do not agree. The order of columns in your table should never matter.

---