Maybe can use this after your query:

If @@rowcount = 0

Begin

SET @tableHTMLA = 'No failed jobs reported'

End

I think this will be work:

EXECUTE ('create view dbo.v_test as select 1 as d') AT [linked_server_name]

Hi!

- Check locks: run query with nolock hint, and check running time

- Check hardware performance (CPU, Disk, Memory) under query running

Hi!

J Livingston SQL what thinks about this query?

SELECT DISTINCT ClientId

FROM dbo.TPC

WHERE ClientId NOT IN (

SELECT DISTINCT ClientId

FROM dbo.TPC

WHERE ActivityId = 72 AND CreateDate > GETDATE()-60

union

SELECT DISTINCT ClientId

FROM...

Exapmle: we're monitoring MS replication with profiler, but it don't use identity reseed. It use always simple insert.

I'm managing more Microsoft replication.

But Microsoft replication is slow and inflexible. Our replication program is fast and flexible (example: maximum 0,5 sec replication latency, more...

Ok, thanks!

But the Microsoft replication is knows insert without identity reseed.

It is a long story.

I have two SQL servers and databases (same databases are on two servers).

These databases are "multi master" (similar as peer-to-peer or merge) replication with a...

Thanks for replay!

After inserting 1000 in identity column, what kind of value you would expect for the subsequent insert?

id = 2

It cannot start from 1, otherwise it may end up...

Oh, yes. Thanks Jeff!

Please check this code:

select

a.*,

STUFF((SELECT ', '+name FROM bb WHERE colorid = a.colorid FOR XML PATH('')) , 1 , 1 ,...

And how to check the table re-creation?

Is there enough memory in your server?

Hi!

1.) Management Studio => Tools => Options => Designers => "Click the Prevent saving changes..." (Checkbox is on)

2.) Search your table on the management studio => Right click => Design

3.)...

Please check this code:

if exists (select OrderDate from Order) = CONVERT(VARCHAR(20), Getdate(), 101)

Begin

...some code...

End