transferring amended database

Hello

Background
I have a local database I am trying to transfer unsing DTS, but it's either failing to work. I already have a database hosted with DiscountASP and would like to put another couple of tables up there with the associsated stored procs only I am having a spot of bother. I get this:

[Microsof][ODBC SQL Server Driver][SQL Server]Specified owner name 'Fairplay' either does not exist or you do not have permission to use it.

Some tables and stored procs have this 'Fairplay' owner attached to them although I have specified not to copy owners etc as per the article.

Or, when I thought it had worked, none of the table data went up or the stored procs even though I had select these objects?

The first time it cleared all the data in existing tables and I had to put it all back...nightmare!

So what I need to know is: How to copy the tables I want up that are new with data and stored procs. regardless of who the owner is locally?

Anyone got any helpful hints.

Many thanks

Angel

/emoticons/rolleyes.gif

 

Hi,
The methods I would use for this would be to run SQL Server locally as an admin with full rights.
Then use T-SQL to change the owner as needed.
http://msdn.microsoft.com/en-us/library/ms178630.aspx

Hope that helps, if not let meknow.
Salute,
Mark

 

so sorry not to reply.


I managed most of it.....just the last couple of roles/membership stored procs...not working....