Does SQL2000/MSDE run on XP Tablet?

Hello there,

i have a great doubt: does MSDE run on XP Tablet Edition? I bought a beautiful notebook but didn't notice that it runs XP tablet...

Thanks in advance

Yes it does

Does Sql server2005 standard edition support Sql server integration services and SSRS

Does Sql server 2005 standard edition support Sql server integration services and SSRS. i saw two conflicting information.

And what is the difference between Integration services with basic transforms and integration services advanced transforms.

Please recommend.

Yes.

The following advanced transformations are available only in Enterprise edition related on SSIS:

Analysis Services Partition Processing Destination - with it you can perform incremental, full, or update processing of a AS partition.

Analysis Services Dimension Processing Destination for loading and processing a dimension.

Data Mining Training and Data Mining Query Component

Fuzzy Grouping, Fuzzy Lookup

Term Extraction and Term Lookup -used for "Text Mining"(Text Data Mining that work good for english texts)

So if you want to use SSIS package to process a cube, data mining structure and crossroad of bad data(Fuzzy Grouping, Fuzzy Lookup) you need Enterprise Edition.

|||

Can we use

SSIS
SSRS
ONLINE PROCESSING USING .NET
BATCH PROCESSING USING .NET

all in the same server. is there any performance issue related to standard 2005 vs enterprise 2005

Thanking you.

|||

In terms of comparing standard and enterprise on same machine , sure no, but you have limits on Standard:

-hardware level : max 4 CPU on server

-software level :NO partitioning, indexed views, and more

An article of this comparison

|||Thankyou

Does SQL Server 2005 Workgroup edition support scheduling report?

Hello,

In the feature list of workgroup edition, it says Reporting services is included.

After I finally installed it, the reporting service is there as expected. But what is missing is the subscription tab in the report manager. Then I went to Reporting service Configuration Manager, and I saw emailing setting is there (which indicates scheudling and emailling is supported), then I setup valid sender email address and SMTP server, but the Subscription tab is still missing.

Could anyone (from microsoft) tell me whether emailling and scheduling are supported in Workgroup edition or not?

Thanks a lot!

Details about available RS features per edition can be found here: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

Subscriptions are available for Standard Edition and Enterprise Editions. Data-driven subscriptions are Enterprise Edition only.

-- Robert

sql

Does Sql Server 2005 Installation create a default instance?

Hello everybody!

I have recently installed Sql Server 2005 Enterprise Edition on my PC and I have noticed that it has not installed a default instance. I have tried to do this several times even in some other PC but no default instance is installed.

I can get a default instance if I install Sql Server 2000 but this is not the same I guess. Is there any way to install the default instance via Sql Server 2005?

Do you have already a SQL Server instance installed on the system ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Are u able to install Named Instance? if not Check the OS. Enterprise Edition need Server Version of OS. Otherwise u can only install client component.

Madhu

|||Well, as I mentioned before I have installed Sql Server 2005 in several computers but I can explain you some of the cases:
1. In my computer I had already installed Sql Server 2000 and I had created two other instances except the default instance (LOCAL). Then I installed Sql Server 2005.
As a matter of fact I want to make a web synchronization for a merge replication. But I can not configure the merge replication for web synchronization because the database and its instance seems to be in SQL server 2000. That's why I want an 2005 sql server instance.

2. I have also uninstalled Sql Server 2000 and all of its instances from my computer, and I have reinstalled Sql Server 2005. But no default instance was created.

3. I have also installes Sql Server 2005 in another PC which had no instace installed, but the results were the same.

What should I do?

|||Do you mean I can not create any instance if my OS is Windows XP?
|||

Yes if you are installing Enterprise Edition it will not install Services on Windows XP. You can install Standard or any other Edition

http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

Madhu

|||Thank U

Does Sql Server 2005 Installation create a default instance?

Hello everybody!

I have recently installed Sql Server 2005 Enterprise Edition on my PC and I have noticed that it has not installed a default instance. I have tried to do this several times even in some other PC but no default instance is installed.

I can get a default instance if I install Sql Server 2000 but this is not the same I guess. Is there any way to install the default instance via Sql Server 2005?

Do you have already a SQL Server instance installed on the system ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Are u able to install Named Instance? if not Check the OS. Enterprise Edition need Server Version of OS. Otherwise u can only install client component.

Madhu

|||Well, as I mentioned before I have installed Sql Server 2005 in several computers but I can explain you some of the cases:
1. In my computer I had already installed Sql Server 2000 and I had created two other instances except the default instance (LOCAL). Then I installed Sql Server 2005.
As a matter of fact I want to make a web synchronization for a merge replication. But I can not configure the merge replication for web synchronization because the database and its instance seems to be in SQL server 2000. That's why I want an 2005 sql server instance.

2. I have also uninstalled Sql Server 2000 and all of its instances from my computer, and I have reinstalled Sql Server 2005. But no default instance was created.

3. I have also installes Sql Server 2005 in another PC which had no instace installed, but the results were the same.

What should I do?

|||Do you mean I can not create any instance if my OS is Windows XP?
|||

Yes if you are installing Enterprise Edition it will not install Services on Windows XP. You can install Standard or any other Edition

http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

Madhu

|||Thank U

Does Sql Server 2005 Installation create a default instance?

Hello everybody!

I have recently installed Sql Server 2005 Enterprise Edition on my PC and I have noticed that it has not installed a default instance. I have tried to do this several times even in some other PC but no default instance is installed.

I can get a default instance if I install Sql Server 2000 but this is not the same I guess. Is there any way to install the default instance via Sql Server 2005?

Do you have already a SQL Server instance installed on the system ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Are u able to install Named Instance? if not Check the OS. Enterprise Edition need Server Version of OS. Otherwise u can only install client component.

Madhu

|||Well, as I mentioned before I have installed Sql Server 2005 in several computers but I can explain you some of the cases:
1. In my computer I had already installed Sql Server 2000 and I had created two other instances except the default instance (LOCAL). Then I installed Sql Server 2005.
As a matter of fact I want to make a web synchronization for a merge replication. But I can not configure the merge replication for web synchronization because the database and its instance seems to be in SQL server 2000. That's why I want an 2005 sql server instance.

2. I have also uninstalled Sql Server 2000 and all of its instances from my computer, and I have reinstalled Sql Server 2005. But no default instance was created.

3. I have also installes Sql Server 2005 in another PC which had no instace installed, but the results were the same.

What should I do?

|||Do you mean I can not create any instance if my OS is Windows XP?
|||

Yes if you are installing Enterprise Edition it will not install Services on Windows XP. You can install Standard or any other Edition

http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

Madhu

|||Thank U
sql

Does Sql Server 2005 Enterprise Edition Support Managed Code ?

Dear friends,

please help,

let me tell you what happens,

1) first i installed Sql Server 2005 Enterprise Edition, everything was working fine except i was not able to create managed objects from BI, like stored procedures, triggers, UDT, etc etc.

2) so i installed VS.net 2005 complete + Sql Server 2005 Express Edition

now i was able to create stored procedures, triggers, etc etc, i'm talking about the CLR objects, ok, i.e. the managed code, but........ i was only able to do this from Sql Server 2005 Express Edition.

whenever i try to create managed objects CLR like stored procedures and stuff from the Sql Server 2005 Enterprise edition it gives me the following error :

"The Sql Server supplied by these connection properties, does not support managed code, please choose a different server"

please help meeeee.. please please, tell me what's the problem ?

below i'm attaching a screenshot of the error....

first off, I ASSURE you SQL Server 2005 EE supports SQLCLR. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

secondly, sql server 2005 has CLR Integration turned off by default and if you were to attempt using a sql 2005 EE default install/instance you could still deploy the sqlclr routines, its just that upon attempting to use them you would receive the error "Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option."

I can only reason that you are in fact NOT connecting to a SQL Server 2005 instance from a Visual Studio 2005 database project.

|||

yes even i think i was using, sql server 2000 your right.

thanks for your kind help,

regards,

Gurjit Singh

sql

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluation/features/choosing.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> > Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> > protocols by using the Virtual Interface Architecture (VIA), but it
> doesn't
> > say explicitly : whether SQL Server 2000 Standard Edition also supports
> VIA.
> > So I don't know do I have to buy the Enterprise Edition if I want to use
> SAN
> > as the storage area for my SQL 2000 application.
> > Can anybody help me on it because the Enterprise Edition is much
expensive
> > than the Standard Edition.
> >
> >
>

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.
No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluat.../choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different[vbcol=seagreen]
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive
>
sql

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evalua...s/choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive[vbcol=seagreen]
>

Does SQL Express support upgrade from MSDE2000 Chinese Edition?

I've tried to download the sql express and install, but it doesn't allow me to select upgrade the default instance (which i've installed msde2000 chinese edtion), it told me due to the language problem, sql express can't upgrade the default instance and only could install sql express in new instance.

I have no idea for the language edition for sql express since the download page doesn't have a language selection.

So does anyone know that,
1. would sql express have multi language edtion ?
2. if sql express would have one language edtion, how could install it to upgrade from one existing msde2000 simplified chinese edtion ?Upgrading across languages is not supported. If you want to upgrade your Chinese databases you'll need to wait until the Chinese edition of Express is released. The currently released version of Express is English only.

Does someone know when MS plans to resolve this Bug?

Hi,

I have a problem with merge replication again. This is the replication between sql server 2005 standard edition and express edition. non-filtering. after the merge agent ran normally for a couple of days, the merge replication always stops at the uploading point. It seems like the merge agent can't run the 'MSmakegeneration' sp. Here is the output log. I wish someone could give me hand. Thank you very much!

2007-05-27 21:37:19.656 Microsoft SQL Server Merge Agent 9.00.3042.00
2007-05-27 21:37:19.656 Copyright (c) 2005 Microsoft Corporation
2007-05-27 21:37:19.656
2007-05-27 21:37:19.656 The timestamps prepended to the output lines are expressed in terms of UTC time.
2007-05-27 21:37:19.656 User-specified agent parameter values:
-Publication Brown
-Publisher FMSL_SERVER
-Subscriber Brown-WF
-Distributor FMSL_SERVER
-PublisherDB Brown
-SubscriberDB Brown
-PublisherLogin sa
-PublisherPassword **********
-PublisherSecurityMode 0
-OutputVerboseLevel 0
-SubscriberSecurityMode 1
-SubscriptionType 1
-DistributorLogin sa
-DistributorPassword **********
-DistributorSecurityMode 0
-Output C:\OUTPUTFILE.txt
-Outputverboselevel 2
2007-05-27 21:37:19.703 Percent Complete: 0
2007-05-27 21:37:19.703 Connecting to Subscriber 'Brown-WF'
2007-05-27 21:37:19.703 Connecting to OLE DB Subscriber at datasource: 'Brown-WF', location: '', catalog: 'Brown', providerstring: '' using provider 'SQLNCLI'
2007-05-27 21:37:19.812 OLE DB Subscriber: Brown-WF
DBMS: Microsoft SQL Server
Version: 09.00.3042
catalog name: Brown
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2007-05-27 21:37:19.812 OLE DB Subscriber 'Brown-WF': {call sp_MSgetversion }
2007-05-27 21:37:19.828 OLE DB Subscriber 'Brown-WF': set nocount on declare @.dbname sysname select @.dbname = db_name() declare @.collation nvarchar(255) select @.collation = convert(nvarchar(255), databasepropertyex(@.dbname, N'COLLATION')) select collationproperty(@.collation, N'CODEPAGE') as 'CodePage', collationproperty(@.collation, N'LCID') as 'LCID', collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle',cast(case when convert (int,databasepropertyex (@.dbname,'comparisonstyle')) & 0x1 = 0x1 then 0 else 1 end as bit) as DB_CaseSensitive,cast(case when convert (int,serverproperty ('comparisonstyle')) & 0x1 = 0x1 then 0 else 1 end as bit) as Server_CaseSensitive set nocount off
2007-05-27 21:37:19.828 OLE DB Subscriber 'Brown-WF': {?=call sp_helpsubscription_properties (N'FMSL_SERVER', N'Brown', N'Brown')}
2007-05-27 21:37:19.843 Distributor security mode: 0, login name: sa, password: ********.
2007-05-27 21:37:19.843 Percent Complete: 0
2007-05-27 21:37:19.843 Connecting to Distributor 'FMSL_SERVER'
2007-05-27 21:37:19.843 Connecting to OLE DB Distributor at datasource: 'FMSL_SERVER', location: '', catalog: '', providerstring: '' using provider 'SQLNCLI'
2007-05-27 21:37:20.390 OLE DB Distributor: FMSL_SERVER
DBMS: Microsoft SQL Server
Version: 09.00.3042
catalog name:
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2007-05-27 21:37:20.718 OLE DB Distributor 'FMSL_SERVER': {call sp_MSgetversion }
2007-05-27 21:37:20.796 OLE DB Distributor 'FMSL_SERVER': {call sp_helpdistpublisher (N'FMSL_SERVER') }
2007-05-27 21:37:20.984 OLE DB Distributor 'FMSL_SERVER': select datasource, srvid from master..sysservers where upper(srvname) = upper(N'FMSL_SERVER')
2007-05-27 21:37:21.078 OLE DB Distributor 'FMSL_SERVER': {call sp_MShelp_merge_agentid (0,N'Brown',N'Brown',null,N'Brown',90,N'Brown-WF')}
2007-05-27 21:37:21.171 OLE DB Subscriber 'Brown-WF': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:21.187 OLE DB Distributor 'FMSL_SERVER': {call sp_MShelp_profile (91, 4, N'')}
2007-05-27 21:37:21.312 Percent Complete: 0
2007-05-27 21:37:21.312 OLE DB Subscriber 'Brown-WF': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:21.312 Initializing
2007-05-27 21:37:21.312 OLE DB Distributor 'FMSL_SERVER': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:21.312 Connecting to OLE DB Publisher at datasource: 'FMSL_SERVER', location: '', catalog: 'Brown', providerstring: '' using provider 'SQLNCLI'
2007-05-27 21:37:21.421 Percent Complete: 0
2007-05-27 21:37:21.421 Connecting to Publisher 'FMSL_SERVER'
2007-05-27 21:37:21.421 OLE DB Distributor 'FMSL_SERVER': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:21.765 OLE DB Publisher: FMSL_SERVER
DBMS: Microsoft SQL Server
Version: 09.00.3042
catalog name: Brown
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2007-05-27 21:37:22.109 OLE DB Publisher 'FMSL_SERVER': set nocount on declare @.dbname sysname select @.dbname = db_name() declare @.collation nvarchar(255) select @.collation = convert(nvarchar(255), databasepropertyex(@.dbname, N'COLLATION')) select collationproperty(@.collation, N'CODEPAGE') as 'CodePage', collationproperty(@.collation, N'LCID') as 'LCID', collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle',cast(case when convert (int,databasepropertyex (@.dbname,'comparisonstyle')) & 0x1 = 0x1 then 0 else 1 end as bit) as DB_CaseSensitive,cast(case when convert (int,serverproperty ('comparisonstyle')) & 0x1 = 0x1 then 0 else 1 end as bit) as Server_CaseSensitive set nocount off
2007-05-27 21:37:22.234 OLE DB Publisher 'FMSL_SERVER': {call sp_MSgetversion }
2007-05-27 21:37:22.406 Connecting to OLE DB Publisher at datasource: 'FMSL_SERVER', location: '', catalog: 'Brown', providerstring: '' using provider 'SQLNCLI'
2007-05-27 21:37:22.828 OLE DB Publisher: FMSL_SERVER
DBMS: Microsoft SQL Server
Version: 09.00.3042
catalog name: Brown
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2007-05-27 21:37:23.515 OLE DB Subscriber 'Brown-WF': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:23.515 Percent Complete: 0
2007-05-27 21:37:23.515 OLE DB Subscriber 'Brown-WF': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:23.515 Retrieving publication information
2007-05-27 21:37:23.515 OLE DB Distributor 'FMSL_SERVER': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:23.625 Percent Complete: 0
2007-05-27 21:37:23.625 Retrieving subscription information.
2007-05-27 21:37:23.625 OLE DB Distributor 'FMSL_SERVER': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:28.203 OLE DB Subscriber 'Brown-WF': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:37:28.203 Percent Complete: 0
2007-05-27 21:37:28.203 Uploading data changes to the Publisher
2007-05-27 21:37:28.203 OLE DB Distributor 'FMSL_SERVER': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-05-27 21:42:28.312 Percent Complete: 0
2007-05-27 21:42:28.312 The process is waiting for a response from the query '{call sys.sp_MSmakegeneration (?)}'
2007-05-27 21:42:28.312 OLE DB Distributor 'FMSL_SERVER': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}

In addition, from the replication monitor, I can see the last error message is:

The merge process was unable to create a new generation at the 'Subscriber'. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200994)

And this problem happened on a couple of subscribers on the same day. All the rest are OK so far.
|||now I'm pretty sure that sp_makegeneration doesn't work on the subscriber side properly. I tried to run it manually, it was just keeping running all the time, without any message coming out.

anyone got any idea about this?
|||if the makegeneration proc isn't returning, can you try profiling it to see what's blocking it? Could be a long-running query.|||hi greg,

Glad to hear from you. your reply is always so quick

Actually I did a trace, which shows at that moment, only sp_msmakegeneration was running, nothing else. And the sp was just running, never finish. I have been waitting for about 15 minutes, and tried several times. always got the same situation.

And all the other subscribers, which run properly, just finished the replication within 5 minutes.
|||WII, what I was asking is to do a statement-level trace (add SPtmtStarting event) to see what query inside the proc (or some child proc) is long-running.|||Hi Greg,

I did the statement-level trace as you suggested. But the trace information is too large and unreadable to me.

What I can find is that such kind of queries were keeping running infinitely:

if @.error<>0
update dbo.MSmerge_contents with (rowlock)
set partchangegen = (-@.target_gen )
where partchangegen = (-@.gen) and tablenick = @.art_nick
if @.error<>0
update dbo.MSmerge_metadataaction_request with (rowlock)
set generation = @.target_gen
where generation = @.gen and tablenick = @.art_nick
if @.error<>0
select @.changes_in_target_gen = @.changes_in_target_gen + @.contents_rows_moved
select @.changes_in_gen = @.changes_in_gen - @.contents_rows_moved
update dbo.MSmerge_genhistory with (rowlock) set changecount = @.changes_in_gen where generation = @.gen

if @.@.error<>0
update dbo.MSmerge_genhistory with (rowlock) set changecount = @.changes_in_target_gen where generation = @.target_gen

........

I feel there is some deadlock? Can you see anything from the log? Thx
|||And also, i just learned from some article, that

select tCustomers.* from tCustomers
inner join MSmerge_contents on tCustomers.rowguid = MSmerge_contents.rowguid
inner join MSmerge_genhistory on MSmerge_contents.generation = MSmerge_genhistory.generation
where MSmerge_genhistory.genstatus = 0

I can see all the unuploaded changes on the subscribers that got the problem, which means all the merge triggers were fired normally when any change happened on them.
|||I opened a support case with Microsoft. And this issue is treated as a bug now. So I suppose u guys will see the answer in a future hotfix.

Thanks guys
|||

Hi WII

Just wondered how far your support case had got, we have exactly the same problem and I wondered if you have got a fix?

Thanks,

SMN

|||Same problem here, merge agent gets stuck on sys.sp_MSmakegeneration, which happened after a reinitialization and don't go away even after dropping and creating the subscription.|||Same problem at our system.... Some subsribers do not replicate anymore....

We found the same cause sp_MSmakegeneration (timeout respectively no return value?)

Our system supports salesmen with an application to create orders. We can not reset the subscribtions, as the data of the salesmen would be lost. Our customer looses every day big money due to this bug. There is no way for me to use the workaround as describe above, as we use partially colum level replication. I don't want to create a mess in system tables. If someone would provide a solution for this as well? (Or a comprehensive script, step by step what to do....?)

Otherwhise it would be good, if an experienced programmer could have a look at this "sp_MSmakegeneration" and complete the work and provide a temporarily substitution for this script. It seems to have a hidden dog.

E.g. Comment of MS Programmer in sp_MSmakegeneration Line 265: " -- TODO: possibly add some code for 0 artnick generations..."

Thanks for any help or advice.
|||http://support.microsoft.com/kb/936305

It seems that one of the Hotfixes apply to this timeout problem|||Has anyone determined that this hotfix corrects this problem?

thanks
jg
|||Did NOT fix problem here.sql

does service broker come with sql express?

we're a little confused, we understand that between instances of sql express that a licensed edition would be necessary for service broker to be used but what if there is just one sql express edition/instance in the picture, does service broker come with express and can most of service broker's features be used "intra" (inside) that instance?

SQL Server Service Broker does come with Express. And you do need another (paid) edition involved for messages that pass outside the instance.

From http://msdn2.microsoft.com/en-us/library/ms345154.aspx#sseover_topic10:

SQL Server Express can use Service Broker only in combination with other SQL Server 2005 editions. If SQL Server Express receives a Broker message from another Express instance, and if another SQL Server 2005 edition has not processed the message, then the message is dropped. So the message can originate from an Express instance and end up at one, but it must be routed through a non-Express instance if that is the case. You can check a Message Drop trace event that is accessible from the Profiler or use tracing stored procedures to track this type of occurrence. The error message associated with the dropped message includes verbiage to this effect: "This message has been dropped due to licensing restrictions."

Don

|||thanks, I've read that first sentence before and totally misinterpreted its meaning.

Does personal edition sql server support jdbc connection?

if it does, what are the settings I must do in the server?
since I got the following error when connect :
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
thanksHi
Yes it does. Check your connection string. AFAIK, Integrated Security is not
supported so make sure that you supply a username and password. Check that
the username/password combination work through query analyzer.
The SQL Event log might show an audit failure (if not, turn auditing on for
failures, restart SQL Server and try again).
Regards
Mike
"Friend" wrote:
> if it does, what are the settings I must do in the server?
> since I got the following error when connect :
> com.inet.tds.SQLException: Connection refused: connect
> java.net.ConnectException: Connection refused: connect
> thanks
>

Does personal edition sql server support jdbc connection?

if it does, what are the settings I must do in the server?
since I got the following error when connect :
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
thanks
Hi
Yes it does. Check your connection string. AFAIK, Integrated Security is not
supported so make sure that you supply a username and password. Check that
the username/password combination work through query analyzer.
The SQL Event log might show an audit failure (if not, turn auditing on for
failures, restart SQL Server and try again).
Regards
Mike
"Friend" wrote:

> if it does, what are the settings I must do in the server?
> since I got the following error when connect :
> com.inet.tds.SQLException: Connection refused: connect
> java.net.ConnectException: Connection refused: connect
> thanks
>

Does personal edition sql server support jdbc connection?

if it does, what are the settings I must do in the server?
since I got the following error when connect :
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
thanksHi
Yes it does. Check your connection string. AFAIK, Integrated Security is not
supported so make sure that you supply a username and password. Check that
the username/password combination work through query analyzer.
The SQL Event log might show an audit failure (if not, turn auditing on for
failures, restart SQL Server and try again).
Regards
Mike
"Friend" wrote:

> if it does, what are the settings I must do in the server?
> since I got the following error when connect :
> com.inet.tds.SQLException: Connection refused: connect
> java.net.ConnectException: Connection refused: connect
> thanks
>sql

Does Personal Edition Includes Analisys Services??

Does Personal Edition Includes Analisys Services?
Which versions of sql include analisys services and can be installed on
Windows XP?
Developer Edition of SQL 2000 has the analysis serverices and it can be
installed on Windows XP.
hth
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services?
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>
|||Books Online lists what is ant what is not supported of AS in PE:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_ts_1cdv.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services?
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>

Does Personal Edition Includes Analisys Services??

Does Personal Edition Includes Analisys Services'
Which versions of sql include analisys services and can be installed on
Windows XP?Developer Edition of SQL 2000 has the analysis serverices and it can be
installed on Windows XP.
hth
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services'
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>|||Books Online lists what is ant what is not supported of AS in PE:
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\arc
hitec.chm::/8_ar_ts_1cdv.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services'
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>

Does Personal Edition Includes Analisys Services??

Does Personal Edition Includes Analisys Services'
Which versions of sql include analisys services and can be installed on
Windows XP?Developer Edition of SQL 2000 has the analysis serverices and it can be
installed on Windows XP.
hth
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services'
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>|||Books Online lists what is ant what is not supported of AS in PE:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_ts_1cdv.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services'
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>

Does MSDE run ok on Windows XP Home, Media Edition?

We can't seem to get TCP/IP working...
Hi Jon,
Have you enabled tcp/ip using svrnetcn.exe?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:%23QouccA6EHA.3708@.TK2MSFTNGP14.phx.gbl...
> We can't seem to get TCP/IP working...
|||Yep, and Named Pipes. It's listening on the default port of 1433, but
when SQL starts, in the log, it doesn't say it's listening on TCP. There
are no warnings/errors either.
The PC does have a firewall on it, would that make any difference?
Greg Low [MVP] wrote:

> Hi Jon,
> Have you enabled tcp/ip using svrnetcn.exe?
> HTH,
>
|||Hi Jon,
Yep, sure would. Have you put an exception for port 1433 (assuming you're
using the default port) ?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:e24tD0M6EHA.3376@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Yep, and Named Pipes. It's listening on the default port of 1433, but when
> SQL starts, in the log, it doesn't say it's listening on TCP. There are no
> warnings/errors either.
> The PC does have a firewall on it, would that make any difference?
> Greg Low [MVP] wrote: