Unless you have a trace running capturing all SQL, you cannot. But, you may be able to tell who was running the process that caused the autogrows. If teh Default...

+1

Here...

george sibbald (3/14/2012)

---

that article is saying on a 32bit system AWE will allow you to address memory above 4GB for the buffer pool. Otherwise you are limited to either 2GB,...

That's a common practice. It is not usually necessary however I rarely oppose it when...

You're welcome 🙂

Lisa Cherney (3/14/2012)

---

If you need to do this from a .net application, load your data from the file into a DataTable and then use the SQLBulkCopy class (http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx) to move...

No. I have moved msdb with no problem without disbaling...

In my experience the weakest managers are the ones repeatedly leading a witch-hunt for this or that...terrible for morale and very anti-progress.

All moves have advantages and disadvantages. The cloud is...

Are you using a version control system to manage your SSIS packages?

Are you deploying packages to the file system or to msdb?

Yes.

DTUtil.exe is what I use for exporting packages from servers. It's included in the client tools, available from the command-line.

Yes, you can set Delay Validation to true. The downside is you will not pickup on outdated metadata or broken connections until runtime.

Nary is the day when I am in an environment without an SSIS installation for use with ETL processing.

Jeff Moden (3/13/2012)

---

opc.three (3/13/2012)

---

If you use SQL Agent, there is no need to introduce an additional programming domain into the call stack. Ditch xp_CmdShell and call bcp from a step...