if repl is already setup, u can add a new table if you like via the gui or syntax. Since you are asking, you should do it via the...

NULL will never equal to NULL if you write it like @variable = NULL.

Write it as @variable IS NULL

And what's the exact error?

is your smtp server setup correctly? does the smtp server allow your ip address to be a relay?

look up dbmail setup in BOL to see the status of those...

sp_addlinkedserver is the syntax you want to use

it allows you to query remote servers w/o having to actually connect to it.

[from serverA]

exec serverb...sp_who2 active

haven't tried this myself but would it be possible create multiple publication based on 1 table and use filtering?

he would have to drop all the articles if they are part of one publication, which means, the snapshot will send everything to the subscribers.

you can always break out your...

on the subscriber, you can look under the replication hive and see local subscription. If that's there, then the database that you are replication is being replicated.

or you can...

you can see what happens during replication via SQL profiler.

you can use the group by statement to find your dupes and based on the group by, write a delete statement to nuke it.

you can also use the OUTPUT function...

padmaja.mantha (4/29/2008)

---

The select statement would give me all the records from the import table. I am able to do the bulk insert, but the problem is for just one field,...

figured it out

Declare @value_list varchar(500)

, @sql nvarchar(max)

Set @value_list = '''attribute'', ''catalog_object'''

set @sql = 'Select count(*) from tranrepl

Where articleName...

err that means that the snapshot isn't completed yet and that you should wait until it is done.

also if you are using 'For Replication Only' or whatever mode, snapshot won't...

are you using snapshot with your transactional replication?

How many commands are sitting in the queue?

waiting for the server to response means that the distribution agent is reading the cmd table and preparing those to be replicated. ...

I had that table with varchar(20) on both servers. I also had other tables, one of them is named 'attribute'.

when I originally scripted it out, every table had it...