Sorry, thought the error was being generated when applying the snapshot. I haven't replicated stored procedures yet so, haven't really run into anything like this. Sounds like your initial thought...

On the publisher in the published database can you run select * from syspublications and post the output here.

On the subscriber in the subscription database run select * from...

Is the UserDefinedTableType at the subscriber? What if you were to put that on the subscriber first then try to run your snapshot again?

First - I apologize for the late reply on this. I am in the middle of a significant upgrade project and probably shouldn't have even started on this thread. :(...

You can download a great free E-Book by one of the forum posters on this site, Grant Fritchey. Check it out HERE.

A shameless plug for a great free resource. 🙂

What is the lastwaittype that is in sysprocesses for the spid in question when it is blocking itself?

A quick query to get that;

select object_name(ic.object_id) as object_name, i.name as index_name, COL_NAME(object_id('Sessions'), ic.column_id) as column_name

from sys.index_columns ic join sys.indexes i

on ic.index_id = i.index_id

where ic.object_id = object_id('Sessions')

I'm sure...

Did you use rebuild or reorg? Rebuild will take care of stats reorg will not.

Certainly not making the case that this is emphatically the issue but in most cases...

How are your indexes and statistics? Next time you see this come up take a moment and update the statistics on the most heavily used (inserts / updates / deletes)...

A lot of the code is sourced from another script posted by another user on the site. I reference the original script when I posted my version so that proper...

I would highly doubt that there is a way to change this. Can you explain what you are using this for? My guess is that you are going to have...

You can't necessarily see what is scheduled unless you review jobs / maintenance plans. You can however review history by looking at the backupset table in msdb. Check out Books...

You can use the tablediff utility provided with SQL Server. A introductory article can be found HERE. You can also look it up in BOL.

Another, and easier, option is...

Understood. If you find a way be sure to post it here. 😉

This query which I pulled from HERE (I'm pretty sure this is where I got it anyway) will get you most of what you are asking for I believe.

withxmlnamespaces...