SCOPE_IDENTITY() will only return the last identity value created within the current scope. In this case the stored procedure.

I'm presuming that the profile table is related to the user table...

You should also check if the databases on that server are set to auto close.

Here's a thought, how about you provide some more details on what you're doing. Table schemas, stored procedure code, type of hardware the server is running on.

Th emore details you...

You won't be able to setup your function that way.

From Books Online,

Calling User-Defined Functions

When calling a scalar user-defined function, you must supply at least a two-part name:

You're going to...

So does UsersKeywords field hold the information you're looking for in CarDescription? If so, then you'll need to store it as a local variable for this to work.

EG: declare <blah>...

Do you have to use BCP?

How many rows are you outputting?

Can you use DTS instead?

How are you executing the BCP command?

Why use a cursor? Can't this be simple UPDATE and INSERT statements?

INSERT INTO NewEmployeeMaster 
SELECT old.emplid AS 'OLD EMPLID'
  , old.SUBSTRING(emplid,1,8) AS 'NEW EMPLID' 
FROM EmployeeMaster old
  LEFT JOIN NewEmployeeMaster new
  ON...

Getting the file via FTP would vastly simplify matters. Without using FTP you'd end up with too many steps in the process that could fail. Watch for the email, extract...

With the SP3 install of MSDE 2000, the default install only communicates via shared memory, so its pretty secure in terms of outside attacks. It's only when you enable other network...

First of all get rid of the Data Driven Query task. Using this task means your data load is done one row at a time.

Import your records into a...

"... am I just barking up the wrong tree doing this?"

Ahhh ... in word ... yes.

Wouldn't having the "code more organized" remove most of your naming conflicts?

I would think...

You can do it programmatically using some creative ActiveXScript.

Here's a script I hacked together to alter the Datapump properties in our packages. It uses SQL-DMO to fetch a list of...

You could always use a few of these

http://www.pretec.com/OnlineSales/SSD/Cheetah/Cheetah_Pages/Cheetah80X_12GB.htm

A solution to this any future headaches, use xp_smtp_sendmail fro http://www.sqldev.net

This allows you to use any old SMTP server and you don't have to worry about configuring SQL Mail.

As I explained in this thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=163621

"Once the record is displayed on the users screen SQL Server is no longer involved."

You will not be able to query the record to...