I have had this error before and it stemmed from schema differences between the publisher and subscriber.

When I received the error there would be an error hidden the the transaction...

I have had a similar problem.  Do you have the exact same mail profile name on each node.  and have that profile configured identically.  The sql server is clustered but...

backup the table/db first

delete from student

where sno not in (select min(sno) from test group by sname)

create table transfer(sno int identity, sname varchar(10))

insert into transfer select sname from student

Check to make...

I was trying to use pure perl. The reason that we are using perl instead of SQL is we wrote a set of tools that work accross all of our...

In your query you can put a case statement

case when is null then '' else value

In the boot.ini is the /3GB switch set.

Thanks for the feedback so far.  A two stage commit option is not required for this solution but we do need near real time.  My software problems is that the vendor...

The error 50000 is not a SQL Defined error.  It is default error number whenever a user uses the RaiseError command.  Do you have any jobs or sql queries that is...

I use the following procedure that lists space used for each database by space free per file group and space used per table.  I also have it raise an error...

Thanks it worked great.  It gave me a corrupt table and after I ran a RAISERROR I was able to duplicate the info in the sql error log.

Try this query

select o.name as 'Ojbect', case o.type when 'u' then 'Table' when 'v' then 'View' when 'S' then 'System Table' else '' end  from master..syslockinfo l,  sysobjects o where...