I don't know where the layout definition is in DTS, but SSIS packages are completely portable and everything is in the .dtsx file.

The layout and postition of everything in the...

A safer approach would be to have them access the object definitions without accessing the database. Script all of your objects into a source control system (VSS, for example)...

You could also create a sql agent job and use sp_start_job

I don't really see how you would reproduce the issue in a stored procedure.

Your table definition will have to remain the same anyway.

Once this is in a stored procedure, you...

In most cases, sing a function within a join or a where clause will force table scans.

Because SQL needs to resolve the function before it can determine if a record...

For a relatively safe approach with the least amount of development and testing, wrap your existing com object in a web service and publish the web service on a 32...

Having worked for a mass-mailer for a few years, I would recommend you do not do this. People are touchy about their names and what you are asking cannot...

Nope, you will need to use a bunch of CHARINDEX calls. At least you don't have to loop. If it helps to think outside of the box, if...

My first guess would be a permissions issue. Then you are running it from BIDS, you are probably logged in with a different user than it is running under...

That was some nice stuff.

Your other question - the same spid multiple times. This is caused by parallel processing. Look up the MAX DOP or Max Degrees of...

SUSPENDED generally means the process is waiting on something that is not being done by MSSQL. For instance, if a long running process is waiting for the operating system...

Join your inserted table back to the actual table.

SELECT * FROM Inserted I

INNER JOIN MyTable M ON I.MyID = M.MyID

The text operations will happen before your trigger fires so you...

AWE Memory use does not appear in any of the standard memory use displays. If you want to see the use of AWE memory, you need to use perfmon...

Without specifying @append_query_error = 1

sp_send_dbmail runs your query immediately to make sure the query does not fail before the query is put into the mail queue. This is just...

By default, SQL runs the query you specified before putting the message into the service broker queue so you get immediate feedback from sp_send_dbmail if your query is bad.

If you...