dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Script Wizard in Sql Express 2008 -- missing objects, blowing up - sqlserver-tools

This is a discussion on Script Wizard in Sql Express 2008 -- missing objects, blowing up - sqlserver-tools ; 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 ...


Home > Database Forum > Microsoft SQL Server > sqlserver-tools > Script Wizard in Sql Express 2008 -- missing objects, blowing up

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-21-2008, 02:15 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Script Wizard in Sql Express 2008 -- missing objects, blowing up

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?
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 12:13 PM.