Try this:

create table Table1 (

    Part    char(10) constraint pk_table1 primary key,

    Descr   varchar(20),

    Sales   char(3),

    Prod    char(3)

)

create table Table2 (

    Part    char(10),

    SizeCD  char(1),

    Descr   varchar(20),

    constraint pk_table2 primary key...

Another alternative:

create table dbo.RBL (

    RABID       int,

    ChangedDate datetime,

    ItemType    char(1)

)

create table dbo.RAB (

    RABID       int,

    TAGID       char(4),

    ChangedDate datetime

)

create table dbo.s_RAB (

    RABID       int,

    TAGID       char(4),

    ChangedDate datetime

)

insert into...

This will also work, just drop off the alias in the set:

update propertydetails set

  sa_site_city = z.city,

  sa_site_zip = z.zip

from

    propertyAK.dbo.propertydetails As p

    join propertycenter.dbo.zipcodes As z

        on...

You job is probably running as sa, correct?  If so, it is running under the security context of the account running SQL Server Agent.  This user needs to have access...

If you can run the DTS packages manually, but they fail as a scheduled job, then it points to a permissions issue for the user under which the DTS jobs...

Well said Keith.

I have to agree with Ken, Joe.  After reading your response

above plus several others, you are down right mean and unhelpful.

You may be a smart SQL Server Guru and a...

Instead of a CASE statement, try this in your where clause instead:

((@BrokerType = 'NON_AFFILIATED' and affiliation.affiliatedcompanyid is null)

or (@BrokerType = 'AFFILIATES' and affiliation.affiliatedcompanyid is not null)

or (@BrokerType = 'BOTH'))

HTH,

Lynn

lost part of the post.  The where clause would be this:

where billdate >= @dt3 and billdate < @dt

again hth,

Lynn

add the following to your snippet:

declare @dt3 datetime

set @dt3 = dateadd(mm, -1, @dt)

select @dt, @dt3 --> 2006-06-01 00:00:00.000  2006-05-01 00:00:00.000

a where clause selecting on dates would...

Looking at your screen prints, it looks like your SQL Server Management Studio connection to "Kenny" is also looking at your SQL 2000 instance.  The version number showning there is...

You probably installed SQL 2000 first as the default instance.  When you installed SQL 2005, you had to install it as a named instance.  In your connection string, you are...

Your transaction log for the BossData database is most likely full.  You need to truncate the transaction log and then do a full backup of the database.

Check you disk drives...

I agree with the above comments.  A full database backup does not truncate the transaction.  Enough of the transaction log is backed up so as to create a stable backup...

There are 2 other alternatives.  The first is to write a Service program that monitors the ftp log file (a text file) looking for a successful ftp of each of...