The shipto datatype is nvarchar

Oh and the data type is nvarchar.

No the Charindex returns the same result set. The  one thing that the results have in common in the characters O and E. Strange because the look the same.  The Colation...

Things to

Are you able to execute XPsendmail?

Is the MapI Profile for SQL set as default on the server?

If you have outlook installed can you open that first?

Is the serevice account running as...

My understanding is that SQL 2000 standard can address 2gb memory. End of story. But, Its wise to have more for the O/S.

Yes that is another problem that I need to resolve. Please elaborate. I'm not quite sure what you mean.

Out standing. Thanks everone for your help.

I;m sorry for my ignorence. Both ideas seem great but, I'm having trouble applying them in my current statement. Where in the current proc can I apply these methods and...

Okay, I'm not sure where I can do that in this instance. Take a look.

Here is the proc that creates the query

DECLARE @CustomTableColumnID AS UNIQUEIDENTIFIER

DECLARE @ColumnName AS VARCHAR(255)

DECLARE...

Here's what I would suggest. First goto services under control panel. Then open the mssqlsqlserver  service. Then try setting the login to the local service accout and try starting again....

Man. you rock. that seems to be working pretty well. Unfotunalty I have 500 + tables to create this on. Is there a way to speed that up to create...

cool cool, but how do I determine if the transaction was inserted, updated or deleted?How do I capture that value to a tx_table?

Thank you so much..,.

Hey thats great but can I build this into a single trigger? That's where I'm really having a big problem.

Thank you

Thank you, Sorry that was posted 3 times.

j

right on.

Thank you!