I ran my code over millions records, no problem ..too fast

Play fair, this is your code which you posted originally ...

The problem is, missing records on sequence don't appear, It...

not worked, you know that!!

This is my code ... it works!!

create table #temp (id int)

declare @cont int

set @cont=1

while @cont <= 1000

begin

insert into #temp values (@cont)

set @cont=@cont+1

end

select t1.id from #temp t1

...

not me my friend .. you are funny!!

Your code doesn't work properly..

Tell me, what happens if I have two missing row_id in sequence?

765 and 766..

your code will show me just...

Hehehe ..

The Paul's code is the best!!

!!!

Many thanks man, I didn't know the view sys.key_constraints, it helped me a lot.

What do you want done if there are multiple gaps? If, for example, A had 1, 5, and 100, instead of 1, 2, and 100. That would mean a gap...

Many things,

But unfortunatelly I'm not getting there,

I just don't know how to do, if you any idea...

Perfect...thanks!!

I think the best way to do this is,

create View UnionView

as

Select distinct z from table1

union all

Select distinct z from table2

union all

select distinct z from table3

go

Select z,count(*)

from UnionView

group by z

having...

There's a problem, If I have more tha one value in each table...modifying the last example, like that!!

Table1 - Z=1, Z=2

Table2 - Z=1,Z=3,Z=3

Table3 - Z=1,Z=2

My question is, in your view,...

Just a correction,

The correct command is:

sp_cycle_errorlog

Why don't you simply create a synonym.

create synonym table_name for user.table_name

select * from table_name

The view, sys.sysprocesses will help you in all what you need.

example: select * from sys.sysprocesses where blocked =1

many thanks,

This is was what I needed!!

Have you tried?

Connect on master, switch the database using the "USE" command, afterwards type "DBCC CHECKDB".