Posted by Erland Sommarskog on 01/29/07 22:36

javelin (google.1.jvmail@spamgourmet.com) writes:
> There are two requirements here, the first being the need to restore
> tables to a different server than the backup originated from without
> messing up mapping of server logins.

As I said, this can be handled with sp_change_users_login, please
see Books Online for details.

> The second is the need for a user to work remotely on one single table
> without implementing fancy database features, such as replication.

Have you looked at bulk copy? There is also some Import/Export GUI
stuff in Enterprise Manager that I have never used myself.

> Why not? Because the DBA is a real "P.I.T.A.", and there's no way to
> convince him he's wrong!

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Paging records on SQL server using derived tables : more question
• Prev in forum: Bulk insert rollback
• Thread view: Re: backup/restore of Tables ONLY (please)

[Reply to this message]