Sorry you did not set your savepoint properly.

You did

BEGIN TRANSACTION tr

needs to be

SAVE TRANSACTION tr

to set transaction savepoint within a transaction. Remember a trigger event occurrs within the same transaction...

The connector you are using for Sybase is not of a compatibility for SQL 2000 I would think. Is this Sybase running under windows? If so then you should be...

No, but you can only install the desktop edition and logins will be SQL Server only. Are you getting a specific message though that is not to that effect (could...

Try the follwoing format if you have a unique item key (not primary key, I mean column or comibnation of columns that are unique) and the table will be ordered...

Can you post what you have done including the process that started the transaction?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Per zishanz in thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3430&FORUM_ID=23&CAT_ID=2&Topic_Title=bcp%20/%20how%20to%20run%20bcp%20from%20within%20a%20sp&Forum_Title=General

quote:

---

Can I use xp_cmdsehll inside my stored procedure?

The book(Microsfot SQL Server 2000 DBA Survival Guide) p 409 says:

'Do...

No I believe sackerdj is referring to the english query dictionary which I haven't looked at yet. Look at dictionary entries in BOL.

"Don't roll your eyes at me. I will...

Anything you read will apply as a general, yes #1 is backups. But all the books and all the information will not help you as much as experience. The #1...

Okay how are you going about what you are doing. Also have you tried free running thre procedure and watching the server from Profiler to see if anything odd is...

Also could be a compatibility issue, saw a couple of articles on MS KB site about SQLMail/SQLVersion with Outlook versions.

"Don't roll your eyes at me. I will tape them in...

Prints are handled when processing is complete. You might try instead

SELECT @cntvar

this might work but not tested.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

This should fix.

SELECT @Note_10 = @Note_10 + CAST(WONo AS VARCHAR(5)) + ', ' FROM PELDMS.dbo.ImportLog1 WHERE Profile = @Profile_3

"Don't roll your eyes at me. I will tape them in place."...

Or even then you could create a job for the DTS package that is not enabled and issue a sp_start_job to kick it off in a trigger (but you will...

Here is the email he sent back to me if anyone wants to throw in, haven't said anything myself yet.

Dear James,

        Thanks for your response,since i am a new...

This will give you the exact same output

-----------------------------------------------------

SET @Note_10 = @Note_10 + '----'

SELECT @Note_10 = @Note_10 + WONo + ', ' FROM PELDMS.dbo.ImportLog1 WHERE Profile = @Profile_3

----------------------------------------------------------------------------------------------

As this

----------------------------------------------------------------------------------------------

DECLARE ActiveSDG_Cursor...