Quomon - SQL Server 2000

change owner of objects in ms sql server

dustPuppy — Fri, 20 Oct 2006 20:00:36 GMT

I need to change the owner of a table in my ms sql server 2000 database.
How do I do that?

sql server 2000: Generate insert scripts for data?

theDude — Sun, 15 Oct 2006 00:54:47 GMT

Hi,

I know it isn't possible via the sql server enterprise manager to generate insert scripts for the data in the database. But there must me some thirdparty tool that does this, I just didn't find any yet.
Can you recommend one?

Thanks,
theDude

A server with this name already exists - sql server 2000 problem

Anpanman — Thu, 03 Aug 2006 19:55:32 GMT

In the enterprise manager for ms sql server 2000 I'm trying to configure access with two different users on the same server. Each user has access to a different database.
The first was no problem, but when I try to add a new server (which is the same as an existing one) with the other user login, I get the error message "A server with this name already exists".
How do I get around this problem?