Ninja's_RGR'us (10/19/2011)

---

Hey wait 1 sec.

The error says that the INSERT fails.

So maybe you can reset the quoted identifier setting and see if that fixes it.

Google doesn't give much usefull info...

Ninja's_RGR'us (10/19/2011)

---

Sounds like a bug in DBCC (or anything outside your control).

Unfortunately aside from upgrading or running this live I have nothing to offer.

Plan C might be to run a...

This did run as a scheduled Job with the SQL just pasted into the Step, and here's the log from the job history:

DBCC execution completed. If DBCC printed error messages,...

I'm starting to see this to be true, so I'll probably...

Thanks... unfortunately the application we're developing uses Views when selecting data from the database instead of Procedures so I can't add auditing at that level. I just setup a...

You can loop through the directory using SSIS, which isn't too crazy to do, but if you're still learning SSIS and just need a quick and dirty solution you can...

We have a few servers wearing multiple hats with SQL being one of them, and we've had instances where MS SQL does chew-up most of the available memory. As...

ericwenger1 (8/30/2011)

---

Every once in awhile our application is getting timeouts(not to be mistaken with deadlocks). I have turned on sql server trace flags to write to the error log to...

Nice, thanks for the suggestions. I modified my original query to take into account pretty much everything I could think of that might proceed a table name, and it...

Hi Katen,

Actually we never did find a solution, though we think the problem...

vkkrishn (4/6/2010)

---

Hello,

We have our application running on sql server 2005. Recently we started slowing down of the database and timeouts. Once we clear the SQL cache, it turns normal again....

Actually I found the fix... I had to enable DelayedValiation at the package level instead of on the Excel Connection. That seemed to work.

Thanks --

Sam

Hi,

I just ran CheckDB on the Model database which returned zero errors. Yesterday I emailed the network team maintain this server...

That's it 🙂 I checked Google and even Microsoft's site, but never could find it.

Thanks --

Sam

I'm actually researching this right now because one of our core apps is running on SQL 2000 and we're planning on moving it to SQL 2008 in the upcoming months....