You can also try:

a.CustomerID = b.CustomerID and a.LocationID = NULLIF(b.LocationID,'')

Andy

Here is a C#, VB, C++ .NET example:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemiofilesystemwatcherclasstopic.asp

Andy

Lookup sp_add_job* on BOL (Books Online).

Andy

Create the "database" in dBASE IV and import the data into that table.

Or edit the transform of the database creation defaults in EM before you run the export.

There will...

Save your money for 2005, most of the 2003 tools are all but dead. 2005 should be shipping in a couple of weeks...

As others have shown, install IIS 5 from...

Short answer, don't Windows login from ASP, Use SQL Server login instead:

ASP

http://support.microsoft.com/default.aspx?scid=kb;en-us;307002

ASP.NET

http://support.microsoft.com/default.aspx?scid=kb;en-us;316989

Andy

Add:

Installed Outlook with CDO option (must use Custom install for Outlook and choose to install CDO as CDO is not installed for Typical install).

Changed SQL Server Agent service account to...

I see that Microsoft is saying that SQL Server 2000 post sp4 patches will be available from Microsoft Update or WSUS, so maybe you should talk to your OS patch...

So did you restart the machine and try again, as the error states?

Also check out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312995

Andy

Does the problem box have the BUILTIN\Administrators account as sysadmin? Check out the KB 317746 article.

Andy

You can also define Simple for new databases by modifying this setting on the model database (the basis for all new databases).

Andy

You should also investigate your Windows OS, XP does not have a server edition, it is effectively a workstation OS, and SQL Server 2000 only supports the Developer Edition on...

You should verify the SQL Agent Properties on the Connection tab, to insure that this is not set for sa, otherwise you will have to change the password here as...

I don't think that ABS is going to fix the design issue, only mask the error. What if:

last_Name = 'Do' and first_name = 'Robert Henry

last_Name + left(first_name,ABS(len(last_name)-9))

Would result in 'DoRobert...

Since SQL Server will have no problem converting a char(4) to a varchar(4) including existing data, use:

ALTER TABLE TableName ALTER COLUMN 

   Name varchar(4) NOT NULL

UPDATE TableName SET Name = RTRIM(Name)

This last part...