cascade delete and merge rep

Hey everyone,
I'm currently running sql 2k sp3 and win2k3 with all of
the latest patches. I'm running merge replication in a
clustered environment. My question is in regards to the
cascade delete option for foreign keys. Whenever a delete
transaction is executed against the parent table with a
foreign key to a child table and the cascade delete option
enabled, merge replication refuses to replicate the
changes due to the merge profile (ChangesPerHistory =
2000, DownloadGenerationsPerBatch = 2000). If I change
the profile so the changes and generations are set to 10,
then it works, but it's painfully slow. Also, just
executing the delete takes forever. Deleting just 10
records from the parent table using the clustered
index/primary key column in the where clause takes almost
1 minute. Without the cascade option enabled, it takes
less than 1 second. Any ideas on why the cascade delete
option isn't working? If it helps, the two tables above
are fairly large, over 120 million records between the two
of them. Thanks.
What you should do is disable the enforcement of constraint for replication.
What this will mean is that the replication processs can add children
without parents.
What happens with merge replication is sometimes a child delete/update is
replicated before the corresponding parent child delete/update. By
increasing the generationsper batch hopefully the parent and child
modifications will happen in the same batch. If the child record
delete/update occurs before the corresponding parent delete/update the child
delete/update is rolled back and goes into a retry queue for that batch, and
when all the transactions are processed for that batch the records in the
retry queue are tried again. This time hopefully the child record makes it
in as the parent exists.
When you disable this constraint for replication, children can be added
without parents (assuming the parent will be replicated later).
Let me know how this works for you.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Leon" <anonymous@.discussions.microsoft.com> wrote in message
news:28c501c4a1a9$7327f540$a601280a@.phx.gbl...
> Hey everyone,
> I'm currently running sql 2k sp3 and win2k3 with all of
> the latest patches. I'm running merge replication in a
> clustered environment. My question is in regards to the
> cascade delete option for foreign keys. Whenever a delete
> transaction is executed against the parent table with a
> foreign key to a child table and the cascade delete option
> enabled, merge replication refuses to replicate the
> changes due to the merge profile (ChangesPerHistory =
> 2000, DownloadGenerationsPerBatch = 2000). If I change
> the profile so the changes and generations are set to 10,
> then it works, but it's painfully slow. Also, just
> executing the delete takes forever. Deleting just 10
> records from the parent table using the clustered
> index/primary key column in the where clause takes almost
> 1 minute. Without the cascade option enabled, it takes
> less than 1 second. Any ideas on why the cascade delete
> option isn't working? If it helps, the two tables above
> are fairly large, over 120 million records between the two
> of them. Thanks.
|||Leon,
We are currently improving this area for SQL 2005. Would you be willing to
work offline with me on reproducing your current problem?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OemHAtboEHA.596@.TK2MSFTNGP11.phx.gbl...
> What you should do is disable the enforcement of constraint for
> replication.
> What this will mean is that the replication processs can add children
> without parents.
> What happens with merge replication is sometimes a child delete/update is
> replicated before the corresponding parent child delete/update. By
> increasing the generationsper batch hopefully the parent and child
> modifications will happen in the same batch. If the child record
> delete/update occurs before the corresponding parent delete/update the
> child
> delete/update is rolled back and goes into a retry queue for that batch,
> and
> when all the transactions are processed for that batch the records in the
> retry queue are tried again. This time hopefully the child record makes it
> in as the parent exists.
> When you disable this constraint for replication, children can be added
> without parents (assuming the parent will be replicated later).
> Let me know how this works for you.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Leon" <anonymous@.discussions.microsoft.com> wrote in message
> news:28c501c4a1a9$7327f540$a601280a@.phx.gbl...
>
|||Philip,
Absolutely. I'll send you an email from my work account
so we can discuss.
Hilary,
I'll see if that works. Thanks for your help.

>--Original Message--
>Leon,
>We are currently improving this area for SQL 2005. Would
you be willing to
>work offline with me on reproducing your current problem?
>
>"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in
message[vbcol=seagreen]
>news:OemHAtboEHA.596@.TK2MSFTNGP11.phx.gbl...
constraint for[vbcol=seagreen]
can add children[vbcol=seagreen]
child delete/update is[vbcol=seagreen]
delete/update. By[vbcol=seagreen]
parent and child[vbcol=seagreen]
child record[vbcol=seagreen]
delete/update the[vbcol=seagreen]
queue for that batch,[vbcol=seagreen]
the records in the[vbcol=seagreen]
child record makes it[vbcol=seagreen]
children can be added[vbcol=seagreen]
later).[vbcol=seagreen]
message[vbcol=seagreen]
the[vbcol=seagreen]
delete[vbcol=seagreen]
option[vbcol=seagreen]
10,[vbcol=seagreen]
almost[vbcol=seagreen]
delete[vbcol=seagreen]
above[vbcol=seagreen]
two
>
>.
>

Can't view merge agent properties (trying again)

In Enterprise Manager (EM), if you go to: [Replication Monitor -> Agents ->
Merge Agents] you'll see a list of Merge Agents to the right.
I'd like to be able to select one of the items, right-click, and select
"Agent Properties".
When I do this, I get a dialog box that appears. The title of the dialog is
"Connect to SQL Server". It's looking for "Connection Information" and it
wants a Login name and Password.
Well, my SQL Server uses the sa user. So, I tried the sa user and it's
password. Nope!
The SQL Server Agent runs under a windows account. I tried that ID and it's
password. Nope!
The other strange thing about this is that my friend doesn't have this
problem on his laptop/SQL Server. He can view the agent properties no
problem. One difference we can detect is that his SQL Server uses a Windows
Account and mine uses sa. Not sure if that makes a difference.
I also went to [Security -> Logins] and added a new login and gave him every
available permission I could find (using the SQL Server Login Properties
Tabbed Dialg). I tried logging on with this guy. Nope!
So, sa doesn't work. The SQL Server Agent windows ID doesn't work. The new
Login guy didn't work. Ummm. What exactly is it looking for? But for some
reason, if I enter the ID and password I get the same MsgBox:
SQL Server Enterprise Manager
A connection could not be established to XXXX [3023].
Reason: SQL Server does not exist or access denied.
ConnectionOpen (Connect())..
Please verify SQL Server is running and check your SQL Server registration
properties (by right-clicking on the XXXX [3023] node) and try again.
Thanks in advance,
William Campbell
Hi.
Maybe I mis-read the msdn web page, but I am reading this (about managed
newsgroups):
a.. Unlimited on-line technical support - keep your PSS incidents
a.. A commitment to respond to your post within two business days
The thing is, this hasn't happened. Did I incorrectly enter my post
somehow? It's been more than 2 business days.
Thanks,
William Campbell
"MSDN-Managed" <NO_SPAM> wrote in message
news:9DB1BD5B-54AA-4CA9-BD40-48084F121F8A@.microsoft.com...
> In Enterprise Manager (EM), if you go to: [Replication Monitor ->
Agents ->
> Merge Agents] you'll see a list of Merge Agents to the right.
> I'd like to be able to select one of the items, right-click, and select
> "Agent Properties".
> When I do this, I get a dialog box that appears. The title of the dialog
is
> "Connect to SQL Server". It's looking for "Connection Information" and it
> wants a Login name and Password.
> Well, my SQL Server uses the sa user. So, I tried the sa user and it's
> password. Nope!
> The SQL Server Agent runs under a windows account. I tried that ID and
it's
> password. Nope!
> The other strange thing about this is that my friend doesn't have this
> problem on his laptop/SQL Server. He can view the agent properties no
> problem. One difference we can detect is that his SQL Server uses a
Windows
> Account and mine uses sa. Not sure if that makes a difference.
> I also went to [Security -> Logins] and added a new login and gave him
every
> available permission I could find (using the SQL Server Login Properties
> Tabbed Dialg). I tried logging on with this guy. Nope!
> So, sa doesn't work. The SQL Server Agent windows ID doesn't work. The
new
> Login guy didn't work. Ummm. What exactly is it looking for? But for
some
> reason, if I enter the ID and password I get the same MsgBox:
> --
> SQL Server Enterprise Manager
> --
> A connection could not be established to XXXX [3023].
> Reason: SQL Server does not exist or access denied.
> ConnectionOpen (Connect())..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right-clicking on the XXXX [3023] node) and try again.
> Thanks in advance,
> William Campbell
>
|||The problem appears to be that you're not using a posting alias that you've
registered with MSDN. You can start that process using the Register link on
this page: http://msdn.microsoft.com/newsgroups/managed/. The MSDN team that
monitors this newsgroup looking for those posts is using a tool that points
out the posts from Managed Customers and your posting address isn't
appearing as one.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"William Campbell" <NO_SPAM_AT_WILLIAM_CAMPBELL> wrote in message
news:OWjeHj%232EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Hi.
> Maybe I mis-read the msdn web page, but I am reading this (about managed
> newsgroups):
> a.. Unlimited on-line technical support - keep your PSS incidents
> a.. A commitment to respond to your post within two business days
> The thing is, this hasn't happened. Did I incorrectly enter my post
> somehow? It's been more than 2 business days.
> Thanks,
> William Campbell
> "MSDN-Managed" <NO_SPAM> wrote in message
> news:9DB1BD5B-54AA-4CA9-BD40-48084F121F8A@.microsoft.com...
> Agents ->
> is
> it's
> Windows
> every
> new
> some
>
|||Hmm. But I did. The "MSDN-Managed" newgroup post (the original, not the
one with my name) is using the ID that is registered with our Universal
subscription.
I went to the link you mentioned (a few days ago), made sure that I gave our
ID an alias so that our email address didn't appear (thus, the alias
MSDN-Managed and the "NO_SPAM" email address). And submitted the post
through the web interface from the same link you displayed (you sign-in
through that passport account to the web interface).
That's why I'm confused. I went through all the steps. The one from
"MSDN-Managed" (not "William Campbell") is using our subscription id.
William Campbell
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:uRWmYw%232EHA.2788@.TK2MSFTNGP15.phx.gbl...
> The problem appears to be that you're not using a posting alias that
you've
> registered with MSDN. You can start that process using the Register link
on
> this page: http://msdn.microsoft.com/newsgroups/managed/. The MSDN team
that
> monitors this newsgroup looking for those posts is using a tool that
points
> out the posts from Managed Customers and your posting address isn't
> appearing as one.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> Please reply to the newsgroups only, thanks.
> "William Campbell" <NO_SPAM_AT_WILLIAM_CAMPBELL> wrote in message
> news:OWjeHj%232EHA.2540@.TK2MSFTNGP09.phx.gbl...
dialog[vbcol=seagreen]
Properties[vbcol=seagreen]
The
>
|||Hmm, I'll have a chat with the manager of that team then, as our internal
tool clearly isn't picking it up, and get somebody to look at your post.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"William Campbell" <NO_SPAM_AT_WILLIAM_CAMPBELL> wrote in message
news:ud31bc$2EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Hmm. But I did. The "MSDN-Managed" newgroup post (the original, not the
> one with my name) is using the ID that is registered with our Universal
> subscription.
> I went to the link you mentioned (a few days ago), made sure that I gave
> our
> ID an alias so that our email address didn't appear (thus, the alias
> MSDN-Managed and the "NO_SPAM" email address). And submitted the post
> through the web interface from the same link you displayed (you sign-in
> through that passport account to the web interface).
> That's why I'm confused. I went through all the steps. The one from
> "MSDN-Managed" (not "William Campbell") is using our subscription id.
> William Campbell
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:uRWmYw%232EHA.2788@.TK2MSFTNGP15.phx.gbl...
> you've
> on
> that
> points
> rights.
> dialog
> Properties
> The
>
|||Is there a timeframe for this? It's been a few days (and 8 days since my
initial post under this "Msdn-Managed" ID).
Are you saying that this ID that I'm posting under right now ... doesn't
show up as someone with a Universal account? Currently I'm at the web
interface. I'm signed in. Next to the Sign In/Sign Out button is another
smaller button that you can edit a profile. I looked there and didn't see
anything that I could "check" or fill in that I didn't already.
This is the ID that we have associated with our Univeral account. So, I'm
confused. If it's not showing up as valid - can we take care of the issue so
that it does show up as valid? Because I'm not sure what else I can do here
- and It's been weeks since my initial post.
Thanks,
William Campbell
"Stephen Dybing [MSFT]" wrote:

> Hmm, I'll have a chat with the manager of that team then, as our internal
> tool clearly isn't picking it up, and get somebody to look at your post.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Please reply to the newsgroups only, thanks.
> "William Campbell" <NO_SPAM_AT_WILLIAM_CAMPBELL> wrote in message
> news:ud31bc$2EHA.3616@.TK2MSFTNGP11.phx.gbl...
>
>
|||Have you sent email to ngmsdnfb@.microsoft.com about this yet? The managers
of that team are on that alias and will get back to you fairly quickly. I'm
going to forward this along to them, but you might as well send them mail
yourself as well.
It doesn't look to me like you've followed the directions to set up a valid
posting address that can be recognized by our system and until you do so, I
believe that you're going to have this problem. Here are instructions for
registering:
1. Use the passport associated with your MSDN subscription to login at
http://msdn.microsoft.com/subscriptions/.
2. On the What's Hot tab, click the <here> link at the end of the first
paragraph of the "Unlimited Support" section, which takes you to the
registration page.
3. Pick a nickname and domain. For example, you could use johndoe for the
Nickname and @.nospam.nospam as the domain. Click the [Submit] button and it
should register johndoe@.nospam.nospam as your no-spam alias. That alias may
or may not be available. We are experiencing an intermittent problem with
this page where a link goes down and rejects all submissions. If the alias
you select gets rejected, please try waiting 10-15 minutes before trying
again.
When you successfully register we attempt to popup a page with more
information. It explains how to configure your profile, among other things.
If you have popups blocked, the link is:
http://msdn.microsoft.com/subscripti...gednewsgroups/
Once you've successfully registered your account, you'll need to start
posting using is, not the <NO_SPAM> address you used for this post.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"MSDN-Managed" <NO_SPAM> wrote in message
news:33FC6C3D-AF7D-4DAA-8E04-1C2E7944EC39@.microsoft.com...
> Is there a timeframe for this? It's been a few days (and 8 days since my
> initial post under this "Msdn-Managed" ID).
> Are you saying that this ID that I'm posting under right now ... doesn't
> show up as someone with a Universal account? Currently I'm at the web
> interface. I'm signed in. Next to the Sign In/Sign Out button is another
> smaller button that you can edit a profile. I looked there and didn't see
> anything that I could "check" or fill in that I didn't already.
> This is the ID that we have associated with our Univeral account. So, I'm
> confused. If it's not showing up as valid - can we take care of the issue
so
> that it does show up as valid? Because I'm not sure what else I can do
here[vbcol=seagreen]
> - and It's been weeks since my initial post.
> Thanks,
> William Campbell
> "Stephen Dybing [MSFT]" wrote:
internal[vbcol=seagreen]
rights.[vbcol=seagreen]
the[vbcol=seagreen]
Universal[vbcol=seagreen]
gave[vbcol=seagreen]
sign-in[vbcol=seagreen]
link[vbcol=seagreen]
team[vbcol=seagreen]
post[vbcol=seagreen]
Information"[vbcol=seagreen]
ID[vbcol=seagreen]
this[vbcol=seagreen]
properties no[vbcol=seagreen]
a[vbcol=seagreen]
him[vbcol=seagreen]
work.[vbcol=seagreen]
But[vbcol=seagreen]
again.[vbcol=seagreen]
|||William, would you please send me your email address at
stephd@.microsoft.com? I've been chatting with one of the managers of the
Managed Newsgroup support team and he'd like to talk to you directly. If
you'll send me your email address, I'll have him contact you.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:uhBxoGT4EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Have you sent email to ngmsdnfb@.microsoft.com about this yet? The managers
> of that team are on that alias and will get back to you fairly quickly.
I'm
> going to forward this along to them, but you might as well send them mail
> yourself as well.
> It doesn't look to me like you've followed the directions to set up a
valid
> posting address that can be recognized by our system and until you do so,
I
> believe that you're going to have this problem. Here are instructions for
> registering:
> 1. Use the passport associated with your MSDN subscription to login at
> http://msdn.microsoft.com/subscriptions/.
> 2. On the What's Hot tab, click the <here> link at the end of the first
> paragraph of the "Unlimited Support" section, which takes you to the
> registration page.
> 3. Pick a nickname and domain. For example, you could use johndoe for the
> Nickname and @.nospam.nospam as the domain. Click the [Submit] button and
it
> should register johndoe@.nospam.nospam as your no-spam alias. That alias
may
> or may not be available. We are experiencing an intermittent problem with
> this page where a link goes down and rejects all submissions. If the alias
> you select gets rejected, please try waiting 10-15 minutes before trying
> again.
> When you successfully register we attempt to popup a page with more
> information. It explains how to configure your profile, among other
things.
> If you have popups blocked, the link is:
> http://msdn.microsoft.com/subscripti...gednewsgroups/
> Once you've successfully registered your account, you'll need to start
> posting using is, not the <NO_SPAM> address you used for this post.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> Please reply to the newsgroups only, thanks.
> "MSDN-Managed" <NO_SPAM> wrote in message
> news:33FC6C3D-AF7D-4DAA-8E04-1C2E7944EC39@.microsoft.com...
my[vbcol=seagreen]
another[vbcol=seagreen]
see[vbcol=seagreen]
I'm[vbcol=seagreen]
issue[vbcol=seagreen]
> so
> here
> internal
post.[vbcol=seagreen]
> rights.
not[vbcol=seagreen]
> the
> Universal
> gave
post[vbcol=seagreen]
> sign-in
from[vbcol=seagreen]
id.[vbcol=seagreen]
message[vbcol=seagreen]
that[vbcol=seagreen]
> link
> team
that[vbcol=seagreen]
> post
Monitor ->[vbcol=seagreen]
the[vbcol=seagreen]
> Information"
and[vbcol=seagreen]
> ID
have[vbcol=seagreen]
> this
> properties no
uses[vbcol=seagreen]
> a
gave
> him
> work.
> But
> again.
>
|||Test - did this work? Hopefully it picks up my post now.
|||I still don't think you're following the directions. Your posting address
appears to be set to "NO_SPAM" and that is not one of the valid choices from
the registration page that I have pointed out a couple of times, there's no
domain listed. I'm including the directions again below. Please choose a
nickname and enter it in the nickname box (and it would be a very good idea
to make it more unique than "NO_SPAM" and then pick one of the domains from
the choose a domain drop-down list box. Then after as it's registered,
you'll need to use that full email address as your posting address. This
isn't a free service so we need to make it unique enough to ensure that
you're the only one using that alias.
1. Use the passport associated with your MSDN subscription to login at
http://msdn.microsoft.com/subscriptions/.
2. On the What's Hot tab, click the <here> link at the end of the first
paragraph of the "Unlimited Support" section, which takes you to the
registration page.
3. Pick a nickname and domain. For example, you could use johndoe for the
Nickname and @.nospam.nospam as the domain. Click the [Submit] button and it
should register johndoe@.nospam.nospam as your no-spam alias. That alias may
or may not be available. We are experiencing an intermittent problem with
this page where a link goes down and rejects all submissions. If the alias
you select gets rejected, please try waiting 10-15 minutes before trying
again.
When you successfully register we attempt to popup a page with more
information. It explains how to configure your profile, among other things.
If you have popups blocked, the link is:
http://msdn.microsoft.com/subscripti...gednewsgroups/
Once you've successfully registered your account, you'll need to start
posting using it, not the <NO_SPAM> address you used again for this post.
Mitch should be following up with you today via email.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"MSDN-Managed" <NO_SPAM> wrote in message
news:E42F00CD-59D8-493F-B94A-05737B1F8082@.microsoft.com...
> Test - did this work? Hopefully it picks up my post now.

Can't use replication after renaming server. Please help!

Hello all,
I have a server that was named "AlienDB" running SQL Server. I renamed the
server to "StagingAlienDB1" and now I am having problems configuring
replication.
When I try to do anything such as create a new Publication, SQL Server
immediately shows me a message box containing the following:
"SQL Server is unable to connect to the server 'StagingAlienDB1'.
Additional Information
SQL Server replication requires the actual server name to make a connection
to the server. Connections through a server alias, IP address, or any other
alternate name are not supported.
Specify the actual server name, 'ALIENDDB'. (Replication.Utilities)"
I tried looking for a way to perhaps change an old reference from ALIENDB to
StagingAlienDB1 but I couldnt find anything. What can I do?
Johnny
Try to disable replication, un register the server, re-register it with its
new name, recreate replication and then rebuild your publications and
subscriptions.
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" <Johnny@.discussions.microsoft.com> wrote in message
news:93919DD0-5A3E-4018-9D25-41883944366D@.microsoft.com...
> Hello all,
> I have a server that was named "AlienDB" running SQL Server. I renamed the
> server to "StagingAlienDB1" and now I am having problems configuring
> replication.
> When I try to do anything such as create a new Publication, SQL Server
> immediately shows me a message box containing the following:
> "SQL Server is unable to connect to the server 'StagingAlienDB1'.
> Additional Information
> SQL Server replication requires the actual server name to make a
connection
> to the server. Connections through a server alias, IP address, or any
other
> alternate name are not supported.
> Specify the actual server name, 'ALIENDDB'. (Replication.Utilities)"
> I tried looking for a way to perhaps change an old reference from ALIENDB
to
> StagingAlienDB1 but I couldnt find anything. What can I do?
> Johnny
|||If you are using sql 2000 try this. I'm not sure if it works for 7.0.
Run Select @.@.Servername
if this name is not the actual name of the server use the following to
fix:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
|||Thanks. This worked!
"seanbell68@.gmail.com" wrote:

> If you are using sql 2000 try this. I'm not sure if it works for 7.0.
> Run Select @.@.Servername
> if this name is not the actual name of the server use the following to
> fix:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
>
|||Have just tried this to resolve the same problem on SQL 2005 and it worked
perfectly. Thanks!
USE MASTER
GO
SP_DROPSERVER 'OLDNAME'
GO
USE MASTER
GO
SP_ADDSERVER 'NEWNAME', 'LOCAL'
GO
url:http://www.ureader.com/msg/11561162.aspx

cant use replication

ive installed sql 2005 enterprise and wanted to make a replication between 2 servers but when i rightclick the replication folder in the server management studio express - i can only create a subscriber. ive also tried going through tools but theres nothing in that menu.

ive wondered, is it maybe possible the i cant create a publisher because of the management studio express - do i also need a enterprise edition of the management studio?

ive also checked in add and remove programs - went to mssql 2005 and checked in change components and in there it ses that the replication components are installed =/

wud b gr8 if u cud help me, need this for an egsam i got on the 18th
thank you very very much in beforehand =P

sql server 2005 express edition only supports as subscriber...

May either you have connected to express edition sql server or ssms express may not support...

You may need to install regular client components from EE/SE/DE edtions cd...

Check the following link for SQL Server 2005 Features Comparison...

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||ive got the enterprise odition of mssql its just the management studio that is express.
in this case i need a different version of management studio?
where can i get it from? i havent got a cd - i downloaded it from the microsoft homepage

can someone PLEASE help me out here? even if its a "i doubt that it will work" =/
|||

Hi eniGMa,

You have to configure the Distributor firstly and then the Publisher.

Go to the Instance that you want to set Replication up. Right click on the Replication folder and click "Configure Distribution...".

After configuring the Distribution, configure the Publisher. Go to the Replication folder and click the + sign near it and expand the folder. Right click on the Local Publications folder and then click "New Publication" after setting it up you may configure the necessary Publications to Subscribers.

For more information visit the MSDN:

http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Ekrem ?nsoy

MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE

|||hi, ive checked the msdn page - the only thing i can create is a subscriber, nothing else
and when i click that, it tells me that it needs a publisher
|||

Hi eniGMa,

Replication system consists of Publisher, Distributor and Subscriber.

Publisher is the one what hosts the publications.

Distributor is the one which publishes the publications (from Publisher) to Subscribers.

Subscriber is the one what pulls (or pushed by the Publisher) data from Distributor.

Distributor and Publisher may be host on the same server if there is not huge workload on that SQL Server.

So according to this frame, you need to set Publisher and Distributor first.

You may configure these by help of the MSDN page which i posted before.

And then read my prior first answer again.

Ekrem ?nsoy
MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE

|||thats egsactly my point - the only thing i can create is a subscriber
nothing else (ive read through the rest of the theory)

ive got the enterprise edition of mssql server installed, only thing where it sais express is the management studio (which i cant install from the sql server installation file, so i downloaded it from download.microsoft.com)

when i rightclick the replication folder - subscriber (no publisher and no distributor)
and when i click on tools (same thing)
|||

I see that you misconfigured setup of SQL Server.

Because you can install SSMS (SQL Server Management Studio) from the Components to Install menu which appears when you were setting up SQL Server.

When you see Components to Install dialog box, click Advanced and dig into the items to be installed.

After opening Advanced dialog box, you will see: "Workstation Components, Books Online, and Development Tools" There is SSMS in it. Expand the item and you'll see it.

My concern about your Replication problem is, you may be deselecting or forgetting selecting something when you were setting up the SQL Server. Replication choice is in the "SQL Server Database Services" item in the same Advanced dialog box.

Please check these items carefully while setting up SQL Server.

Try to set SQL Server up again by taking care of these things.

Ekrem ?nsoy

MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE|||that worked - maybe it didnt work on the 1st time because ssms express was installed, when i installed it the 1st time and then i couldnt install it as an additional installation, even if removed afterwards

thnx a LOT!

Can't Update Identity Column in Transactional rep.

Hi,
I have Transactional replication setup where at PUBLISHER 90% of my tables
have PK Auto Increment. Which replicated to SUBSCRIBER.
Publisher(Publishing database) get updated by Importer(In-House tool)
Subcriber get updated by Publisher as well from Website and needs to have PK
Auto Incremental enable.
So what have done is to set up different kind of range at Publisher (odd
number) and Subscriber(even number) for Identity Seed.
Also have modify the SP (sp_MSins) with SET IDENTITY_INSERT TABLE ON.
But I am keep getting error that can't update Identity column X and
reference to sp_MSUpd_
Could any one please let me know why I am getting this error, as SET
IDENTITY_INSERT TABLE ON is only when you inserting records not updating
records?
Shan
This is usually a compilation error from the stored procedure. Do you have
the identity attribute existing on the subscriber tables? If so, it
shouldn't be there for vanilla transactional replication as the identity
values are maintained by the publisher only. For queued updating subscribers
the identity property exists, but the stored procedures have a modified
syntax.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)