CREATE

TABLE [dbo].[PreloadedCustomer_Total2](

[cifid] [int]

NULL,

[company] [varchar]

(100) COLLATE

Yes, I am sure the userid and password are correct.  I'm using the same that I have personally in my Outlook settings.  I've also tried using the administrator mail account...

I did verify basic authentication is enabled.  And I reset the password for the account I'm using for authentication to be sure I have it set correctly.

Here's what the support...

Joe,

Thanks for the info.  I did try as you suggesting running the sproc without the '@domain.com' and still get the same error message:

The server response was: 550 Authentication is...

Here's a snippet from the smtp log.  It seems obvious that it is not authenticating.  I don't understand why when I set authtication on and supply a userid and password...

I even asked our hosting company to SMTP authentication bypass for my ip address.  Still, I have had no success getting email to send when sending to an email address...

Why not fully qualify your table names?

I've found the identity column useful when business rules change.

For example, a business rule at the start says a repair order number will *never* be reused/duplicated.  Many years down the...

That link doesn't seem to work.

am,

I agree with mrpolecat.  It is much easier to help someone out when all the code is posted.  Others on the forum are much more likely to respond if you...

Sugesh,

Thanks for your reply.

The response I got from our network admin in response to the firewall was that the firewall isn't an issue in this case.  It's not checking for...

Hi Bob,

Hope this works for you.

Kim

--create test table in tempdb

Use tempdb

CREATE TABLE [TestData] (

 [PKID] [int] IDENTITY (400, 1) NOT NULL ,

 [OtherID] [int] NULL CONSTRAINT [PK_APPEALS] PRIMARY KEY  CLUSTERED

 (

  [PKID]

&nbsp

Ignore this post.

Prasad,

You rock!! Many thanks.  Now I can relax over the holiday week-end knowing this is taken care of 😉

Thank You, Kim

Final code ignoring the first row which shows the column...