Maybe ...

DECLARE @AccountID INT

SET @AccountID = 9290

SELECT A.AccountName, ISNULL(A2.AccountID, 0) AS 'RelAccLocalID', ISNULL(A2.AccountName, ''), ATypes.AccountTypeID,  
 ATypes.AccountTypeDesc
FROM Account A  INNER JOIN AccountTypes ATypes ON A.AccountTypeID...

Edit the DTS package and turn on Package Logging and you'll get a much more helpful error message.

Hmmm ... I thought my solution was set based and it didn't require the generation of an extra table.

Was I wrong ???

Maybe you've over simplified the code you've posted, but I'd just replace all that with,

INSERT INTO TABLE1 (Column1,Column2,Column3)
SELECT Column1, Column2 FROM Table1 WHERE Column3 = 1

Check this link for a script.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=16068&p=2

raj, unless you're running a different system to everyone else I'm sure you can't retrieve the service accounts via sp_who.

No you can't use the IN like this.

Without seeing the whole query and tables involved, here is how I might tackle the problem.

Left join from the table you're updating to...

Wouldn't this be a case of using the non-ANSI Double FROM and using a derived table.

Delete from Mytab
from Mytab as a
    inner join (
      select Road, MainRoad 
      from...

You won't be able to use the SQL Agent Mail functionality to send out notifications unless you install a MAPI client.

As mentioned save yourself some hassle and take a look at...

I believe these tables are also used with Visual Studio ( maybe for the source control part?? ) and the diagramming in Enterprise Manager.

Short answer don't remove them.

Hmmm ... the ever reliable Books Online reveals this,

datetime and smalldatetime

datetime

Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of...

I'm seeing frequent use of the word "loop" in your pseudo code. Hopefully this doesn't translate into a cursor

Here's how you can move...

If you want to use SQL Mail as is then you'll need to install Outlook, or another MAPI email client. You can also setup SQL Mail using POP/SMTP email client, but...

"We no longer need the MSX/TSX setup on our db systems..."

I suppose that's your call to make, but having a MSX/TSX setup makes for much easier administration and maintenance, even...

You can check the list here http://www.file-ext.com/character.html

Whether you'd use them or not is another matter. I'd stick with the underscore character split up the parts,

EG: master_db_20051005_1750.bak