Thanks!  Your answers are very helpful.

If I understand correctly a snapshot schedule is for the case when new subscribers are coming online frequently.  They can get started with a fresh...

Thanks so much for your response!  Very helpful.  I do have 2005 Management studio and will use it.

Thanks all for you replys.

I found this script by Omri Bahati this morning and have been playing with it.  It seems to be what I need.  It is a very...

I still have not figured this out.

Does anyone have suggestions on debugging a DDL trigger?  Is it possible to step into it from Visual Studio as with a stored procedure?

Thanks

JM

noeld,

I am aware of the sql injection risk with dynamic sql.

I did use UNION ALL, I should have mentioned that.

The UNION ALL led to another question I posted this morning...

Aaron,

Thanks for your helpful reply!

I wrapped the creation of the view in a stored proc that uses a cursor to loop over INFORMATION_SCHEMA.TABLES for schemas other than dbo that contian...

Wow!  Thanks for all the advice and help.  I hope I can return it someday!

Looks like I have some work to do just absorb what everyone has given me.

JM

Sara,

Thanks for your thoughtful response.  I agree with your reasoning and almost always use generated keys, and will in this case. 

jmatt 

Andrew,

To quote from my original post, "The same account can play more than one role for a fund.  That is why I have a FundAccounts_ID Primary Key instead of a...

Thanks for your relpy Andrew,

I used a generated key as opposed to the more "natural" compound Account_ID + Fund_ID key because an account can play more than one role for...

A thing of beauty!

Thank you Noel.

jmatt

Thank you Dinakar and Seth!

jmatt

Thanks again for the help.  I have made the changes!

jmatt

It got much clearer!

I don't use cursors much (I know what a drag they are).  I had this ADO classic recordset image in my mind.

So ordering the #temp1 source table is really...

Wayne,

Thanks for your help,  I really appreciate your thoughtful reply.

In an effort to understand; two questions ...

Isn't the point of a cursor to move through a table one row at...