jeffroyal's method for renaming the file to the source filename that your DTS task is expecting should work fine.  As far as only importing certain columns, I believe that you...

If this is a production system, I would recommend individual maintenance plans for each databases.  You do not want a problem with one database to affect the backups/maintenance of the...

He needs more than just a delete trigger.  It states in his first example that when new records are inserted, the previous records need to be updated with an end...

It sounds like you want a stored procedure that will go throgh and snyc your start/end/elapsed times in your table.  You could accomplish this real-time using instead of triggers.  Will...

The use of a temporary table would eliminate the need for patIndex.  You would have to redesign your stored procedure to work off of the temp table instead of using...

Will each customer have a running balance?  Why not create a customer table to hold customer info?

Have the sysadmin sign in using 'sa' and either re-attach your DB, or reassign your default DB.  Hopefully you were not using 'sa' already.

It looks like you want to make the data in the inserted table available in your stored procedure and you know that you cannot access inserted table from a sp,...

1.  ?? good question. 

2. I have seen measurable performance improvements when increasing the block size of a RAID stripe/mirror in UNIX systems.  I would say that this if you...

insert into transactions default values

Steve, Vinny:

My last post was meant to rebuke David Wootton's post prior to Steve's.  I have taken the angle all along that Mr. Wood is running SQL Server on a...

I'll agree on the fact that his organization needs to put some more money into thier system.  Keep in mind that not all companies can cost justify new hardware purchases...

When he talks about virtual servers, he is not referring to a clustered environment.  He is running VM software on his server and that one physical server is split into...

Just curious, why does it need to be all in one query?

When you say application roles, I assume that you mean user database roles?  If this is the case, use sp_addrolemember  Use this sp, or write your own that calls this SP. ...