In that case, this should also work. It has a very similar execution plan to Dave's. That's only for a very small table, though - your mileage may...

Yes. Take the example given on that page and modify it with your table name, columns names and computation. Post...

Ben

Timestamp is deprecated - you should use rowversion instead. If you insist...

Does your table have a primary key constraint, please? I can't see a way of writing a robust query without one.

John

Have you considered merge replication?

John

Something like this?

SELECT * FROM Patients

WHERE @AsAtDate BETWEEN >= ToDate

AND @AsAtDate < LEAD(ToDate,1) OVER (PARTITION BY PatientID ORDER BY ToDate)

As Alan said, please provide full table DDL and sample data...

Type "application role" into your favourite search engine. The first few results will probably tell you all you need to know, but if there's anything in particular that you...

I don't know about forms, I'm afraid. But if you give SELECT access, the user can get to the data. Even if you secure the forms, he can...

Rami

I imagine this isn't what you're looking for, but I'm finding it difficult to understand your requirement. If a user can see the data in a table, he can...

If you add 1003 and 1004, you'll get 2007. If you want to preserve the two values, you'll need to do something like this:

Insert into Table1 values(1,1000);

Insert into Table1...

If you're doing it from a command line, use RunAs to run as a different user. I've a feeling that only works interactively, however - you'll need to investigate.

John

If you're scheduling a backup, you need to provide the password in the connection string - you can't pass it in interactively.

The error message isn't saying you don't have rights...

I've seen messages like this in connection with password expiration. I think it occurs when someone attempts to connect with a Windows login whose password has expired.

John

Stuart

You need to read about cross-database ownership chaining. Please post back if there's anything you still don't understand.

John

Mmmm, interesting. The documentation does say unequivocally that the database can't be moved. I've moved it in the past, though. Maybe it ought to say instead that...