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.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Scripting all database objects - problem!!

Author  Topic 

jtcedinburgh
Starting Member

4 Posts

Posted - 2008-09-10 : 08:24:31
Can anyone advise? When I script all via Tasks | Generate Scripts (with 'Script all objects in the selected database' checked) I find that the resulting scripts miss things - in my case the most notable is one of my tables.

I can't understand what's happening, as the table in question is in the list of objects that SS2008 is scripting, and it ends up with a green tick which suggests success, but it is nowhere to be seen in the resulting script and as a result some of the dependent objects obviously fail to be added when the script is executed.

Does anyone know if this is a known bug and if so, if a fix is available or perhaps I am doing something wrong but I have checked and double checked my choices and everything is (AFACT) exactly as it should be.

Help!!!

Thanks,

John
   

- Advertisement -