No sorry, it is a support problem in Access.

I do believe you will have to take it out of Single User Mode. I got this message myself but mine was because I forgot to start the SQL Server...

Are we going to start seeing a QOD everyday now?

Yes the order should be maintained on import from the CSV file thru DTS unless your table has a CLustered index that would cause a resort. Being however you say...

Unless that field isn't in the same table then you do something like this.

Update E

SET Lastname = T2.newlast

FROM

Employees E

INNER JOIN

table2 T2

ON

E.coltolink = T2.coltolink

So let's say you data looked like this.

1, 001, 3, 20040301, 20040302

2, 002, 7, 20040501, 20040502

3, 002, 6, 20040503, 20040504

4, 002, 7, 20040505, 20040506

5, 001, 3, 20040601, 20040602

2, 003, 4,...

Are you using a SQL Server account or trying to use a Windows Account?

If a SQL Server account then trust do not come into play. If a windows account, your...

Depending on which version of SQL and if wrapped in an SP or submitted together properly you can use

@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT

With 2000 it is better to use SCOPE_IDENTITY.

See...

EMail me as I know we have a package on one of our servers that doesn't this and does return a failure when file not found. I just didn't have...

The can be limitations in anything just depends on your design. Do you mean hunders of thousands per sec transactions or per day. And do they ahve to see each...

This will give you only the employees where theit higmanagerempid isn't in the table variable.

Select Distinct

D.employeeid

From

directory D Left Join

@temp T On

D.higmanagerempid = T.employeeid

Where

T.employeeid Is Null

Think it should be

Select Distinct

E.employeeid

FROM

(

 Select Distinct

 D.employeeid

 From

 directory...

Something like this maybe with the structure you were given to use with the extra idenitity column (which for this cannot be missing any numbers or you will get null...

If you mean details of a backup then kinda, look the following tables in msdb database.

backupmediafamily

backupmediaset

backupset

but no SPs other than to delete history and I haven't taken time to build...

If I remember correctly it is only because that is what happens at the end of the process that it get's thrown to the Job status. Try having an ON...

And here we we were thinking maybe no one cared about using it.