copy SQL table from one database to another programmatically

Question

Hi guys, I am newbie in .net and SQL. I need to copy some of tables from central database to user machine database programmatically depending on the user logged in. I am using vs .net 2003 , C#, MS SQL server 2000, ADO.NET Could you please tell me best way to copy those tables to user machine database. Thanks, mohan

Answer 1

I managed to resolve the issue by deleting a phantom user (It was a people icon with a ? mark.  I've never actually seen it before) in the Remote Desktop Users screen and then rebooting the server.  I suspect this may have been causing a problem with the remote connection; although the error message definitely wasn't pointing that way.  Thanks for your help and suggestions.  You pointed me in the direction of looking at the permissions.

Answer 2

I would still check the permissions on the folders/files you are trying to access through your code.  Check the permissions on a server that is working verses the one that isn't.  Even if you are using Administrator, the permissions could still be off, I know just from experience.  Good Luck

Answer 3

I had thought that might be the issue, too, but the id I'm using to get in is an Administrator.

Answer 4

The only thing I can think of is that there might be some permissions error on that one server.