Thanks to all that pointed me in the right direction. For others that need this I found in BOL this example that uses the sys.extended_properties view, simpler than using...

Serqiy,

This looks like it gives me default values for table columns.  I need to get the default value for a stored procedure parameter like the following:

CREATE PROCEDURE dbo.PROC_AllEvents

@InputSessionID int = 100,

....

I...

Wow !!  I just read Erland's article you referred to Remi and I learned so much I feel like I want to send someone some cash.

No kidding, it was very...

Don,

Here's one method.  Build the SQL statement and use exec to run it.

CREATE PROCEDURE dbo.GetData

@TableName varchar(30)

AS

DECLARE @SQLcmd as varchar(500)

set @SQLcmd = 'Select Top 1 *  From ' + @TableName

execute (@SQLcmd)

GO

Fred

Wayne,

I not quite following your example for what I would like to do.  I would like to have one stored procedures build script.  However, depending on the target system I...

Thanks to all for their help.  After reading the articles and everyone's suggestions it seems like there's just one rule to remember.

1)  Always qualify every object with dbo whether creating...

Remi,

That really tightens it up doesn't it.  Thanks again, and thanks to all who have helped with their input.

Fred

It's not clear to me in BOL what the syntax is for a BEFORE trigger.  I shouldn't need to do the rollback if I do a before trigger. 

Remi,

That works perfect.

Thank you.

This database is on a test system, one of many which send their data to a central server.  When a test is started it gets a unique sessionID from the...

The central system is dedicated to support the test systems so that isn't an issue (ie. it's not used for any production related tasks).

We've decided to go with a stored...

Thanks to all who have replied thus far.  I am abandoning the idea of a distributed query inside a trigger.  I figured it was probably not the best method but...

I confirmed that the MS DTC service is running on both machines. 

I downloaded the troubleshooting doc you mentioned. I ran dtcping in both directions and all messages indicated success. ...

Jeff,

Thanks for the help.  A colleague of mine wasn't too excited about maintaining the table, having to clean up rows that have been inserted.  A 36 char ID is too...