Replication error in Snapshot publication

Hi,
I built a database replication between 2 SQL 2000 servers in our domain
(both with SP3). I used snapshot publication and it worked for a few days.
But one day the Distribution Agent task failed with the following,
Error message:
Line 95: Incorrect syntax near 'DROP TABLE '.
Error details:
Line 95: Incorrect syntax near 'DROP TABLE '.
(Source: CAWLKW05 (Data source); Error number: 170)
------
Line 102: Incorrect syntax near 'SELECT * INTO '.
(Source: CAWLKW05 (Data source); Error number: 170)
------
Please suggest
Thanks
Johnny H.
can you script out the schema of the articles you are replicating and post
them here along with your publication script?
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
"Johnny Hu" <Johnny Hu@.discussions.microsoft.com> wrote in message
news:A5490840-428B-4025-B3DD-80536F81DE5F@.microsoft.com...
> Hi,
> I built a database replication between 2 SQL 2000 servers in our domain
> (both with SP3). I used snapshot publication and it worked for a few
days.
> But one day the Distribution Agent task failed with the following,
> Error message:
> Line 95: Incorrect syntax near 'DROP TABLE '.
> Error details:
> Line 95: Incorrect syntax near 'DROP TABLE '.
> (Source: CAWLKW05 (Data source); Error number: 170)
> ----
--
> Line 102: Incorrect syntax near 'SELECT * INTO '.
> (Source: CAWLKW05 (Data source); Error number: 170)
> ----
--
> Please suggest
> Thanks
> Johnny H.

Replication and Different Domains

Hi guys,
We have a client who wants to set up the publisher (for merge
resplication) on a particular domain, but the subscribers will be on a
different domain. Is this even possible?
The main question was about the snapshot folder location. Is there a way
for the subscriber to get access to the folder being on a different domain?
Thanks,
Maer
You could have a look at
http://www.replicationanswers.com/InternetArticle.asp for details of
non-trusted setup. If there is a posibility of setting up a trust (or VPN)
then things are pretty straightforward.
HTH,
Paul Ibison
|||Hi Paul - Thank you so much for the article, it was extremely helpful!
Maer
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:7A661F57-4BB5-4D0C-9936-0A358E71683D@.microsoft.com...
> You could have a look at
> http://www.replicationanswers.com/InternetArticle.asp for details of
> non-trusted setup. If there is a posibility of setting up a trust (or VPN)
> then things are pretty straightforward.
> HTH,
> Paul Ibison
>

Replication

We have two systems one that has a domain setup and the other is a workgroup. We have them connected over a non-trusted internet connection. We are using SQL Server 2005 Enterprise version, for Peer-to-Peer transactional replication, the server that hasa domain, is called EXT-FRMAC1 and the other one is FRMAC_DC. FRMAC_DC can subscribe to EXT-FRMAC1's publication, but EXT-FRMAC1 can't subscribe to FRMAC_DC, and the error that we get on FRMAC_DC, is that FRMAC_DC\admin - username or password does not exist. admin exists on FRMAC_DC, I am not sure if we should try and put it on a domain or not.

Thanks.

Have you tried to setup with a SQL server account instead of Windows account?

Gary

Replicating specific data

Hi All,
We are in healthcare domain and we have a complete package written in VB6
and SQL Server 2000. We have installed in one of our clients. This client is
actually part of a chain of hospitals. Each hospital can have patients
registered with them. Also, this patient could also go to other hospitals
within the chain.
My question is, What is the best way to share the patient information. One
option would be to have a central repository. Another option would be for
the hospital to request for the patient information from the hospital he was
registered with. Is this possible. Can I just replicate a specific patient
information data. We are looking for the cheapest solution. Right now, we
are planning to give each hospital within the chain, a location code and
patient ID will be generated with this code prefix.
Also, what are the options for me to send this data across.
Any advise, please...
Raju
You could use replication for this, but you will have to handle data
ownership. So if you replicate patient data from a central repository to a
branch office and make changes to it there, do you want it to stay at the
branch office, or do you want these changes to go back to the central
repository.
What criteria would cause data to flow? For instance what event would
trigger data to move to the branch office from the central repository. What
portion of the data would move? Would it be a subset of the data, or the
entire history. For instance accounting data could probably stay, but his
vitals, and medical history would have to be copied.
I think you will find that most of your data would have to be global. In
this case a remote access option where everyone connects to the central
repository via terminal services, or a web application would probably work
best.
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
"Raju Joseph" <vze24srd@.msn.com> wrote in message
news:%23gYvlIAGGHA.3856@.TK2MSFTNGP12.phx.gbl...
> Hi All,
> We are in healthcare domain and we have a complete package written in VB6
> and SQL Server 2000. We have installed in one of our clients. This client
> is actually part of a chain of hospitals. Each hospital can have patients
> registered with them. Also, this patient could also go to other hospitals
> within the chain.
> My question is, What is the best way to share the patient information. One
> option would be to have a central repository. Another option would be for
> the hospital to request for the patient information from the hospital he
> was registered with. Is this possible. Can I just replicate a specific
> patient information data. We are looking for the cheapest solution. Right
> now, we are planning to give each hospital within the chain, a location
> code and patient ID will be generated with this code prefix.
> Also, what are the options for me to send this data across.
> Any advise, please...
> Raju
>
|||Unfortunately, that can't be answered. You have very strict privacy
requirements as well as very strict controls on the data. Before you can
start looking at putting in an infrastructure to distribute data, you first
have to find out whether you even can and if you can, what business rules
does it need to be governed under. That is going to tell you whether you
have a central repository or whether you are distributing data. It will
also tell you if changes to the data is allowed at multiple locations.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Raju Joseph" <vze24srd@.msn.com> wrote in message
news:%23gYvlIAGGHA.3856@.TK2MSFTNGP12.phx.gbl...
> Hi All,
> We are in healthcare domain and we have a complete package written in VB6
> and SQL Server 2000. We have installed in one of our clients. This client
> is actually part of a chain of hospitals. Each hospital can have patients
> registered with them. Also, this patient could also go to other hospitals
> within the chain.
> My question is, What is the best way to share the patient information. One
> option would be to have a central repository. Another option would be for
> the hospital to request for the patient information from the hospital he
> was registered with. Is this possible. Can I just replicate a specific
> patient information data. We are looking for the cheapest solution. Right
> now, we are planning to give each hospital within the chain, a location
> code and patient ID will be generated with this code prefix.
> Also, what are the options for me to send this data across.
> Any advise, please...
> Raju
>
|||Actually the majority of my clients are in the health care industry.
Replication is huge there, especially in the SQL CE space.
For example a doctor goes into the office and picks up a his pocketPC from
its cradle which has complete information about the patients he is going to
see that day. While he sees the patient and makes entries in the chart the
entries in the Medical Record are synchronized with the central office. His
appointment schedule is updated, certain actions he does are sent to the
clinic's front desk for processing (for example he requires tests, exams,
blood work, etc). Replication is the engine here.
There are mobile medical clinics which see patients in the field (nursing
homes, community centers, etc). Patient records are transferred to these
mobile clinics, and insurance information (especially MediCal, MediCare, and
Social Security) is checked and verified. At night it is sync'd back.
Again replication is the engine.
There are many pharmaceutical industries which receive data nightly and
process it for the morning and then send it back to hospitals. Replication
again is the engine.
All this is done with strict regard to regulatory compliance, privacy
concerns, and HIPPA.
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
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:O9zfYJIGGHA.3896@.TK2MSFTNGP15.phx.gbl...
> Unfortunately, that can't be answered. You have very strict privacy
> requirements as well as very strict controls on the data. Before you can
> start looking at putting in an infrastructure to distribute data, you
> first have to find out whether you even can and if you can, what business
> rules does it need to be governed under. That is going to tell you
> whether you have a central repository or whether you are distributing
> data. It will also tell you if changes to the data is allowed at multiple
> locations.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "Raju Joseph" <vze24srd@.msn.com> wrote in message
> news:%23gYvlIAGGHA.3856@.TK2MSFTNGP12.phx.gbl...
>

Replicating Permissions

My reports are currently configured so that only certain users on the
domain can access certain reports. I have installed another server at
a remote location that will need to have the same permissions as the
first one. Is there a way to replicate the security settings without
having to set the permissions manually each time?
Is there a security configuration file somewhere on the first server
that i could move over to the second, since they are pretty much the
same?
Thank you!You may want to check the following tool courtesy of Jasper Smith:
http://www.sqldbatips.com/showarticle.asp?ID=62
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1113533808.430998.255460@.f14g2000cwb.googlegroups.com...
> My reports are currently configured so that only certain users on the
> domain can access certain reports. I have installed another server at
> a remote location that will need to have the same permissions as the
> first one. Is there a way to replicate the security settings without
> having to set the permissions manually each time?
> Is there a security configuration file somewhere on the first server
> that i could move over to the second, since they are pretty much the
> same?
> Thank you!
>|||Thanks for your Reply. The app you refered me to helps me replicate
the reports and user roles to multiple servers, but it does not
replicate the security permissions for each folder nor the report. Is
there a script that can accomplish this task?
Thanks!|||Jasper Smith may add this kind of functionality to the tool in a future
release.
On RS 2000 you would have to do this through the SOAP API (ListChildren,
GetProperties, GetPermissions, etc.)
The Management Studio for the upcoming SQL Server 2005 release of Reporting
Services will allow you to generate a script to capture that state and then
apply it to another server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1113572435.510884.55430@.z14g2000cwz.googlegroups.com...
> Thanks for your Reply. The app you refered me to helps me replicate
> the reports and user roles to multiple servers, but it does not
> replicate the security permissions for each folder nor the report. Is
> there a script that can accomplish this task?
> Thanks!
>