GSquared (12/21/2009)

Intelligence usually isn't the issue....

To fix your orphan users:

EXEC sp_change_users_login 'Auto_Fix','YourUser'

Can you post the explain plan?

I think these individuals who are asking the questions are probably intelligent. However, they just don't know the language to ask their questions correctly.

This article answers your question and yes..I realize this thread is over a year old.

http://support.microsoft.com/kb/918760

Google can provide with a more detailed response.

Nevermind...I misread the post.

You would think ZIP would be enough but you don't know my users and how they can't be bothered to input that data.

Here is what I have for a...

CREATE TABLE [dbo].[Project](

[projectID] [int] NOT NULL,

[name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[projectNumber] [char](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[statusID] [smallint] NULL,

[statusDate] [datetime] NULL,

[lostWonReasonID] [smallint] NULL,

[scheduleDifferenceInWeeks] [decimal](18, 0) NULL,

[cema] [bit] NULL,

[salesmanID] [int] NULL,

[siteID] [int] NULL,

[shipToAddressID] [int]...

Check that the machine is on the domain and that you can access your SMTP server from the SQL Server. Open telnet and go to whatever address your smtp server...