generating all scripts in a db

  • Hi all, I am trying to create a script named script_H_v.1.0 that generates all objects in the database named Reporting_H .I have done this before many of times in the past without any problems. I do the usual steps in script wizard that it walks me through, save the script to a file, and let script wizard create the file. For some reason There is an error saying

    'an item with the same key has already been added'

    it fails on the very first action 'Determining objects in the database Reporting_H' that will be scripted

    None of the actions are successful. The script is not created. I have tried renaming the file, storing the file in a different location, restarting the comp. Here is the part that baffels me the most, Other users do not have the same problem as I do. They had success in generating script. So apparently I am doing something wrong. Please help thanks

    -Chris

  • Check to see if your account owns a 'duplicate' object..

    dbo.Foo

    YourAcct.Foo

    Your friendly High-Tech Janitor... 🙂

  • ok, thanks for the advice.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply