Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Script Wizard in Sql Express 2008 -- missing objects, blow..

  
   Database Forums (Home) -> MSDE RSS
Next:  Pull records based on future date  
Author Message
serzsa

External


Since: Oct 17, 2007
Posts: 2



(Msg. 1) Posted: Mon Oct 20, 2008 11:15 pm
Post subject: Script Wizard in Sql Express 2008 -- missing objects, blowing up
Archived from groups: microsoft>public>sqlserver>msde (more info?)
I have a particular database in Sql Server Express 2008 that references some
tables on the same server in a different database. If I try to script it in
Sql Server Management Studio via "Tasks-Generate Script..." etc., selecting
all objects -- it would miss some of the objects in this same database (not
the other one). If I try to do it setting "Generate Script for Dependent
Objects" to false, then it won't script at all giving instead an "Object
reference not set to an instance of an object." error while performing
"Determining objects in database 'db_name_here' that will be scripted." task.

I wonder if anyone experienced something similar. I ended up creating a
Powershell script which I run against the same database successfully
scripting everything.

What's going on?

 >> Stay informed about: Script Wizard in Sql Express 2008 -- missing objects, blow.. 
Back to top
Login to vote
Carlos Gonzalez

External


Since: Dec 13, 2008
Posts: 1



(Msg. 2) Posted: Sat Dec 13, 2008 9:05 pm
Post subject: RE: Script Wizard in Sql Express 2008 -- missing objects, blowing up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I have a similar problem with the Script Wizard freezing in the first step
"Determining objects in database 'blabla' that will be scripted"
I am only selecting a few stored procedures and I have all the options for
dependent objects and such turned off.

"serzsa" wrote:

> I have a particular database in Sql Server Express 2008 that references some
> tables on the same server in a different database. If I try to script it in
> Sql Server Management Studio via "Tasks-Generate Script..." etc., selecting
> all objects -- it would miss some of the objects in this same database (not
> the other one). If I try to do it setting "Generate Script for Dependent
> Objects" to false, then it won't script at all giving instead an "Object
> reference not set to an instance of an object." error while performing
> "Determining objects in database 'db_name_here' that will be scripted." task.
>
> I wonder if anyone experienced something similar. I ended up creating a
> Powershell script which I run against the same database successfully
> scripting everything.
>
> What's going on?

 >> Stay informed about: Script Wizard in Sql Express 2008 -- missing objects, blow.. 
Back to top
Login to vote
Robert Heuber

External


Since: Jan 21, 2009
Posts: 1



(Msg. 3) Posted: Wed Jan 21, 2009 1:36 am
Post subject: RE: Script Wizard in Sql Express 2008 -- missing objects, blowing up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hello,

i have the same problem while creating Scripts with the MSSMS. Some Tables
will not be included in the script. The Wizard show successfull but the
scripts doesn't include the Create Table.

Ich have tested on SQLExpress2008 with Tools.

I'm glad for any hints.
Regards

"serzsa" wrote:

> I have a particular database in Sql Server Express 2008 that references some
> tables on the same server in a different database. If I try to script it in
> Sql Server Management Studio via "Tasks-Generate Script..." etc., selecting
> all objects -- it would miss some of the objects in this same database (not
> the other one). If I try to do it setting "Generate Script for Dependent
> Objects" to false, then it won't script at all giving instead an "Object
> reference not set to an instance of an object." error while performing
> "Determining objects in database 'db_name_here' that will be scripted." task.
>
> I wonder if anyone experienced something similar. I ended up creating a
> Powershell script which I run against the same database successfully
> scripting everything.
>
> What's going on?
 >> Stay informed about: Script Wizard in Sql Express 2008 -- missing objects, blow.. 
Back to top
Login to vote
rainer butzki

External


Since: Feb 05, 2009
Posts: 1



(Msg. 4) Posted: Thu Feb 05, 2009 2:08 am
Post subject: RE: Script Wizard in Sql Express 2008 -- missing objects, blowing up [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I have the same problem and no idea.

I use the SQL2008 Standard and start Tasks/Generate Script for a database.
I select all tables or all views.

It runs fine. There is no error message. But some tables/views are missing.

Hopefully someone has an idea to solve the problem.

Rainer
 >> Stay informed about: Script Wizard in Sql Express 2008 -- missing objects, blow.. 
Back to top
Login to vote
Gokhan Akca

External


Since: Apr 20, 2009
Posts: 1



(Msg. 5) Posted: Mon Apr 20, 2009 1:11 pm
Post subject: RE: Script Wizard in Sql Express 2008 -- missing objects, blowing [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
it seems to be a known bug.
http://support.microsoft.com/kb/958793/

I ran across the same problem. Tomorrow I will give SP1 a try. Really don't
know what Microsoft is doing all the day. Perhaps not enough human
resources...

"rainer butzki" wrote:

> I have the same problem and no idea.
>
> I use the SQL2008 Standard and start Tasks/Generate Script for a database.
> I select all tables or all views.
>
> It runs fine. There is no error message. But some tables/views are missing.
>
> Hopefully someone has an idea to solve the problem.
>
> Rainer
 >> Stay informed about: Script Wizard in Sql Express 2008 -- missing objects, blow.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Missing msdb - Been through a support issue with one of our users. Our software was failing during a small routine which uses the msdb database to check when selected databases are backed up by the user. Our software was reporting an error when we tried to set the..

MSDE Automatic script at each night - Can you setup within MSDE a script to be run automatically at 12:01 each night.... The script is very simple... such as "UPDATE Item Set SaleType = 0 where SaleEndDate < getdate()" Right now is run this script vi osql and a schedule batch ...

SQL Express 2005 - if this is the right group....I just installed VS 2005 and can't connect to sql express. I have read all of the posts i can find and the cmd sqlcmd -S./sqlexpress will not connect. I installed the sql Server Express manager preview 1 and that can't..

SQL Express - How does it run? - I have now successfully installed SQL Server 2005 Express Edition. When I go to Start/All Programs/SQL Server 2005 all I see is Configuration Tools Configuration Manager 2005 SQL Server Error and Usage Reporting SQL Server Surface Area..

SQL Express - something went t'up at 6:01 am :/ - Hi, Where can I find event logs for SQL Server 2005 (ie. not the transaction log, or is that the only log I need?). My test PC suddenly became incredibly slow at 6:01am, kicking off the 12 connected clients (they timed out), so I'm looking to..
   Database Forums (Home) -> MSDE All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]