the example i gave you will work with absolutely any SQL command; try it before you dismiss it.

Declare @cmds Nvarchar(MAX)

Declare @obfoo varbinary(MAX)

Set @cmds = '

ALTER procedure [dbo].[sp_find]

@findcolumn varchar(50)

AS

BEGIN

...

are you sending the actual scripts fo rhte client to run, or an executable which will then execute the script after the client provides connection information to the server?

you could...

yep, so your WHERE statement would reference the THREE columns that make up your primary key:

...WHERE TableName.IdContrato = INSERTED.IdContrato

AND TableName.EiCanalId = INSERTED.EiCanalId

...

i had to infer a lot of...

if the query has a WHERE statement, you could make the arguments non-SARG-able, and force it to use a table scan, but it would still use an index(probably the clustered...

I always felt those two functions should be renamed, as they are really misleading; something like ISREFERENCED would be a much better name

I always felt those two functions should be renamed, as they are really misleading; something like ISREFERENCED would be a much better name .

i think that's the only way to do...

can...

the core of the trigger is going to be something like this, but you didn't provide all the info needed. what values would col1 and col2 actually be assigned?

UPDATE...

there's an article on something similar labeled "exotic joins" i think; if you search and read that, it can help you understand some of the less logical reasons to join...

looked like the "enhanced" version has an error in it;

this is my slightly edited version of the same script; it runs without errors on both a 2005 and 2008 database:

db_documentation_enhanced.txt

take a look at this wonderful script contribution:

Comprehensive HTML Database Documentation(Revised)[/url]

it produces well formatted, informative html document, which you could then copy and paste into excel, or open with excel.

I've...

i went to the trouble of creating a stored proc that does this;

as previous posters already identified, the actual statement is never saved...all you can do is script out the...

who created the users is not saved anywhere...with a minor exception.

SQL does not keep track of who created or modified anything...except for a short period in the default trace.

the...