Hello, i was using

exec sp_addlinkedserver @server ='RemoteServer'

exec sp_addlinkedsrvlogin @rmtsrvname = 'RemoteServer',@useself = 'false',@locallogin = 'MyLogin',@rmtuser = 'rmtuser',@rmtpassword = 'rmtpass'

and that failed because i didn´t have the same configuration...

Thank you, I didn't know it but I thought it, the partition with values 14, 15 and 16 is the bigger.

Thanks Scott, it was my doubt.

Thanks Ken, but a question:

How the DB is setting read_committed_snapshot, what's the matter if I execute in my session "set transaction isolation level read committed", is the session in read...

Thanks Grant, when you see the results from sys.dm_exec_requests, the column transaction_isolation_level always is 2 without the execution of the sentence set transaction isolation level read committed and with this...

I mentioned TRUNCATE TABLE because "ALTER TABLE REBUILD" had a behavior like truncate table, because sys.dm_db_index_physical_stats reported zero in record_count and page_count.

Table:

CREATE TABLE [CM].[LogCL](

[Tabla] [nvarchar](128) NOT NULL,

[Fecha] [datetime] NOT NULL,

[Operacion] [nvarchar](3) NOT NULL,

[UserMod] [nvarchar](48) NOT NULL,

[HostMod] [nvarchar](64) NOT NULL,

[UserMod_U] [smallint] NOT NULL,

[HostMod_U] [nvarchar](128) NOT NULL,

[Columnas] [nvarchar](max) NOT NULL

) ON [MYFILEGROUP]

without index

I...

Yes, both times.

I can´t try "DETAILED" because  the "ALTER TABLE REBUILD" did a thing like "truncate table".

How i said

before "ALTER TABLE REBUILD", sys.dm_db_index_physical_stats reported page_count with a high number

after "ALTER...

sys.dm_db_index_physical_stats(DB_ID(),OBJECT_ID('dbo.MyTable'),null,null,'sampled')

Before "Alter Table MyTable rebuild", reported a high pages number

After "alter table", reported zero page number

Hello John, "The rows column in the legacy view sysindexes isn't accurate", I know but in this case, is accurate because sys.dm_db_index_physical_stats reported zero rows.

After to execute "Alter Table MyTable...

Hello Grant, thank you very much for your answer, it was a doubt that I had.

Hello Sue-H, it was my mistake, your answer woke up me, I put the correct certificate (there was a confusion) and all Works fine.

Thank you

Hello Sue_H, of course, for that I don't understand.

Hello sgmunson, hello  Jeff Moden, thanks for yours answers.
I wrote the new function 4-5 days ago and i didn't use the CTE recursive and it is faster than  the ...

Hello Thomas, thanks, i didn't know that, 
I will rewrite the function, i don't want but...

I try this (in 2008 I do...):
I have a table with the...