This article may help you Chris
http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html
--
Allan Mitchell
http://wiki.sqlis.com |
http://www.sqlis.com |
http://www.sqldts.com |
http://www.konesans.com [quoted text, click to view] "Chris" <Chris@discussions.microsoft.com> wrote in message
news:8034C64C-AB91-4981-B5EE-442734C8ACF5@microsoft.com:
> Why does tempdb grow when I am loading to a userdb (ole destination)?
>
> If this is transaction info, why would it even use tempdb & not log file of
> user db??