Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham, UK
    Posts
    37

    Question Unanswered: Error trying to copy stored procedures from one db to another

    Hello,

    The export menu in DTS is a bit confusing for me. I have some stored procedures in one SQL Server and want to copy them to another. The username is the same for both SQL Servers. When I try copying the stored procedure with defaul settings, I get a progress bar (24 percent ccompleted, 62 percent completed...), then when its done it says "failed to copy objects from sql server to sql server". When I double click the error for details it says "User or role '[username]' already exists in the current database". Then I try again, unchecking "use default options" for my export. I go in to alter the options, uncheck "copy database users and database groups" (I've also tried unchecking "copy object-level permissions"), run it, get progress bar (like above), and then get another error that says "There is no such user or group '[username]'".

    My user name is correct, I am able to access both Sql Servers with this username, and I should have all of the appropriate permissions.

    I think maybe there is a checkbox I'm not unchecking or something stupid like that.

    Thanks in advance for any feedback.
    ----
    system:
    Mac Powerbook 1GHz

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    Wild guess here: the user who owns the sp is not dbo ?

  3. #3
    Join Date
    Jan 2002
    Location
    Nottingham, UK
    Posts
    37

    Exclamation um, can you elaborate?

    Quote Originally Posted by Kaiowas
    Wild guess here: the user who owns the sp is not dbo ?
    Sorry, your msg is a bit cryptic for me. What are "sp" and "dbo"? My guess on the latter is "database owner". I will check with the administrator to find out if I can get a username with more privileges. It is a shared Sql Server with a web hosting company and there are dozens of databases that I can see in there, but do not have access to, so users and permissions are a little hairy, i'm sure.
    ----
    system:
    Mac Powerbook 1GHz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •