Have you tried BIDS? (Business Intelligence Development Studio)

Cool, one way to use a stored proc as a table.  I would think you would need to be careful doing this, though, by making sure the stored procedure didn't...

Could you provide the code you tried that failed?

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...