ODBC datasource on the PC, check the configuration in there and you should be able to get this working.

Control Panel --> Admin tools --> Data sources (ODBC)

Is the user swapping pcs when they move to the second office, or moving their pc?

It looks like it cannot find the ODBC data source, is this...

This code will get you the max start date for each unique User_Id

Select User_Id, Max(Start_date) as MaxDate

From Users

Group by User_Id

Order by MaxDate desc

If you want to remove individual objects from replication then you can uncehck them in the articles tab of the publication properties.

But as the other poster said it is probably...

Oaky thanks for that, looks like i will need another sql 2005 license.

Thanks,

We are running a database mirroring setup between two servers, and I am using one SQL express server as witness for this, I wanted to know if it...

Shrinking the Temp db requires that there is no activity on the temp db which can be difficult on a production server.

If you are sure there is no activity then...

There a few differences, but the main one is that Bulk Insert is a T-sql command, and BCP is a command line program

Check BOL for the...

Are you after a query or funciton

for a query

select COLUMN from TABLE where COLUMN is null

Let me know what you are trying to acheive and i can offer further...

at a guess

Declare @UserId int

Declare @CompanyId int

Select CompanyId, AuthrolID, UserID

from YourTable

where (Aurhrolid = 3 and CompanyId = @CompanyId) or (Aurhrolid = 1 and UserId = @UserId)

Really? I thought this part of the OP implied that the data would need to be kept...

a State 16 error will be thrown if the database declared in the connection string is unavailable.

So it looks like a connection is being made in the application somewhere...

No, backing up of transaction logs every 15 minutes will not affect replication

You can edit your the SQL that you use to access your data source to include a where clause.

Or you can use a conditional split data flow transformation...

export the DB to...