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 |
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
 Posted - 2010-03-19 : 16:36:58
|
| I have a DB with 152 tables. I used the DB Generate Script option in SSMS and it does not include the create script for all of the tables. Anybody know why?TIA,Ken |
|
|
AAAV
Posting Yak Master
152 Posts |
Posted - 2010-03-19 : 16:42:04
|
| check if you selected all the tables (use selectall). But i dont know what happens if the table is encrypted...Update: it generates in this case also. |
 |
|
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
Posted - 2010-03-19 : 16:48:25
|
| I was selecting all objects. Very odd. I went through and selected them by hand and it works. Odd. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-20 : 06:34:33
|
| Longs-shot: Tables owned by something other than dbo?? |
|
|
|
|
|
|
Generate DB Script does not include all tables