Where exactly are you putting it? What line?

You Can't get the value of @@Error?

Regards,

Welsh

That is weird.

I don't know how it could be skipping it but perhaps you could try putting a SELECT or Print Statement just before the EXEC Statement.

After the last argument...

Sorry double post...:w00t:

Have you checked to so if it is in the queue but not sent?

http://msdn.microsoft.com/en-us/library/ms190630.aspx

I thing that you should reconsider the following:

How did you determine that there should be only one user? Is this a Windows application or a Web Application?

Whether you have one...

If this is in Oracle then you should probably be using PL/SQL and posting your question to an Oracle Forum.

You can use sys.dm_exec_sql_text or the DBCC INPUTBUFFER command to quickly identify what command is being executed.

You may want to try killing the SPID in Query Analyzer.

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/d1dbb675-ce11-4797-91f5-fa4940c3b27e/

http://msdn.microsoft.com/en-us/library/ms187730.aspx

http://www.sqlservercentral.com/Forums/Topic457115-146-1.aspx

After storing your scripts on a folder that gets backed up I would immediately store them in a Source Control Program.

You should be using WSUS to manage you updates and hotfixes.

If you have to do it manually "without WSUS" then you have to do check the current SP Level and...

I have been waiting for 40 minutes on this machine :-)so far and the download does not start.

If you do not not know what the business requirements how can you write a query that satisfies the business requirements.

You stated that:

"Unfortunately I don't know all of the business rules about when clientkeys and masterclientkeys are assigned, but my observation has been ..."

What part of the business rules...

You might want to be a little more specific as to the results that you want to return.

I believe that you will need to write this in the Script Task and use the Excel Object Model to create the worksheets that you need.

I'm sorry but I do not follow the Business Logic....