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.