Results 1 to 5 of 5

Thread: DTS utility

  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Cool Unanswered: DTS utility

    Hello,
    I am using the DTS utility available with Enterprise Manager in MSSQL server 2000. I can transfer the tables and views without any issues but when i try to transfer the stored procedures it always gives an error. I have tried transferring individual objects too but it does'nt works. The error given is "the user <username> cannot perform the following action". Any help is appreciated.
    Thanks in Advance

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Easy is to script them and run at target server.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I always liked Nigel's sig...

    ==========================================
    Cursors are useful if you don't know sql.
    DTS can be used in a similar way.
    Beer is not cold and it isn't fizzy.

    http://www.sqlteam.com/forums/pop_pr...isplay&id=1578

    And what that basically means, is what your are fundamentally trying to do is not the best way to skin a cat...

    You need to undestand the methodolgy of deployement...

    If you describe what you are ultimatley trying to do, I'm sure we can help..
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    On the lighter side Brett conveyed the message....
    On the hardest part I feel DTS must be used for data transfer and for this sort of things use Generate Script utility.

    Also one of my peer raised this may be a security issue, so convey the permissions for this user on database objects.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Feb 2004
    Posts
    5

    Talking

    Got the point guys!!! I used the generate script utility, it is easier and without any issues.
    Thanks

Posting Permissions

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