I've got a couple of things here:

1. It looks like you are attempting to place the backup files in the root of C:\?  If so, I would suggest you move...

I do not think you need a package for each user.  You should be able to set up one package with multiple text file connections pointing to one SQL Server...

Some organizations also have Storage Admins who handle physical storage of data.  So, as a DBA, you may have to interact with the Systems admin for OS/Windows related tasks and...

Have you tried to run any sort of diagnostic tools on your SQL Server?  It sounds to me like the server was undersized to begin with, then it was broken...

If you need to process, row by row, I would suggest selecting from inserted/deleted and working off of temporary tables.  This would allow you more flexability with how you handle...

The trust is the reason why everything is still working as it was prior to the domain move; however, Rudy is correct in stating that it may be temporary in...

When you say multiple rows, I assume you mean that you want to perform some process based on all or a subset of rows that exist in the inserted/deleted virtual tables? ...

I would use profiler if this is for a short term period so that you can satisfy your manager’s needs.  If you need a long term/permanent solution, I would...

If your users are still working OK, then they also set up a trusted relationship between the two domains.  I have seen this before and left the Windows logins with...

Try adding a ',' between each column in your select and give your text file a .csv extension.

Example:

Select ColumnA, ',', ColumnB, ',', ColumnC from tableA

SQL Server will allow you to set it back to blank.  When you go to set the password, notice that there will be a 'blank password (not recommended)' checkbox. 

As...

I do not have experience writting scalar functions, but you should be able to get your question answered by someone on this forum.  There are some very advanced SQL statement...

As a side note, be careful when calling stored procedures through your triggers.  Anything you add to your triggers is going to prolong your transactions and could lead to more...

Hey, no offense intended.  You have to admit, that is one wild looking query.  I, like Vladan did not even try to read through it.  You've given us an example...

See, I knew there was a better way!!