Sorry, I'm wrong.

In fact, only when the row filter has been set as

" WHERE [DayID]>= convert (nvarchar(10),DATEADD(month,-2,GETDATE()),112);"

there's no error alert.

Dear David,

In recent days,I also find if the filters are limited only at one side as:

" WHERE [DayID]>= convert (nvarchar(10),DATEADD(month,-2,GETDATE()),112);"

or...

Thanks for your advice.

But I can't understand why only when putting [b]filters [/b]in the transactional replication, errors occurred.when I remove the filters, replicate the whole tables,it runs all right.

Could...

And after I manually insert that data into the subscription table, start synchronizing, another error follows:

if @@trancount > 0 rollback tran

(Transaction sequence number: 0x00053CD400000399003300000000, Command ID: 3)

I also find the...

I start profiler against the subscription db,and got the statement:

exec [sp_MSdel_dboUser_Duty_Schedule] N'20090522',N'W10832850';

and execute it on the subscription db,the error says:

(0 row(s) affected)

Msg 20598, Level 16, State 1, Procedure sp_MSreplraiserror, Line...

I answered this question on april 2nd, and dreaming SQL Server real port to linux or unix one day, so... 😛

And It's a pity that I lost that 12 points!...

Haven't.

In fact, the database is only my test db. In a testing , I find this question by chance.

Yea, i used my filegroup name instead of 'FileGroup0' and tried the query. But the results of mine are different from yours, i got nothing.

Look forward to your investigation~...

O~ bug? Maybe~

There have been no files in the filegroup, in other words, the filegroup that i want to delete is empty.

BUt unfortunately, I can't remove it and still...

Thanks for your suggestion~

I followed Mike's advice, search XP_SQLAGENT_ENUM_JOBS and find it indeed provide useful information. After research, I compile this script to monitor jobs running status, when they over

their...

Thank you Jeff. I agree with your views.

But in my opinion, profiler may consume many system resources, so we hardly turn it on unless really necessary.

Yeah, I understand that. But the question is that the job runs well all the time, it amazing or marvelous only sometimes. So I want to make an Auto_monitor for...

Thanks for your advices!

But, if the job executes very long time even more than two days, it will block the other jobs. Finally, result in almost all the jobs fail....

Yes, at the very beginning, I have removed all the datafiles on the filegroup.

So I said there should be no objects in the filegroup except PRIMARY.

But still I can...

Thank you for your reply in time.

I have executed the script, and the result tells all indexes only on the PRIMARY filegroup. This may mean the other filegroups are empty....