Just to clarify, when you filter the publication vertically you can have the destination tables as Table1 and Table2 and then create a view on the 2 tables at the...

Use SET XACT_ABORT ON in your calling sproc.

When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back. When OFF,...

I have another suggestion.

Let the job which checks for the date control the execution of your main job.

If not exists ( select date from [table1]

exec sp_start_job .....

Else

Print...

yes It does look like a bug. I am running SQL2k with SP2. I found it really strange that it does not allow these datatypes. I am going to do...

Hi all ,

I found the "disallowed construct". I had a few columns defined as decimal ( 12, 4) and smalldatetime. When I changed the decimal to numeric and smalldatetime to...

Here is the definition of my table. One has check constraint for district = '01' and another for district = '02'

The view definition is as follows:

create view ttodetail

AS

SELECT * FROM...

Thanks for the reply.

yes I did cover all the cases. I dropped and recreated 2 tables and used check constraint on the district column.

Then I populated the tables...