Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | napoleonxvStarting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2007-09-06 : 02:33:39 
 |  
                                            | I am wanting to create a script for my database structure.  From Management Studio, I right-clicked on the database and did "Tasks->Generate Scripts". When I did so, I got a list of databases to select for scripting -- but the database I had clicked on wasn't in the list, only the predefined databases (master, model, etc.)  This happened both when I logged in as a user that I created (mapped to privileged roles) and as 'sa'.  Why would my database be missing from the list? |  |  
                                    | kishore_penStarting Member
 
 
                                    49 Posts | 
                                        
                                          |  Posted - 2007-09-06 : 03:49:06 
 |  
                                          | I've developed one utility related to this, using this utility, you can generate entire database DDL script.  It is developed in VS 2005 and SQL 2005.  If you are interested, download the utility from <<http://www.ipdg3.com/sourcecoderesults.php?option=sourcecode&id=000594>>.:) |  
                                          |  |  |  
                                |  |  |  |