never tread lightly....speak your mind.

Yes, the number of rows is not the same. You get some additional log entries in the transaction log to go with inserts. That is not what the...

You could replace the T-SQL in the sp_send_dbmail procedure with a call to your mail client and you should find that SQL does not know that you have bypassed SQL...

Ok, that being said, I guess in my opinion, the answer is that the idea is not technically sound and you should try to come up with another solution.

From a...

What is your third party mail application using if it is not using SMTP or POP3?

You can see this yourself.

Create a new database and set the recovery model to full.

Add a single table with one INTEGER field.

Insert a record into your table.

Run: DBCC LOG(' ',3)

You...

I used to work with a guy who had created an access database with a bunch of linked tables in it so he could use the query builder in access...

It is just what it says - in one of your components you are trying to insert, update, or join by a unicode field to a non-unicode field (or the...

SSIS does not return much to the job history. You really have to use logging to get anything useful.

There are several differences, but (arguably) the most important difference is that a function is designed to return something other than just an error code.

You need to configure logging in your package and get the actual SSIS error messages.

As long as you have not specified to not use particular processors, MS SQL will use processors as it needs to. You do not have any control over it...

Some of these work ok with SQL server and some do not. Talk to your SAN vendor and make sure it is MS SQL certified and for the versions...

Here is the MS document on it:

http://www.microsoft.com/sql/howtobuy/multipleinstances.mspx

The basic idea is that (for SQL 2005) multiple instances doe not require individual licenses. Multiple virtual servers do require their own licenses.

The first thing you need to do is examine the update. I would be very concerned about any single transaction that takes 15 minutes on a live production system...