2k5 Management Studio Object Explorer Error

Receiving the enclosed error when attempting to connect to a server and
browse. (the Object Explorer works fine when browsing 'local' server). I
have tried this with two different installagions of 2k5 with the same result
s.
Also the 'Summary' pane will allow drilling up and down.
Is there a work around'
Thanks in advance
GH
SS Version: 09.00.1187
Error Info:
TITLE: Microsoft SQL Server Management Studio
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
ADDITIONAL INFORMATION:
Insert Error: Column name or number of supplied values does not match table
definition. (Microsoft SQL Server, Error: 213)
For help, click:
http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
=============================
***** Advanced Information ***********
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
query)
at
Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(Execut
eSql execSql, String query)
at
Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollecti
on query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType
resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb
)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlE
numResult sqlresult, ResultType resultType)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
result)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(
Request req)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[
;]
fields, OrderBy[] orderby)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[]
fields, OrderBy[] orderby)
at
Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String[
;]
fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
allProperties)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
propname)
at Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentProperty
Handler.SetTsxInformation(Server server, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentProperty
Handler.PopulateProperties(INodeInformation
source, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.P
opulateProperties()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.SetStaticProperties(NodeContext nodeContext)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
Builder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem
.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHiera
rchyNode.BuildChildren()
===================================
Insert Error: Column name or number of supplied values does not match table
definition. (.Net SqlClient Data Provider)
For help, click:
http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
Server Name: a-rogerp-sql01
Error Number: 213
Severity: 16
State: 7
Procedure: sp_get_sqlagent_properties
Line Number: 162
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bjec
t
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
sqlCommand)Hi,
One possible cause of this error is that when you are connecting
remotely that you are using two different builds of SQL Server 2005.
There are incompatibilities between some builds.
Are the SQL Server 2005 builds the same on each of the machines? If
not, the workaround is to use the same build on all machines.
Andrew Watt
MVP - InfoPath
On Tue, 1 Nov 2005 12:18:04 -0800, "GH" <vakar@.community.nospam>
wrote:

>Receiving the enclosed error when attempting to connect to a server and
>browse. (the Object Explorer works fine when browsing 'local' server). I
>have tried this with two different installagions of 2k5 with the same resul
ts.
>Also the 'Summary' pane will allow drilling up and down.
>Is there a work around'
>--
>Thanks in advance
>GH
>SS Version: 09.00.1187
>Error Info:
>TITLE: Microsoft SQL Server Management Studio
>--
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>ADDITIONAL INFORMATION:
>Insert Error: Column name or number of supplied values does not match table
>definition. (Microsoft SQL Server, Error: 213)
>For help, click:
>http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
>=============================
>***** Advanced Information ***********
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>Program Location:
> at
>Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
>sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
>query)
> at
>Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(Execu
teSql execSql, String query)
> at
>Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollect
ion query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType
>resultType, StringCollection sql, Object connectionInfo, StatementBuilder s
b)
> at
>Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(Sql
EnumResult sqlresult, ResultType resultType)
> at
>Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
>result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
>erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.GetData()
> at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
>Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
>connectionInfo, Request request)
> at
>Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader
(Request req)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String
1;]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String
1;]
>fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
>allProperties)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
>propname)
> at Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName(
)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropert
yHandler.SetTsxInformation(Server server, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropert
yHandler.PopulateProperties(INodeInformation
>source, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.
PopulateProperties()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
mBuilder.SetStaticProperties(NodeContext nodeContext)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
mBuilder.BuildDynamicItemWithQuery(IList
>nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
>Boolean registerBuilder, Boolean registerBuiltItems)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
mBuilder.BuildDynamicItem(IList
>nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
>filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
mBuilder.Build(INodeInformation
>source, INavigableItem sourceItem, IFilterProvider filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIte
m.GetChildren()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHier
archyNode.BuildChildren()
>===================================
>Insert Error: Column name or number of supplied values does not match table
>definition. (.Net SqlClient Data Provider)
>--
>For help, click:
>http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
>--
>Server Name: a-rogerp-sql01
>Error Number: 213
>Severity: 16
>State: 7
>Procedure: sp_get_sqlagent_properties
>Line Number: 162
>
>--
>Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>exception, Boolean breakConnection)
> at
>System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bje
ct
>stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
>SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
> at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds
,
>RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
>DbAsyncResult result)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
>behavior, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
>Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
>sqlCommand)|||If you are using the RC/RTM build to connect to an earlier build like the
September CTP or earlier you'll get this error. Make sure all your
servers/tools are on the same build
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"GH" <vakar@.community.nospam> wrote in message
news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
> Receiving the enclosed error when attempting to connect to a server and
> browse. (the Object Explorer works fine when browsing 'local' server). I
> have tried this with two different installagions of 2k5 with the same
> results.
> Also the 'Summary' pane will allow drilling up and down.
> Is there a work around'
> --
> Thanks in advance
> GH
> SS Version: 09.00.1187
> Error Info:
> TITLE: Microsoft SQL Server Management Studio
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> ADDITIONAL INFORMATION:
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (Microsoft SQL Server, Error: 213)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
> =============================
> ***** Advanced Information ***********
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(Strin
g
> sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
> query)
> at
> Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(Exec
uteSql
> execSql, String query)
> at
> Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollec
tion
> query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType
> resultType, StringCollection sql, Object connectionInfo, StatementBuilder
> sb)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(Sq
lEnumResult
> sqlresult, ResultType resultType)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
> result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
> erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.GetData()
> at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
> Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
> connectionInfo, Request request)
> at
> Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReade
r(Request
> req)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String&#
91;]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[
]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String&#
91;]
> fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
> allProperties)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
> propname)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentProper
tyHandler.SetTsxInformation(Server
> server, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentProper
tyHandler.PopulateProperties(INodeInformation
> source, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext
.PopulateProperties()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.SetStaticProperties(NodeContext
> nodeContext)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.BuildDynamicItemWithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery,
> Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.BuildDynamicItem(IList
> nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
> filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
emBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableIt
em.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHie
rarchyNode.BuildChildren()
> ===================================
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?Prod...13&LinkId=20476
> --
> Server Name: a-rogerp-sql01
> Error Number: 213
> Severity: 16
> State: 7
> Procedure: sp_get_sqlagent_properties
> Line Number: 162
>
> --
> Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bj
ect
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
> at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
> ds,
> RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
> DbAsyncResult result)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(Strin
g
> sqlCommand)
>
>
>|||Thanks Guys ..
I am connecting to Sept CTP versions ..
It appears this build (Sept CTP) has a characteristic different from the
previous ... It throws this error if the remote server has not been
registered prior to attempting the connection ...
I am continuining to test this.
Thanks for your assistance
GH
"Jasper Smith" wrote:

> If you are using the RC/RTM build to connect to an earlier build like the
> September CTP or earlier you'll get this error. Make sure all your
> servers/tools are on the same build
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "GH" <vakar@.community.nospam> wrote in message
> news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
>
>|||Hi,
How about the results of your testing? I wanted to post a quick note to see
if you would like additional assistance or information regarding this
particular issue. We appreciate your patience and look forward to hearing
from you!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Registering did the trick CTP to CTP ... although I have not figured out a
defined process.
However, Now I am trying to use the RTM Management Studio and connect to the
Object Explorer on a CTP version on another server. Same problem. The
registration trick does not work here.
--
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:

> Hi,
> How about the results of your testing? I wanted to post a quick note to se
e
> if you would like additional assistance or information regarding this
> particular issue. We appreciate your patience and look forward to hearing
> from you!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi Vakar,
Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
like to recommand you replace all CTP with RTM and I believe this will fix
the imcompatible issue.
Thank you for your patience and cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||We have some CTP in semi-production ...
We will be administrating the the re-install via Remote Desktop, which is a
pain.
My understanding is we have to remove CTP before installing RTM .. that is
correct.
--
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:

> Hi Vakar,
> Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
> like to recommand you replace all CTP with RTM and I believe this will fix
> the imcompatible issue.
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi Vakar,
I do understand that removing and reinstalling costs much time. However, I
am afraid it is not a wise decision to deploy Community Technical Preview
version of SQL Server on production server.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

2k5 Management Studio Object Explorer Error

Receiving the enclosed error when attempting to connect to a server and
browse. (the Object Explorer works fine when browsing 'local' server). I
have tried this with two different installagions of 2k5 with the same results.
Also the 'Summary' pane will allow drilling up and down.
Is there a work around'
--
Thanks in advance
GH
SS Version: 09.00.1187
Error Info:
TITLE: Microsoft SQL Server Management Studio
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
ADDITIONAL INFORMATION:
Insert Error: Column name or number of supplied values does not match table
definition. (Microsoft SQL Server, Error: 213)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
=============================
***** Advanced Information ***********
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
query)
at
Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at
Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType
resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
result)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[]
fields, OrderBy[] orderby)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[]
fields, OrderBy[] orderby)
at
Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String[]
fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
allProperties)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
propname)
at Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.SetTsxInformation(Server server, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.PopulateProperties(INodeInformation
source, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.PopulateProperties()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.SetStaticProperties(NodeContext nodeContext)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
===================================
Insert Error: Column name or number of supplied values does not match table
definition. (.Net SqlClient Data Provider)
--
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
--
Server Name: a-rogerp-sql01
Error Number: 213
Severity: 16
State: 7
Procedure: sp_get_sqlagent_properties
Line Number: 162
--
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
sqlCommand)Hi,
One possible cause of this error is that when you are connecting
remotely that you are using two different builds of SQL Server 2005.
There are incompatibilities between some builds.
Are the SQL Server 2005 builds the same on each of the machines? If
not, the workaround is to use the same build on all machines.
Andrew Watt
MVP - InfoPath
On Tue, 1 Nov 2005 12:18:04 -0800, "GH" <vakar@.community.nospam>
wrote:
>Receiving the enclosed error when attempting to connect to a server and
>browse. (the Object Explorer works fine when browsing 'local' server). I
>have tried this with two different installagions of 2k5 with the same results.
>Also the 'Summary' pane will allow drilling up and down.
>Is there a work around'
>--
>Thanks in advance
>GH
>SS Version: 09.00.1187
>Error Info:
>TITLE: Microsoft SQL Server Management Studio
>--
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>ADDITIONAL INFORMATION:
>Insert Error: Column name or number of supplied values does not match table
>definition. (Microsoft SQL Server, Error: 213)
>For help, click:
>http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
>=============================>***** Advanced Information ***********
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>Program Location:
> at
>Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
>sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
>query)
> at
>Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
> at
>Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType
>resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
> at
>Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
> at
>Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
>result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
>erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.GetData()
> at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
>Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
>connectionInfo, Request request)
> at
>Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String[]
>fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
>allProperties)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
>propname)
> at Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.SetTsxInformation(Server server, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.PopulateProperties(INodeInformation
>source, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.PopulateProperties()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.SetStaticProperties(NodeContext nodeContext)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
>nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
>Boolean registerBuilder, Boolean registerBuiltItems)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
>nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
>filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
>source, INavigableItem sourceItem, IFilterProvider filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
>===================================>Insert Error: Column name or number of supplied values does not match table
>definition. (.Net SqlClient Data Provider)
>--
>For help, click:
>http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
>--
>Server Name: a-rogerp-sql01
>Error Number: 213
>Severity: 16
>State: 7
>Procedure: sp_get_sqlagent_properties
>Line Number: 162
>
>--
>Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>exception, Boolean breakConnection)
> at
>System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
>stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
>SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
> at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
>RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
>DbAsyncResult result)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
>behavior, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
>Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
>sqlCommand)|||If you are using the RC/RTM build to connect to an earlier build like the
September CTP or earlier you'll get this error. Make sure all your
servers/tools are on the same build
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"GH" <vakar@.community.nospam> wrote in message
news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
> Receiving the enclosed error when attempting to connect to a server and
> browse. (the Object Explorer works fine when browsing 'local' server). I
> have tried this with two different installagions of 2k5 with the same
> results.
> Also the 'Summary' pane will allow drilling up and down.
> Is there a work around'
> --
> Thanks in advance
> GH
> SS Version: 09.00.1187
> Error Info:
> TITLE: Microsoft SQL Server Management Studio
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> ADDITIONAL INFORMATION:
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (Microsoft SQL Server, Error: 213)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
> =============================> ***** Advanced Information ***********
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
> sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
> query)
> at
> Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql
> execSql, String query)
> at
> Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection
> query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType
> resultType, StringCollection sql, Object connectionInfo, StatementBuilder
> sb)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult
> sqlresult, ResultType resultType)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
> result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
> erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.GetData()
> at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
> Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
> connectionInfo, Request request)
> at
> Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request
> req)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String[]
> fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
> allProperties)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
> propname)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.SetTsxInformation(Server
> server, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.PopulateProperties(INodeInformation
> source, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.PopulateProperties()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.SetStaticProperties(NodeContext
> nodeContext)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery,
> Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
> nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
> filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
> ===================================> Insert Error: Column name or number of supplied values does not match
> table
> definition. (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
> --
> Server Name: a-rogerp-sql01
> Error Number: 213
> Severity: 16
> State: 7
> Procedure: sp_get_sqlagent_properties
> Line Number: 162
>
> --
> Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
> at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
> ds,
> RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
> DbAsyncResult result)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
> sqlCommand)
>
>
>|||Thanks Guys ..
I am connecting to Sept CTP versions ..
It appears this build (Sept CTP) has a characteristic different from the
previous ... It throws this error if the remote server has not been
registered prior to attempting the connection ...
I am continuining to test this.
Thanks for your assistance
GH
"Jasper Smith" wrote:
> If you are using the RC/RTM build to connect to an earlier build like the
> September CTP or earlier you'll get this error. Make sure all your
> servers/tools are on the same build
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "GH" <vakar@.community.nospam> wrote in message
> news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
> > Receiving the enclosed error when attempting to connect to a server and
> > browse. (the Object Explorer works fine when browsing 'local' server). I
> > have tried this with two different installagions of 2k5 with the same
> > results.
> >
> > Also the 'Summary' pane will allow drilling up and down.
> >
> > Is there a work around'
> >
> > --
> > Thanks in advance
> > GH
> >
> > SS Version: 09.00.1187
> >
> > Error Info:
> >
> > TITLE: Microsoft SQL Server Management Studio
> > --
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Insert Error: Column name or number of supplied values does not match
> > table
> > definition. (Microsoft SQL Server, Error: 213)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
> >
> > =============================> >
> > ***** Advanced Information ***********
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> > Program Location:
> >
> > at
> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
> > sqlCommand)
> > at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String
> > query)
> > at
> > Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql
> > execSql, String query)
> > at
> > Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection
> > query, Object con, StatementBuilder sb, RetriveMode rm)
> > at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType
> > resultType, StringCollection sql, Object connectionInfo, StatementBuilder
> > sb)
> > at
> > Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult
> > sqlresult, ResultType resultType)
> > at
> > Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult
> > result)
> > at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult
> > erParent)
> > at Microsoft.SqlServer.Management.Smo.Environment.GetData()
> > at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
> > Object ci)
> > at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
> > connectionInfo, Request request)
> > at
> > Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request
> > req)
> > at
> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[]
> > fields, OrderBy[] orderby)
> > at
> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[]
> > fields, OrderBy[] orderby)
> > at
> > Microsoft.SqlServer.Management.Smo.Agent.JobServer.ImplInitialize(String[]
> > fields, OrderBy[] orderby)
> > at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean
> > allProperties)
> > at
> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String
> > propname)
> > at
> > Microsoft.SqlServer.Management.Smo.Agent.JobServer.get_MsxServerName()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.SetTsxInformation(Server
> > server, INameObjectCollection properties)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.AgentPropertyHandler.PopulateProperties(INodeInformation
> > source, INameObjectCollection properties)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext.PopulateProperties()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.SetStaticProperties(NodeContext
> > nodeContext)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
> > nodes, INodeInformation source, INavigableItem sourceItem, String
> > urnQuery,
> > Boolean registerBuilder, Boolean registerBuiltItems)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
> > nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
> > filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
> > source, INavigableItem sourceItem, IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
> >
> > ===================================> >
> > Insert Error: Column name or number of supplied values does not match
> > table
> > definition. (.Net SqlClient Data Provider)
> >
> > --
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=213&LinkId=20476
> >
> > --
> > Server Name: a-rogerp-sql01
> > Error Number: 213
> > Severity: 16
> > State: 7
> > Procedure: sp_get_sqlagent_properties
> > Line Number: 162
> >
> >
> > --
> > Program Location:
> >
> > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> > Boolean breakConnection)
> > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > exception, Boolean breakConnection)
> > at
> > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> > stateObj)
> > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> > SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> > bulkCopyHandler, TdsParserStateObject stateObj)
> > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
> > at System.Data.SqlClient.SqlDataReader.get_MetaData()
> > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
> > ds,
> > RunBehavior runBehavior, String resetOptionsString)
> > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
> > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
> > DbAsyncResult result)
> > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
> > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> > behavior, String method)
> > at System.Data.SqlClient.SqlCommand.ExecuteReader()
> > at
> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String
> > sqlCommand)
> >
> >
> >
> >
> >
> >
>
>|||Hi,
How about the results of your testing? I wanted to post a quick note to see
if you would like additional assistance or information regarding this
particular issue. We appreciate your patience and look forward to hearing
from you!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Registering did the trick CTP to CTP ... although I have not figured out a
defined process.
However, Now I am trying to use the RTM Management Studio and connect to the
Object Explorer on a CTP version on another server. Same problem. The
registration trick does not work here.
--
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:
> Hi,
> How about the results of your testing? I wanted to post a quick note to see
> if you would like additional assistance or information regarding this
> particular issue. We appreciate your patience and look forward to hearing
> from you!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Vakar,
Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
like to recommand you replace all CTP with RTM and I believe this will fix
the imcompatible issue.
Thank you for your patience and cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||We have some CTP in semi-production ...
We will be administrating the the re-install via Remote Desktop, which is a
pain.
My understanding is we have to remove CTP before installing RTM .. that is
correct.
--
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:
> Hi Vakar,
> Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
> like to recommand you replace all CTP with RTM and I believe this will fix
> the imcompatible issue.
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Vakar,
I do understand that removing and reinstalling costs much time. However, I
am afraid it is not a wise decision to deploy Community Technical Preview
version of SQL Server on production server.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

2k5 Management Studio Object Explorer Error

Receiving the enclosed error when attempting to connect to a server and
browse. (the Object Explorer works fine when browsing 'local' server). I
have tried this with two different installagions of 2k5 with the same results.
Also the 'Summary' pane will allow drilling up and down.
Is there a work around?
Thanks in advance
GH
SS Version: 09.00.1187
Error Info:
TITLE: Microsoft SQL Server Management Studio
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
ADDITIONAL INFORMATION:
Insert Error: Column name or number of supplied values does not match table
definition. (Microsoft SQL Server, Error: 213)
For help, click:
http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
=============================
***** Advanced Information ***********
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Program Location:
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteReader(String
sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataReader(String
query)
at
Microsoft.SqlServer.Management.Smo.DataProvider.Se tConnectionAndQuery(ExecuteSql execSql, String query)
at
Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illData(ResultType
resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at
Microsoft.SqlServer.Management.Smo.SqlObjectBase.B uildResult(EnumResult
result)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.G etData(EnumResult
erParent)
at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.Smo.ExecutionManage r.GetEnumeratorDataReader(Request req)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.Ge tInitDataReader(String[]
fields, OrderBy[] orderby)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.Im plInitialize(String[]
fields, OrderBy[] orderby)
at
Microsoft.SqlServer.Management.Smo.Agent.JobServer .ImplInitialize(String[]
fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.In itialize(Boolean
allProperties)
at
Microsoft.SqlServer.Management.Smo.SqlSmoObject.On PropertyMissing(String
propname)
at Microsoft.SqlServer.Management.Smo.Agent.JobServer .get_MsxServerName()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.AgentPropertyHandler.SetTsxInformatio n(Server server, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.AgentPropertyHandler.PopulateProperti es(INodeInformation
source, INameObjectCollection properties)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NodeContext.PopulateProperties()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.SetStaticPropert ies(NodeContext nodeContext)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem WithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem (IList
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.Build(INodeInfor mation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ExplorerHierarchyNode.BuildChildren()
===================================
Insert Error: Column name or number of supplied values does not match table
definition. (.Net SqlClient Data Provider)
For help, click:
http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
Server Name: a-rogerp-sql01
Error Number: 213
Severity: 16
State: 7
Procedure: sp_get_sqlagent_properties
Line Number: 162
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteReader(String
sqlCommand)
Hi,
One possible cause of this error is that when you are connecting
remotely that you are using two different builds of SQL Server 2005.
There are incompatibilities between some builds.
Are the SQL Server 2005 builds the same on each of the machines? If
not, the workaround is to use the same build on all machines.
Andrew Watt
MVP - InfoPath
On Tue, 1 Nov 2005 12:18:04 -0800, "GH" <vakar@.community.nospam>
wrote:

>Receiving the enclosed error when attempting to connect to a server and
>browse. (the Object Explorer works fine when browsing 'local' server). I
>have tried this with two different installagions of 2k5 with the same results.
>Also the 'Summary' pane will allow drilling up and down.
>Is there a work around?
>--
>Thanks in advance
>GH
>SS Version: 09.00.1187
>Error Info:
>TITLE: Microsoft SQL Server Management Studio
>--
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>ADDITIONAL INFORMATION:
>Insert Error: Column name or number of supplied values does not match table
>definition. (Microsoft SQL Server, Error: 213)
>For help, click:
>http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
>=============================
>***** Advanced Information ***********
>An exception occurred while executing a Transact-SQL statement or batch.
>(Microsoft.SqlServer.ConnectionInfo)
>--
>Program Location:
> at
>Microsoft.SqlServer.Management.Common.ServerConne ction.ExecuteReader(String
>sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataReader(String
>query)
> at
>Microsoft.SqlServer.Management.Smo.DataProvider.S etConnectionAndQuery(ExecuteSql execSql, String query)
> at
>Microsoft.SqlServer.Management.Smo.ExecuteSql.Get DataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illData(ResultType
>resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
> at
>Microsoft.SqlServer.Management.Smo.SqlObjectBase. FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
> at
>Microsoft.SqlServer.Management.Smo.SqlObjectBase. BuildResult(EnumResult
>result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.G etData(EnumResult
>erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
>Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
>connectionInfo, Request request)
> at
>Microsoft.SqlServer.Management.Smo.ExecutionManag er.GetEnumeratorDataReader(Request req)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.G etInitDataReader(String[]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.I mplInitialize(String[]
>fields, OrderBy[] orderby)
> at
>Microsoft.SqlServer.Management.Smo.Agent.JobServe r.ImplInitialize(String[]
>fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.In itialize(Boolean
>allProperties)
> at
>Microsoft.SqlServer.Management.Smo.SqlSmoObject.O nPropertyMissing(String
>propname)
> at Microsoft.SqlServer.Management.Smo.Agent.JobServer .get_MsxServerName()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.AgentPropertyHandler.SetTsxInformati on(Server server, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.AgentPropertyHandler.PopulatePropert ies(INodeInformation
>source, INameObjectCollection properties)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NodeContext.PopulateProperties()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItemBuilder.SetStaticProper ties(NodeContext nodeContext)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItemBuilder.BuildDynamicIte mWithQuery(IList
>nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
>Boolean registerBuilder, Boolean registerBuiltItems)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItemBuilder.BuildDynamicIte m(IList
>nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
>filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItemBuilder.Build(INodeInfo rmation
>source, INavigableItem sourceItem, IFilterProvider filter)
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.NavigableItem.GetChildren()
> at
>Microsoft.SqlServer.Management.UI.VSIntegration.O bjectExplorer.ExplorerHierarchyNode.BuildChildren( )
>===================================
>Insert Error: Column name or number of supplied values does not match table
>definition. (.Net SqlClient Data Provider)
>--
>For help, click:
>http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
>--
>Server Name: a-rogerp-sql01
>Error Number: 213
>Severity: 16
>State: 7
>Procedure: sp_get_sqlagent_properties
>Line Number: 162
>
>--
>Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
>Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
>exception, Boolean breakConnection)
> at
>System.Data.SqlClient.TdsParser.ThrowExceptionAnd Warning(TdsParserStateObject
>stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
>SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
> at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
>RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
>DbAsyncResult result)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
>cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
>behavior, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
>Microsoft.SqlServer.Management.Common.ServerConne ction.ExecuteReader(String
>sqlCommand)
|||If you are using the RC/RTM build to connect to an earlier build like the
September CTP or earlier you'll get this error. Make sure all your
servers/tools are on the same build
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"GH" <vakar@.community.nospam> wrote in message
news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
> Receiving the enclosed error when attempting to connect to a server and
> browse. (the Object Explorer works fine when browsing 'local' server). I
> have tried this with two different installagions of 2k5 with the same
> results.
> Also the 'Summary' pane will allow drilling up and down.
> Is there a work around?
> --
> Thanks in advance
> GH
> SS Version: 09.00.1187
> Error Info:
> TITLE: Microsoft SQL Server Management Studio
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> ADDITIONAL INFORMATION:
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (Microsoft SQL Server, Error: 213)
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
> =============================
> ***** Advanced Information ***********
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteReader(String
> sqlCommand)
> at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataReader(String
> query)
> at
> Microsoft.SqlServer.Management.Smo.DataProvider.Se tConnectionAndQuery(ExecuteSql
> execSql, String query)
> at
> Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataProvider(StringCollection
> query, Object con, StatementBuilder sb, RetriveMode rm)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illData(ResultType
> resultType, StringCollection sql, Object connectionInfo, StatementBuilder
> sb)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illDataWithUseFailure(SqlEnumResult
> sqlresult, ResultType resultType)
> at
> Microsoft.SqlServer.Management.Smo.SqlObjectBase.B uildResult(EnumResult
> result)
> at Microsoft.SqlServer.Management.Smo.SqlObjectBase.G etData(EnumResult
> erParent)
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
> at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
> Object ci)
> at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
> connectionInfo, Request request)
> at
> Microsoft.SqlServer.Management.Smo.ExecutionManage r.GetEnumeratorDataReader(Request
> req)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.Ge tInitDataReader(String[]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.Im plInitialize(String[]
> fields, OrderBy[] orderby)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer .ImplInitialize(String[]
> fields, OrderBy[] orderby)
> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.In itialize(Boolean
> allProperties)
> at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.On PropertyMissing(String
> propname)
> at
> Microsoft.SqlServer.Management.Smo.Agent.JobServer .get_MsxServerName()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.AgentPropertyHandler.SetTsxInformatio n(Server
> server, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.AgentPropertyHandler.PopulateProperti es(INodeInformation
> source, INameObjectCollection properties)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NodeContext.PopulateProperties()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.SetStaticPropert ies(NodeContext
> nodeContext)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem WithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery,
> Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem (IList
> nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
> filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.Build(INodeInfor mation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItem.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ExplorerHierarchyNode.BuildChildren()
> ===================================
> Insert Error: Column name or number of supplied values does not match
> table
> definition. (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
> --
> Server Name: a-rogerp-sql01
> Error Number: 213
> Severity: 16
> State: 7
> Procedure: sp_get_sqlagent_properties
> Line Number: 162
>
> --
> Program Location:
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
> Boolean breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
> at System.Data.SqlClient.SqlDataReader.get_MetaData()
> at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader
> ds,
> RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
> DbAsyncResult result)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
> behavior, String method)
> at System.Data.SqlClient.SqlCommand.ExecuteReader()
> at
> Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteReader(String
> sqlCommand)
>
>
>
|||Thanks Guys ..
I am connecting to Sept CTP versions ..
It appears this build (Sept CTP) has a characteristic different from the
previous ... It throws this error if the remote server has not been
registered prior to attempting the connection ...
I am continuining to test this.
Thanks for your assistance
GH
"Jasper Smith" wrote:

> If you are using the RC/RTM build to connect to an earlier build like the
> September CTP or earlier you'll get this error. Make sure all your
> servers/tools are on the same build
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "GH" <vakar@.community.nospam> wrote in message
> news:62C1A25F-8B70-4A21-B371-E6776AD44FB2@.microsoft.com...
>
>
|||Hi,
How about the results of your testing? I wanted to post a quick note to see
if you would like additional assistance or information regarding this
particular issue. We appreciate your patience and look forward to hearing
from you!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Registering did the trick CTP to CTP ... although I have not figured out a
defined process.
However, Now I am trying to use the RTM Management Studio and connect to the
Object Explorer on a CTP version on another server. Same problem. The
registration trick does not work here.
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:

> Hi,
> How about the results of your testing? I wanted to post a quick note to see
> if you would like additional assistance or information regarding this
> particular issue. We appreciate your patience and look forward to hearing
> from you!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Vakar,
Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
like to recommand you replace all CTP with RTM and I believe this will fix
the imcompatible issue.
Thank you for your patience and cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||We have some CTP in semi-production ...
We will be administrating the the re-install via Remote Desktop, which is a
pain.
My understanding is we have to remove CTP before installing RTM .. that is
correct.
Thanks in advance
GH
"Michael Cheng [MSFT]" wrote:

> Hi Vakar,
> Since SQL Server 2005 RTM is available now for MSDN Subscribers, I would
> like to recommand you replace all CTP with RTM and I believe this will fix
> the imcompatible issue.
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Vakar,
I do understand that removing and reinstalling costs much time. However, I
am afraid it is not a wise decision to deploy Community Technical Preview
version of SQL Server on production server.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
Message posted via http://www.droptable.com
This is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.droptable.co m...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.droptable.com

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
Message posted via http://www.droptable.comThis is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.SQ
droptable.com...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.droptable.com

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
--
Message posted via http://www.sqlmonster.comThis is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.SQLMonster.com...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.sqlmonster.com

20598 MSrepl_errors information required

I'd like to know how to know what replication stored procedure and parameters
to that is being run for a 20598 error I'm receiving.
in MSrepl_errors, for all these 20598 errors
error_text is: "The row was not found at the Subscriber when applying the
replicated command."
xact_seqno is: 0x0000... (ZERO)
so there seems to be no chance to use sp_browsereplcmds <xact_seqno>
My configuration: Transactional "nosync" replication
SQL Server 2000 SP4
The Distribution Agent Profile has the following:
-SkipError 2601:2627:20598
This is due to the fact my Publisher has a 2 year history of data and we're
replicating new data to a fresh DB . Deletes/Updates are not found, hence
the 20598 errors.
However, I'd like to know what data is erroring out. I will likely be able
to reduce these errors to a minimum but don't have any information on them to
investigate.
Suggestions?
Jack Griffith
Enable logging as per this kb article.
http://support.microsoft.com/kb/312292
Note that it appears that you are trying to update a row on the subscriber
which has already been deleted.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jack Griffith" <JackGriffith@.discussions.microsoft.com> wrote in message
news:188524CC-3706-4D41-B916-319D5C0715F0@.microsoft.com...
> I'd like to know how to know what replication stored procedure and
> parameters
> to that is being run for a 20598 error I'm receiving.
>
> in MSrepl_errors, for all these 20598 errors
> error_text is: "The row was not found at the Subscriber when applying the
> replicated command."
> xact_seqno is: 0x0000... (ZERO)
> so there seems to be no chance to use sp_browsereplcmds <xact_seqno>
> My configuration: Transactional "nosync" replication
> SQL Server 2000 SP4
> The Distribution Agent Profile has the following:
> -SkipError 2601:2627:20598
> This is due to the fact my Publisher has a 2 year history of data and
> we're
> replicating new data to a fresh DB . Deletes/Updates are not found, hence
> the 20598 errors.
> However, I'd like to know what data is erroring out. I will likely be
> able
> to reduce these errors to a minimum but don't have any information on them
> to
> investigate.
> Suggestions?
> --
> Jack Griffith
|||Updating a row that has been deleted is indicated by the xact_seqno being 0x00?
Jack Griffith
"Hilary Cotter" wrote:

> Enable logging as per this kb article.
> http://support.microsoft.com/kb/312292
> Note that it appears that you are trying to update a row on the subscriber
> which has already been deleted.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Jack Griffith" <JackGriffith@.discussions.microsoft.com> wrote in message
> news:188524CC-3706-4D41-B916-319D5C0715F0@.microsoft.com...
>
>
|||- First of all. Thank you! I really appreciate your quick response to my
initial request. I applied the suggestion from the knowledgebase article,
heeding the warning regarding the impact of logging.
- The net result was that I was able to identify and resolve one of the
sources of my errors which reduced about 90% of those occuring. I'm left
with 10% unsolved and no practical way to identify them.
==> My question is:
Why is the xact_seqno in MSrepl_errors = 0x00 when it should be ( I think!):
0x0004c6c4000006570007
If MSrepl_errors could the text of the error, and xact_seqno, it would take
huge burdon off, as I cannot afford to run the logging given the onerous load.
More details are below to explain this question.
- The impact of error logging as per your suggestion was huge! In one hour,
my log filled up with about 50Mb's and the transaction latency went from
1,500 ms to 1,500,000ms.
- As soon as I started to log the activity, there were no errors. I was
thinking it was a classic "Heisenberg uncertainty principle" situation, but
in the last couple of minutes of the hour, I got 2 errors.
- Had to stop logging at that point. I reset the logging level to '0' which
should log errors only. However, it didn't seem to do that.
- I inspected the error logs and was a bit misled. You have to be careful
to group all of the error activity together in spite of the other unrelated
transaction activity that is interleaved. It's somewhat logical but
disorienting.
- OK the two errors were attributed to UPDATE statements to a table for
which the rows are non-existent in the Subscriber side. It was not
unexpected in this case.
- What is unexpected, is the inability of the MSrepl_errors table to track
the information. I say this because I find the following information in the
log:
============= start of error information =================
Last transaction timestamp: 0x0004c6c400000656000200000000
Transaction seqno: 0x0004c6c4000006570007
--^^^^^^^^^^^^^^^^^
Command Id: 1
Partial: 0
Type: 0
Command: [4/1/2007 6:42:46 PM]<SQL Server name>.<DB Name>:
{...several CALL sp_MSins<no problem table>...}
{CALL to sp_MSupd<culprit table> }
^^^^^^^^^^^^^^^^^^^^^^^^
{...several CALL sp_MSins<no problem table>...}
Skipped 1 error(s) when applying transactions at the Subscriber.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[4/1/2007 6:42:46 PM]<SQL Server name>.<DB Name>: update
MSreplication_subscriptions set transaction_timestamp = ?, "time" = ? where
publisher = ? and publisher_db = ? and independent_agent = 0 and
subscription_type = 0
Last transaction timestamp: 0x0004c6c400000657000700000000
Transaction seqno: 0x0004c6c4000006590009
Command Id: 1
Partial: 0
Type: 0
Command: [4/1/2007 6:42:46 PM]<SQL Server name>.distribution: {call
sp_MSadd_distribution_history(13, 3, ?, ?, 92518, 92518, 0.00, 0x01, 1, ?,
0, 0x01, 0x00)}
The commit timestamp value is: 0x0004c6c400000654000600000000
if exists (select * from sysobjects where name = 'syspublications') if
exists( select * from syspublications where repl_freq = 0) exec
sp_replsetoriginator ?, ?
ErrorId = 974, SourceTypeId = 5
ErrorCode = '20598'
ErrorText = 'The row was not found at the Subscriber when applying the
replicated command.'
[4/1/2007 6:42:46 PM]<SQL Server name>.distribution: {call
sp_MSadd_repl_error(974, 0, 5, ?, N'20598', ?)}
=================== end of error stream ====================
- So to repeat: why is the xact_seqno in MSrepl_errors = 0x00 when it
should be ( I think!): 0x0004c6c4000006570007
Bug?
Jack Griffith