Never done this but have you checked the code that returns jobStatus is working OK!.

IS your code running too soon? CurrentRunStep will return 0 if the job step is...

Interesting! What about SQL7, 3 x 18GB drives, 1 controller, RAID5. 2 Logical drives, C: (4GB) for OP Sys, D: (30GB) for SQL. Is this bad practice?

Why not check if row exists in destination table before insert. This is what I do.

I think Antares686 is right. Have you no backup of master prior to rebuild?

However, having a really surreal idea.

MAKE A COMPLETE BACKUP OF SQL (Master,etc.)

Make copy of the DAT file...

Is the error display from your app?

Error 1004 can be caused by trying to open xls with older version of Excel than the one used to create it!

Try looking at the following topic, I believe it holds your answer.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7690&FORUM_ID=8&CAT_ID=1&Topic_Title=declaring+variable&Forum_Title=T%2DSQL

Never done this so not much help. However when I have had problems with transferring apps to server where they don't work but do on my workstation. The only advice...

Don't know what ERWin is.

This may sound obvious but when I want to send people my Visio database diagrams I convert them to Acrobat via printing.

The use of IN/NOT IN with sub queries seems to be a common theme.

I have found LEFT OUTER JOINS to be a lot faster than NOT IN (SELECT...)

I would try...

I agree with Oleg.

I do not why you get spaces, I do not (SQL 7) unless it is part of your data.

If you want to format the data then you...

Hi,

Interesting topic this one. When I was a trainee programmer (many many moons ago), I noticed that companies would employ a freshman straight out of college/university with A Levels in...

I have had similar problems like this and have used the following approach. I do not if it will work and give you the results you want or how it...