Delete

I've got 2000-to-2000 immediate, one way, transactional replication set up.
I am curious about something: if I go into the Publishers tab on the server
that is the "master", i.e. distributor and right click on the publication one
of the options it gives me is "Delete". But I know it's critical that this
would be done correctly as before the publisher is deleted, it must delete
all subscriptions and articles.
If I hit delete, will this do all this cleaning out of subscriptions and
articles correctly?
No, it doesn't.. Delete the subscription first and then you can delete the
publication. Even after this, the articles don't get deleted.
but reading your previous posts, it looks like your publication will be set
to drop tables and recreate on subscriber... so, that would take care of it
or on subscriber, i assume you can do it manually...
Tej
|||Thx. That's what I thought. And if you leave anything orphaned, I've seen
it cause problems in times past. Again, thx for the help...
"Tejas Parikh" wrote:

> No, it doesn't.. Delete the subscription first and then you can delete the
> publication. Even after this, the articles don't get deleted.
> but reading your previous posts, it looks like your publication will be set
> to drop tables and recreate on subscriber... so, that would take care of it
> or on subscriber, i assume you can do it manually...
> Tej
|||Delete it. It will warn you that you are deleting existing subscriptions and
for the most part it will correctly clean up objects on the publisher and
subscriber.
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
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:CBAECE0E-2C1B-454F-8998-5CC0ED4D2A86@.microsoft.com...
> I've got 2000-to-2000 immediate, one way, transactional replication set
> up.
> I am curious about something: if I go into the Publishers tab on the
> server
> that is the "master", i.e. distributor and right click on the publication
> one
> of the options it gives me is "Delete". But I know it's critical that
> this
> would be done correctly as before the publisher is deleted, it must delete
> all subscriptions and articles.
> If I hit delete, will this do all this cleaning out of subscriptions and
> articles correctly?

Default templates in Query Analyzer

Hi all,

I've installed SQL Server 2000(SP2). The thing is in Query
Analyzer Templates tab, I can see all the templates folders
(eg: Attach and Detach Database, Create Database, etc) but
I can't seem to expand them. Looks like there's nothing in
it. I've specify my templates directory path under Options
but still there's no templates under those folders. Can
anyone help me?

Thank you in advance.
..In my Options settings, templates are specified to be in
C:\Program\Microsoft SQL Server\80\Tools\Templates\SQL Query Analyzer

The .tsql files are in subdirectories under that catalog.
Works fine with the Insert Templates menu option.|||Yep...works fine with the Insert Templates menu option. I've installed SP2, checked the templates file path in OPTIONS, and all the *.tql files are in C:\Program Files\Microsoft SQL Server\80\Tools\Templates\SQL Query Analyzer folder...
Anyone know what is going on?|||Where in Q.A. is that Templates tab where you can't expand?
I couldn't find it. If guide me , I'll have a look how it works at my machine.|||Can you post a snapshot of where you are having the problem in query analyzer ?|||Attached will be a screenshot of the problem...|||Try the following:

Change the directory option for the default template directory. See what it displays - then change it back.

Create your own template - save it in a template directory like create database and save it in the parent directory as well.

The template in the parent directory should appear directory under your templates folder in qa and under the create database folder - you may have to right on the folder templates and create database and refresh.

Let me know what happens.|||Hi rnealejr and all,

Tried changing the directory option for the default template directory. When I did a refresh, all the folders under Templates are gone. Changed back the templates defaulti path, same problem...folders that I can't expand.

Created my own template, save it to the templates directory under "Create Database", did a refresh, same result...folders that I can't expand even I did a couple of refreshes.

Any suggestions?

Thank you|||Create a template file in the parent directory - you should see the template file along with all the folders - let me know. Also, did you install the following service pack SQL2KSP2.exe ? And of course, the inevitable question - did you try to reinstall ?|||Created a template file in the parent directory, but still the same. Yes, I've installed SP2. I haven't tried to reinstalling yet.

Thank you|||Well since you have verified that it is not a folder mapping issue and no known documentation exists detailing this issue - I would reinstall.

Good luck.