3
Vote

Object reference not set to an instance of an object. (SqlPubWiz)

description

===================================
 
Object reference not set to an instance of an object. (SqlPubWiz)

 

Program Location:
 
at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptTableCommand.GetSqlDataType(Column column)
at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptTableCommand.CheckSupportedType(Column column, ScriptingOptions options)
at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptTableCommand.Script(Urn objectToScript, ScriptingOptions scriptOptions)
at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptProcessor.GenerateScript()
at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptingEngine.GenerateScript()
at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptingDriver.GenerateScript()
at Microsoft.SqlServer.Management.SqlManagerUI.GenerateScriptMaker.DoScript()
at Microsoft.SqlServer.Management.SqlManagerUI.GenScriptWizForm.Script()

 

From .Net Reflector probably you do not support User Defined Types.
Do you guys use something like FxCop or ReSharper they help to remove such stupid issues. Anyway your public methods SHOULD check input, not sure how you will find issue root cause with this exception message.

comments