Does SQL Server 2005 Express support Web/Internet Replication to other SQL Server Express Client

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

Shabby wrote:

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

You have to sync to a SS2005 with IIS. Replication doesn't support sync between sql express.

Shabby wrote:

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

No Sql 2005 express cannot sync with sql 2005 express directly.

|||

SQL Server 2005 Express Edition supports being a replication subscriber only. See http://msdn2.microsoft.com/en-us/library/ms165700.aspx The publisher and distributor must be higher SKUs of SQL Server 2005. i.e. Enterprise, Standard, Workgroup. As for synching via IIS over the internet with merge replication, this is supported by the SQL Server 2005 Express client.

Hope this helps,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

|||

Peng Song wrote:

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

does the client (subscriber) running on sql server express has to have IIS or only the publishing pc? thanks

sql

Does SQL Server 2005 Express support Web/Internet Replication to other SQL Server Express Cl

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

Shabby wrote:

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

You have to sync to a SS2005 with IIS. Replication doesn't support sync between sql express.

Shabby wrote:

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

No Sql 2005 express cannot sync with sql 2005 express directly.

|||

SQL Server 2005 Express Edition supports being a replication subscriber only. See http://msdn2.microsoft.com/en-us/library/ms165700.aspx The publisher and distributor must be higher SKUs of SQL Server 2005. i.e. Enterprise, Standard, Workgroup. As for synching via IIS over the internet with merge replication, this is supported by the SQL Server 2005 Express client.

Hope this helps,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

|||

Peng Song wrote:

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

does the client (subscriber) running on sql server express has to have IIS or only the publishing pc? thanks

Does SP2 need to be installed on both development clients and serv

Does SP2 need to be installed on both the development clients and the server?
We have many development installs. If the SP changes are significant only
to the server then installing it there only would be much more effective for
us.
ThanksHere's the scoop (which is different than I initially thought, I thought you
did need to upgrade development but I guess it is optional):
>>>>>>
>clip
You don't absolutely need the service pack on your dev box as the schema
hasn't
changed and the designer didn't get too many fixes.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
> Does SP2 need to be installed on both the development clients and the
server?
> We have many development installs. If the SP changes are significant only
> to the server then installing it there only would be much more effective
for
> us.
> Thanks|||The changes are 95% on the server, not on the designer. The designer changes
were a couple of minor fixes. There were no schema changes in RDL so you
should be fine.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
> Does SP2 need to be installed on both the development clients and the
> server?
> We have many development installs. If the SP changes are significant only
> to the server then installing it there only would be much more effective
> for
> us.
> Thanks|||The changes are 95% on the server, not on the designer. The designer changes
were a couple of minor fixes. There were no schema changes in RDL so you
should be fine.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
> Does SP2 need to be installed on both the development clients and the
> server?
> We have many development installs. If the SP changes are significant only
> to the server then installing it there only would be much more effective
> for
> us.
> Thanks|||Note: if you don't upgrade the report designer to SP2, the report designer
PREVIEW will still generate the report output based on SP1, because it is
running the report locally and not on the server!
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OReYoWmSFHA.2784@.TK2MSFTNGP12.phx.gbl...
> Here's the scoop (which is different than I initially thought, I thought
> you
> did need to upgrade development but I guess it is optional):
>>>>>>
>>clip
> You don't absolutely need the service pack on your dev box as the schema
> hasn't
> changed and the designer didn't get too many fixes.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
>>>>>>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
> news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
>> Does SP2 need to be installed on both the development clients and the
> server?
>> We have many development installs. If the SP changes are significant
>> only
>> to the server then installing it there only would be much more effective
> for
>> us.
>> Thanks
>|||Brian,
What were the specific fixes to the Designer? We've seen some intermittent
problems with exporting to Excel from Preview in Designer. If the fixes
relate to that general area, that might further influence our decision.
"Brian Welcker [MS]" wrote:
> The changes are 95% on the server, not on the designer. The designer changes
> were a couple of minor fixes. There were no schema changes in RDL so you
> should be fine.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
> news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
> > Does SP2 need to be installed on both the development clients and the
> > server?
> > We have many development installs. If the SP changes are significant only
> > to the server then installing it there only would be much more effective
> > for
> > us.
> > Thanks
>
>|||Note: if you don't upgrade the report designer to SP2, the report designer
Preview will still generate the report output based on SP1 (or RTM), because
it is running the report locally and not on the server!
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:10FDA0EC-88CB-4898-996F-04879B94657A@.microsoft.com...
> Brian,
> What were the specific fixes to the Designer? We've seen some
> intermittent
> problems with exporting to Excel from Preview in Designer. If the fixes
> relate to that general area, that might further influence our decision.
> "Brian Welcker [MS]" wrote:
>> The changes are 95% on the server, not on the designer. The designer
>> changes
>> were a couple of minor fixes. There were no schema changes in RDL so you
>> should be fine.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
>> news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
>> > Does SP2 need to be installed on both the development clients and the
>> > server?
>> > We have many development installs. If the SP changes are significant
>> > only
>> > to the server then installing it there only would be much more
>> > effective
>> > for
>> > us.
>> > Thanks
>>
>>|||The report processing and rendering engine used in preview is the same that
is on the server. So, yes, there were several fixes in this area. Some are
listed in the KB article and some are not.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:10FDA0EC-88CB-4898-996F-04879B94657A@.microsoft.com...
> Brian,
> What were the specific fixes to the Designer? We've seen some
> intermittent
> problems with exporting to Excel from Preview in Designer. If the fixes
> relate to that general area, that might further influence our decision.
> "Brian Welcker [MS]" wrote:
>> The changes are 95% on the server, not on the designer. The designer
>> changes
>> were a couple of minor fixes. There were no schema changes in RDL so you
>> should be fine.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
>> news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
>> > Does SP2 need to be installed on both the development clients and the
>> > server?
>> > We have many development installs. If the SP changes are significant
>> > only
>> > to the server then installing it there only would be much more
>> > effective
>> > for
>> > us.
>> > Thanks
>>
>>

Does MS offer SQL Server 2000 for people who buy SQL Server 2005?

Does anyone know whether people who buy SQL Server 2005 can get a free copy
of SQL Server 2000 before moving to SQL Server 2005? Clients want to buy SQL
Server 2005 but some applications used by the clients only support SQL Server
2000 version until next year. So, clients want to know whether they can buy
SQL Server 2005 but get a free copy of SQL Server 2000 so they can use SQL
Server 2000 until all the applications are supporting 2005.
Thanks.Peter wrote:
> Does anyone know whether people who buy SQL Server 2005 can get a
> free copy of SQL Server 2000 before moving to SQL Server 2005?
> Clients want to buy SQL Server 2005 but some applications used by the
> clients only support SQL Server 2000 version until next year. So,
> clients want to know whether they can buy SQL Server 2005 but get a
> free copy of SQL Server 2000 so they can use SQL Server 2000 until
> all the applications are supporting 2005.
> Thanks.
You can usually get a downgrade license. Contact Microsoft for
clarification.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Does MS offer SQL Server 2000 for people who buy SQL Server 2005?

Does anyone know whether people who buy SQL Server 2005 can get a free copy
of SQL Server 2000 before moving to SQL Server 2005? Clients want to buy SQL
Server 2005 but some applications used by the clients only support SQL Server
2000 version until next year. So, clients want to know whether they can buy
SQL Server 2005 but get a free copy of SQL Server 2000 so they can use SQL
Server 2000 until all the applications are supporting 2005.
Thanks.
Peter wrote:
> Does anyone know whether people who buy SQL Server 2005 can get a
> free copy of SQL Server 2000 before moving to SQL Server 2005?
> Clients want to buy SQL Server 2005 but some applications used by the
> clients only support SQL Server 2000 version until next year. So,
> clients want to know whether they can buy SQL Server 2005 but get a
> free copy of SQL Server 2000 so they can use SQL Server 2000 until
> all the applications are supporting 2005.
> Thanks.
You can usually get a downgrade license. Contact Microsoft for
clarification.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Does MS offer SQL Server 2000 for people who buy SQL Server 2005?

Does anyone know whether people who buy SQL Server 2005 can get a free copy
of SQL Server 2000 before moving to SQL Server 2005? Clients want to buy SQ
L
Server 2005 but some applications used by the clients only support SQL Serve
r
2000 version until next year. So, clients want to know whether they can buy
SQL Server 2005 but get a free copy of SQL Server 2000 so they can use SQL
Server 2000 until all the applications are supporting 2005.
Thanks.Peter wrote:
> Does anyone know whether people who buy SQL Server 2005 can get a
> free copy of SQL Server 2000 before moving to SQL Server 2005?
> Clients want to buy SQL Server 2005 but some applications used by the
> clients only support SQL Server 2000 version until next year. So,
> clients want to know whether they can buy SQL Server 2005 but get a
> free copy of SQL Server 2000 so they can use SQL Server 2000 until
> all the applications are supporting 2005.
> Thanks.
You can usually get a downgrade license. Contact Microsoft for
clarification.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Documenting large numbers of SPs

Hi All,

I have a large number of SPs that I would like to be able to document and provide this documentation to prospective clients. That is, provide them enough information without giving them the source code for the procedures.

I have found that all the parameters are in the sys.parameters table.

But I was wondering. Are the fields that are sent back out of an SP captured and recorded somewhere in the SQL Server catalog?

Is there an easy way to find out what fields are coming out of an SP?

Thanks in Advance

Peter

You may be better served exploring one of the third party documentation tools.

I like ApexSQL's Doc tool.

You can download a fully functional eval version.

|||

Hi Arnie,

thanks for the tip...I'll take a look..

Peter

do you need the clients

If i use sql server as my backend and microsoft access as my frontend do i need to purchase client access lisences??yes,

have a look at the following

http://www.microsoft.com/windows2000/en/server/help/default.asp?url=/windows2000/en/server/help/sag_LICEconcepts_121.htm

http://www.microsoft.com/windows2000/en/server/help/default.asp?url=/windows2000/en/server/help/sag_LICEconcepts_122.htm

Cheers