When you restored the 2000 database into SQL 2008, it did not recognize the user defined type. You probably might get a 6261 error when selecting from the table that...

You might see a work around here.

Just add one more to what Brandie said, You are using Select *. The optimizer might think that having an Index with Include is faster for case 5.

For number 1,...

Seems like the Link server is not getting created. Try running the below

sp_link_publication @publisher = 'Publisher Instane name'

, @publisher_db = 'name of DB Published'

, @publication = 'name of Publication'

, @security_mode...

Check if you have User defined data types in this DB. That could be why you are ggeting this error

From what I know, It is not possible. Maintenance plan runs as local SQL agent Job.

Isnt this the horse that got injured?

I am hoping that I get to meet Santa once again.. 🙂 And this time I am going to say HI to the Tall Dude with a Cowboy hat.. :-D...

Plus 100 on this. I voted for you. I want you to win, then we can hang out again...

Congratulation on getting the MS community contributor award.

Steve Jones - SSC Editor (6/28/2011)

I don't have mugs or...

You could always try to create the table manually on the subscriber, take a BCP and import the data and then start the replication without snapshot.

I forgot the fact that it was 2900 odd, I thought my post count was 1900 odd. 😛

Congratulation. Well done. I will never hit 3K for sure. 🙂

I have a twitter account. I have tweetdeck on all the time. But I rarely tweet. I get some nuggets out of there.

It is the same here in SSC. I...