Results 1 to 5 of 5

Thread: Dts

  1. #1
    Join Date
    Jan 2008
    Posts
    20

    Unanswered: Dts

    Hi

    Some help needed. I created a DTS package in SQL Server 2000.
    When I created the DTS package I was logged on with my own username.
    I then logged on as Administrator to schedule the package, but
    one of the steps keep saying Invalid object and the table name.
    If I log on with my own username the DTS package works fine, but
    when the Administrator log on and try to execute the package it says
    Invalid Object and the table names.
    Everything runs on the same server.
    Is this some sort of permission issue??
    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Yes. Who is the owner of the objects? dbo, or your login?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2008
    Posts
    20
    My login is the owner

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    When referencing objects using the one-part naming convention, the database will first look for an object by that name which belongs to that user. If it cannot find one, it will look for an object by that name which belongs to the dbo.

    So logged in as yourself, the server quickly finds the object that you are looking for that has the matching name and belongs to your schema.

    But when logged in as admin, the server will NOT look for objects owned by other schemas.

    Resolution: either change the ownership of your object to "dbo", or use the two-part naming convention to specify the owner: [Owner].[Object].
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jan 2008
    Posts
    20
    Thank you, its working now

Posting Permissions

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