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...

Only you can see your database, so it's up to you to investigate what's causing the problems and hence whether the best solution would be batching, rescheduling, rewriting, upgrading or...

Is there any reason to leave them in the old compatibility mode? If there isn't, you ought to bring them all up to date to take advantage of the...

That makes me suspect that your existing databases have a low compatibility level - SQL Server 2000 (80), maybe?

John

Yes, just do your preparatory work and then run the exe. It's not easy to back out of. You'd need to reinstall SQL Server and then reapply the...