The GUI will time out regularly when modifying large tables. T-SQL is the best way to make modifications to large tables.

Shane's suggestion is good as well. Although I...

No problem, I enjoy pretending I am an expert. BTW-I was right on my answers.

Before triggers were never part of MS SQL Server. I know they...

There is also a free tool out there called SQLDigger that will do exactly what you are asking. http://sqldigger.bdsweb.be/

Hey no problem, David is my middle name anyway.

You want your update trigger to join on the inserted table;

Update A

Set UpdateUser =...

Every place I have worked the DBA's were responsible for SQL Backups to disk and then the Server/Network admins were responsible for getting the backups to tape. We worked...

I've never used one, but SQL Server has an Instead Of trigger that will probably allow you to do what you want. Basically the code in the Instead Of...

Please post similar questions in 1 post.

One issue you need to deal with is that every time SQL Server is restarted, tempdb is recreated and it is recreated based on...

You can attempt to run DBCC ShrinkFile('tempdev_log') to recover space in the tempdb log file or you can restart the sql server. If you tempdb log file is full...

For CreateDate and CreateUser you want column defaults not an insert trigger. You can create the defaults using the GUI or with T-SQL. If the table already exists:

ALTER...

If you want help you have to provide some information. If you post the step in the Job someone might be able to help as well. Just giving...

Does this table, dbo.VXTrackerStatsWithDuration, exist in the source?

Are you running the package in BIDS or on the server?

Does the account that the package is running under have permissions...

Yes you can use case in a where clause. I think if you explain the desired results and post the table structures and dummy data, we can come up...

I believe so, if that is one of the objects that is part of your publication.

If the IIS server and SQL Server are not on the same box, ASP.NET will not pass Windows credentials easily. I am not an ASP.NET guy, so you will...

Does the location of the Excel file exist on the server? Does the user executing the package on the server have rights to the location of the Excel file?