Thank you both so much!

Thanks!!

Thanks...that was exactly what I was looking for!

Although I do have one more question to clarify based on your last example...several packages perform imports of csv, or txt...

What can I do to determine what queries/procedures are consuming the most memory? Other than physically running each one myself and monitoring the counters in a dev environment.

Just to confirm for Peter, I stagger our db defrag/reindex for a few databases per night over the course of a week due to time constraints. I do however...

I use a script which I found on this site....

http://www.sqlservercentral.com/scripts/Index+Management/30721/

I've create a few sprocs to go along with this script...

-first, I backup the database

-second, I change the recovery...

Thanks for the suggestions...I think our final solution is to create one data source directed at our "pointer" server (which is linked to all other servers) and force the web...

Since I've been here, I've made sure that all db's are sized appropriately on creation.  However, this particular server was brought on line and filled to capacity with db's long...

I'll give that a shot and let you know what I find

I use the same SQL credentials that are passed in the connection string...

Our environment consists of a database for every customer, they're individual user credentials (for each store) are entered...

I don't believe it's a permissions issue as everyone using the web app log's into SQL with the same credentials.  (They don't actually use a SQL/NT Login...as far as the...

I think creating a separate package to loop through all DB's and execute the import package is the way to go, thanks for your help paschott

You totally rock Rob!!!!

The function works perfectly!!  Thanks for you help...and everyone else too

Thanks for the quick reply!  Unfortunately though, we're using SQL 2000...I don't believe Cross Apply is applicable here.  I did try to run the query using a cross join...but SQL...

No...not really, because I only want to sum lines 2 and 3 not 1 through 4.  Lines 2 and 3 constitute 1 line item.

I think I'll just have to create...