Hi,

It might be similar to an issue I encountered with SQL 2000 ..

http://sqllearnings.blogspot.com/2009/01/error-14274-cannot-add-update-or-delete.html

Mohit.

When does the transaction take place?

If it is once in a while like a after hours? Then you can change the recover mode to Bulk-Load and then change...

The more data it you put into the system the longer it will take to return the results. Few caution steps about that tool:

1) Don't run it on production...

Options?

1) are TSQL have to be executed at a time after the CSV file move? Or is it mixed together?

- If it is after, then schedule one job to CSV...

3-4K total from all 28 tables? I don't think you have big worry about still recommend you to do it off hours. Because when deleting data indexes will be...

Yes.

I had asked similar question from MS; and was told it is "recommended" you install this. But in order for you to install this you have to upgrade SQL Server...

And Statistics, heh if the go out of sync you have issues.

Ref: http://sqlblog.com/blogs/elisabeth_redei/archive/2009/03/01/lies-damned-lies-and-statistics-part-i.aspx

In addition don't forget network traffic that can also have affect on the server; too many...

Cool beans :). Thanks for letting me know :).

Same .. I ususally save it to CSV then import to SQL Server if I have to do analysis.

The profiler up to Windows 2003 is really a paint to work...

Hmmmm

I think it might be reading the setting for Non-Unicode programs from your computer..

Regiona Settings

Advanced

-> change that setting to proper lanaguage of choice..

Mind you it might mess up other programs....

luissantos (3/6/2009)

---

Hello Mohit

Thanks for your reply,

on point

2.2 - No you can't. If the database has been attached to 2008 it cannot be attached back to 2005.

I think...

Hi Mike,

Something/someone is killing their SQL Server connections, eg "kill spid" or right clicking in activity monitor going kill connection. Are they connecting to a cluster environment?...

Heh Ed,

I going to point you to http://sqlskills.com/BLOGS/KIMBERLY/post/Whose-job-is-it-anyway.aspx :P.

heh similar thing being discussed there :).

I think data is ultimately DBA's responsibility. I feel DBA should...

Sorry Carl; I assumed it was 2005 because it was under 2005 category. Sorry.

In OSQL case the only way I was able to get data import to work properly...

Jeff Moden (3/5/2009)

---

Mohit (3/5/2009)

---

That trigger is def a good idea :). Another option you have is since the stored procedure is required in each database; why not add it...