Are you replicating the actions, or the stored proc call? You're saying the delete works fine on the publisher but fails on the subscriber? How many rows in the delete...

Kowabunga that's an answer! Thanks for going the extra mile James!

Andy

For the views I guess you could loop through and do a select from each, log the ones that fail. Procs a little harder, you'd have to run each inside...

I avoid underscores and prefer mixed case for object names, easier to read in my opinion. The thing about underscores is if you dont use them consistently, it makes it...

Good point about finding instances of it to change the name. For EVERY build we sent out a new dll and a new exe, even if there were no changes...

Maybe sp_monitor.

Andy

Seems like it would be easier to just create the table on the publisher, let the snapshot take care of the rest? Sp_addarticle should work - I recommend scripting out...

Not bad! We don't have one much of one here. While senior people may rebel a bit, junior developers LIKE having a standard to follow. Not only that, they tend...

Add an identity column. Truncating it will reset the sequence back to 1 each time, as you append records they will get the next id, trailer record should have the...

Pretty nice. Great job on linking to other resources. Did you consider using the built in support for extended object properties?

Andy

Dont have time at the momemt to answer in detail, but here are a couple pieces. With a client side cursor its always static regardless of what you set (and...

Probably a little variance due to how space gets allocated on disk maybe?

Andy

Right in BOL, look for the sp_recompile TSQL page. Not sure why you would want to do this on any regular basis.

Andy

Good solve - depends is a great tool. Other handy ones I use are RegMon and FileMon, lets me see what is going on!

Andy

Not running Win2K AS? Are you using the /3GB switch for SQL? /PAE to make the memory above 4g available to your other application?

Andy