Can you explain what changes become undone?

Can you post the code of the stored procedure?

Run

SELECT a.id

FROM TA a

INNER JOIN TB b

ON a.id = b.id

WHERE b.id IS NULL

If it returns any id, then those ones are missing in TB.

You can query the rows column on the sysindexes table.

Should be updated frecuently but i'm not use of how accurate it can be.

You can try comparing those values against select count(*).

You could use dbcc showcontig to know index fragmentation.

Also check the script page of this site, that you will find already made script that you can use or modify.

The windows account wich runs the sql server agent service is admin?

Wich is the owner of the job? You should change it to sa, so the job will be run...

Did you manage to apply the snapshot?. All the sp should be created in the snapshot.

Maybe you should reinitialice the subscription to start all over again.

To drop replication (entirely) first...

You can script the entire database with all it objects and then execute the script in the dev server. But the script will aso save the location and size of...

BCP Out is the fastest way of exporting to a text file according to MS. If you can lock the table with 'table lock on bulk load' parameter of sp...

I don't think the above query should work ok.

Try checking the query first.

Try adding an alias from the Client Netword utility specifying the ip server adress in the server name.

And then re create the linked server with the alias name.

You can create a backup device to a netword drive, like this:

exec addumpdevice 'DISK', 'NetBkp', '\\ServerName\d$\Directory\File.bkp'

And then execute directly the backup to that device:

Backup Database DBNAme TO NetBkp

Or can just...

I think you can't assign direct create index to users. The owner of the table or the db owner, can create indexes.

So like I said beore, you could try creating...

Triggers for INSERT, UPDATE Or/AND Delete wich also can be  INSTEAD OF TRIGGERS or AFTER TRIGGERS (default)

Choose VARCHAR(8000) instead of NVARCHAR (8000).