Hello,
Today I received this error when trying to alter a table in Toad 5.0.0.444. What
is curious is just successfully altered the table and went back to do another
modification and received this error. I probably should also mention that this
table has a column in it that is of the xml datatype.
Quest.Toad.SqlServer.Trl.TrlHasEmptyResultSetException
FastTable.Rows.Count = 0, FastTable.Columns.Count = 59 for:
sqlserver://@FNBZDEV/TABLE/Sales/TEST_SalesOrders//dbo/PROPERTIES
Stack Trace:
at Quest.Toad.SqlServer.Trl.BaseObjPropertiesTrl.getProperties()
at Quest.Toad.SqlServer.Trl.Tables.TablePropertiesTrl.get_SystemTable()
at
Quest.Toad.SqlServer.Doe.Tables.TableProperties.OnTablePropertiesLoaded(TablePropertiesTrl
tablePropertiesTrl)
at Quest.Toad.SqlServer.Doe.Tables.TableProperties…ctor(String locator,
IConnection connection, EnumActionType actionType, EnumInitialOptions
enumInitialOptions)
at Quest.Toad.SqlServer.Doe.Tables.TableEditForm.Initialize()
at Quest.Toad.Doe.BaseDoeForm.BaseDoeForm_Load(Object sender, EventArgs e)
at Quest.Toad.Doe.BaseDoeForm.PreShowInitialize()
at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, UIActionEntry uiEntry, ITrl[]
trls, Object customModeTag)
at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, ItemClickEventArgs e, Object
customModeTag)
at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, ItemClickEventArgs e)
After a restart of the application I was able to alter the table. But still is
strange because I had Toad open for about 10 minutes prior to encountering this
issue.
Thanks,
Kent
Kent Maxwell
Business Analyst
TISSUE SYSTEMS
…
…
Fabio Perini North America, Inc.
3060 S. Ridge Road • Green Bay, WI 54304
P.O. Box 28380 • Green Bay, WI 54324-0380
Phone: (920) 339-2673 • Mobile: (920) 619-3221
Fax: (920) 338-4315
E-mail: kmaxwell@fabio-perini.com
Internet: www.fabio-perini.com
Skype: kentmaxwell
…
…
This e-mail may contain confidential and / or privileged information. If you are
not the intended recipient (or have received this e-mail in error) please notify
the sender immediately and destroy this e-mail. Any unauthorized copying,
disclosure or distribution of the material in this e-mail is strictly forbidden
