I found the following doing a search for your error code:

http://gps678.com/21/18812c397bfe53f4.html

http://wiki.sqlis.com/default.aspx/SQLISWiki/0xC02020E8.html

It appears to be a problem with the destination file, not the source as the error...

Definitely a good question to ask before relying on a trigger. One case...

By default, if you are a member of the Administrators group on the box, you have sysadmin rights in SQL Server. If that was disabled, there are procedures for resetting...

Scott Duncan (5/20/2008)

---

I can see how defragmenting works on a single physical drive (after all, that's where it all started).

I've always wondered though - how does it handle drive arrays?...

From a personal standpoint, I can say that an employer who invests in their employee will be more likely to keep the employee. My previous employer invested reasonably well which...

Maybe but developers won't stop using it until they are forced to by...

One thing you might try is to open up the query in SSMS, highlight the entire query, click on the Query menu and select Design Query in Editor. SSMS will...

Brandie,

I can certainly sympathize with you and I don't like the uninstall/reinstall route either. Please let us know if Todd's solution works for you. Seems like a simple solution that...

Does your user have UPDATE and DELETE rights in the destination?

If you have TSQL scripts that will do what you need, I would put them into a job and let it do its thing. SSIS does have its place, specifically...

Diskeeper does claim that they can safely defrag databases while they are online. I used their product for years at my previous employer without any issues. I know it was...

I have always found that having plenty of RAM is the first key. With on 4GB of RAM, your SQL Server may be suffocating the OS. I would start by...

The true difficulty, Sybase or not, is that it is not ANSI 92 compliant. SQL Server 2005 operating in mode 90 enforces ANSI 92 standards so *= or =* will...

Consistency will ultimately raise the quality of the work being performed, in all cases. Time to complete a project is also critical. Too many projects are put on short deadlines...

This kind of bizarre behavior would definitely cause me to re-install. Personally, I would rather take the time to re-install and let it correct itself than have to setup things...