If you are constantly shrinking your log file, you are not going to keep it from growing.  Even in simple recovery mode, SQL Server writes all update, delete, and insert...

If this is occuring on a regular basis, you may want to consider keeping the log file at a larger size.  Remember that everytime the log has to grow, your...

Cross posted.  Check here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=396141

Not that I have found.  You could load a temporary table then query the temporary table.

Since you have the Microsoft SQL Server 2000 DTS Designer Components loaded, you should be able to access the the TS packages using SSMS.  You should access it through the...

You should look into package configuration files in SSIS.  We also use a configuration database to allow us to dynamically configure our SSIS packages simply by making a change to...

Vladan, Be careful using xp_getfiledetails, it goes away when you move to SQL Server 2005.

No.  Only transaction log backups will truncate the transaction log.

Could you post the DDL for one of the procedures?  I'd like to give it a try and see what happens.

To use CLR stored procedures, your database needs to be in Compatability Mode 9.0 (SQL Server 2005).

I am assuming that you have created some procedures in the master database that you have named sp_xxxx. When you run those in a user database are you calling with...

When we upgraded our PeopleSoft Financial System database from SQL 2000 to SQL 2005, we had similiar issues.  We initially used DTA to identify new indexes, and ended up adding 37...

Fully aware of using SQL to start jobs, or using xp_cmdshell to execute command line programs.  Starting a job is asyncronous, and would require additional coding in both the job...

This is the link in BOL I started my research with:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/2f9fc1a8-a001-4c54-8c64-63b443725422.htm

Could you also provide the full code for the stored procedure?  One thing most will jump on is the possibility of parameter sniffing (search this site for more info on...