I guess I'll be more specific in that a trigger for this type of thing would really need to be an asynchronous trigger (which we can now build).

Many applications in...

There are lots of ways. Using the bcp command line utility, you can bulk copy them in as a single batch. You could use SSIS (keeping in mind...

You can have an output that is not connected to anything. It will give you a warning, but it will not hurt anything.

As an alternative, you can put it...

You cannot change your destination connection based on the record you are in in your data flow.

You will need to use a ForEach loop container using an ADO recordset for...

If by "in use", you mean the file will be currently open by another process, you will get an error when you try to move it anyway, just handle the...

Ok, if they do not need to be admin's, then you have a chance...

Reporting Services - if they are only going to need to be able to add folders and...

The error is indicating that the connection cannot be made to the SQL server. This could be caused by the SQL server service being stopped, the server not responding...

That will depend on what everyone calls administration in your groups.

If they have to be able to start and stop services, r use terminal services in administration mode, they will...

We don't need all of the "z"'s, "please" is fine.

As for your problem, you are concatenating a string to it self.

UPPER(SUBSTRING(ename,1,3)) + ename + "a"

The length of ename plus any...

I have never tried to migrate a log, but here is my thought process on it.

Even just using the migration wizard to go from 2000 to 2005, you are going...

You gave us an "or" in your question that makes it difficult to answer, but here goes.

If you set up your publication to publish all columns in a table article,...

Your second option with the temp table is a bit confusing. If you post the T-SQL, we can probably tell you why one is faster than the other and...

There are two types of clean up tasks. The "History Cleanup Task" removes history information from the MSDB database relating to maintenance plans. The "Maintenance Cleanup Task" removes...

Try plaing with the Tuning Advisor that comes with SQL. Overall, it is not going to be able to give you the right answer 100% of the time. ...

It's good. I wouldn't consider moving to it without really good reasons though. You need to really do the analysis of what your current problems are, what the...