After adding a column by means of "(b) altering the table in-place" I am getting this message from Merge Agent:

The schema script 'exec sp_repladdcolumn '[dbo].[child1]','AddColumnToReplicatedTable',[varchar(200)], '%', 1' could not be...

Does DAL refuse Data-Binding approach? In other words can it be used when one wants a GUI control (as opposed to developer's SQL code) to take care about SELECT /...

The following script is an excerpt from 2000+ lines Stored Procedure

ALTER PROCEDURE dbo.scriptCreateTriggers

as

SET QUOTED_IDENTIFIER ON

--

SET ANSI_NULLS ON

--

exec ('create trigger [Anamoly Descriptions_boolean] on...

A few search & replace (RegEx is on) in the stubborn to-be-SP text:

Search '

Replace ''

Search: create trigger

Replace: exec...

Choices are limited if not none.

I certainly do not want to do something like this:

create proc INIT_DB as

...

create table...

create table...

...

exec

('        create trigger ...

go

create trigger ...

go

...

/* under 4000 characters chunk */

'

+...

What I am trying to do is this.

I want to have a script that re-creates the entire database schema (80 tables) for MSDE distribution. Where do I store this script...

In an article like this the definition of dbo is a good thing to explain. BOL is vague about it: "The dbo is a user...". Does it mean a login or...