Go to your distribution server and examine the publication_type column in the table distribution.dbo.mspublications. Values are :

0 = transactional

1 = snapshot

2 = merge

Mike

This should help:

use distribution

go

declare@iPublisherDBIdint

select@iPublisherDBId = d.id

frommspublisher_databases d

inner join

master..sysservers s

on s.srvid = d.publisher_id

where s.srvname = 'Server A'

exec sp_browsereplcmds @publisher_database_id = @iPublisherDBId,

@xact_seqno_start = N'0x0002E17D00035CAA0008',

@xact_seqno_end = N'0x0002E17D00035CAA0008',

@command_id = 1

Mike

To fix your problem I'm guessing you will have to change the name in the relevant tables in the distribution database. There are a number of tables, e.g. mslogreader_agents, msdistribution_agents,...

I think you will find that the result is the same type as the numeric expression so 2 is type int therefore you get zero. Try something like:

SELECT POWER(CONVERT(float,2),-3)

Hope that...

Try one of these:

if searching for a tab

select name from address where name like '%' + CHAR(9) + '%'

or

select name from address where CHARINDEX(CHAR(9),name) > 0

Please also be aware that...

You just need to double up the single quotation mark:

select name from address where name like '%''%'

Mike

I'm assuming the second requirement is for the day number of the EndDate relative to the current year as in a Julian date. Therefore try:

SELECTDATEDIFF(DD,dateStart,DateEnd) AS DaysDiff,

DATEDIFF(DD,CONVERT(datetime,CONVERT(char(4),YEAR(dateEnd)) + '0101'),dateEnd) +...

When the distribution agent is waiting because it is blocked have you run sp_lock (passing the spid of the distribution agent) to see which table it is being blocked on?...

From your post I assume you are looking for a bit of code that can take a string and format in the way you have stated.

This might help:

DECLARE@vcStrvarchar(100),

@vcResultvarchar(200),

@iStartint,

@iLenint,

@iSpaceAtint

SET @vcStr =...

If it's not too muck work, I think you are making the right decision.

If you get round to generating scripts using SQL Server 2005 Management Studio against your SQL Server...

Having been through this exercise myself, I would recommend starting from scratch. Generating a script from Enterprise Manager will give you a lot of grief because you potentially wind up...

SQL Server replication does not keep any information regarding users so you won't find what you are looking for unfortunately.

I think you will find you can't INSERT .... EXEC into a table variable in SQL Server 2000. It has to be SQL Server 2005 or higher.

Why not just use...

It would be interesting to know why you need to disable the trigger. I'm guessing that dropping the trigger and then re-creating it is not an option as I'm sure...

If this is indeed what he wants to do, what's wrong with using a built-in function like CHARINDEX?

Mike