Ooops, cross post?

Didn't relazie that you've already answered, Steve.

Sorry, hit the button too early.

If you really want this, take a look at sp_changeobjectowner in BOL

Why?

You might want to read this and decide then http://www.sqlservercentral.com/columnists/awarren/worstpracticesobjectsnotownedbydbo.asp

The characteristics change each month?

I'm not sure if I understand you

However, this might be interesting for you.

http://www.sommarskog.se/dynamic_sql.html

especially the chapter

http://www.sommarskog.se/dynamic_sql.html#Sales_yymm

I think...

It depends on several things, I would say.

How large will that Company ADP be in size? If the source code will go up to ~30 MB, you will get into...

Can you post the code?

While the above will certainly work, one might think the whole approach is not optimal.

Do you have any chance to only have one transaction and one customer table?

With...

As the data pages are actually used when you have a clustered index on that table, I guess it won't work, when there were data from different tables on a...

I agree with Thomas.

It makes more sense to me, to include them in every database and develop your own rollout routines. Storing in SQL Server's master db is not a...

Would it help to assign more than one moderator to a forum (if possible at all)?

This here will be interesting to you, I guess.

http://www.sommarskog.se/dynamic_sql.html#Common_cases

Parameterizing to get generic code is a good approach for everything that is handled at the client, it is the wrong...

If I understand correct, you have a sp that returns a string that is to be executed dynamically?

That string is longer than 8000 characters?

There are only but a few...

Well, I store emails in SQL Server, but I don't use xp_sendmail. I have written a small app in VB, added references to ADO and CDO, and that's it.

Basically the...

I did

The only one I know of is something like

USE PUBS

GO

DBCC TRACEON(3604)

GO

DBCC PAGE(5,1,88,1)

GO