You can't. Why do you need to do that?

The Curse and Blessings of Dynamic SQL

Dynamic Search Conditions in T-SQL

No there's not. Why do you want to do that?

The Curse and Blessings of Dynamic SQL

Dynamic Search Conditions in T-SQL

Can you post the proc you need to copy? I think there's a way to install it just once and use it from any db.

EXEC SP_MSFOREACHDB 'Use ? Create proc...'

Since you don't understand the words

SAMPLE

DATA

RESULTS

DDL

Help us help you

Generate insert statements

here's a totally working solution that you won't be able...

Select DISTINCT O.Name from dbo.SysObjects O inner join dbo.SysComments C on O.id = C.id and O.XType = 'P' WHERE C.Text like '%SearchString%'

Please post the whole code you are using :

- Tables

- Keys

- Views

- Triggers

- Sample data

- Expected results from the trigger

Sure thing, 15 nullable parameters = 32768 if/else combinaisons. Can you make sure that everything's gonna work fine with that much bloating?? How about when you need to...

Can you imagine the code if you have 15 nullable parameters?

Yup.

btw I DID NOT build this ?table??? if anyone's wondering .

Here's why I moved this code to vbs... and why I would have to put the columns' listing in vbs as well :

CREATE TABLE [Chaudières] (

[no] [int] IDENTITY (1,...

You're basically doig the same thing as I am, however I don't have a limit of 8000 characters to work with (providing moving the function's work in the dts loop)...

How did you create the temp table in the first place??

If you hav eno backups, the only chance ou have left is that the user still has the temp table...

See any cursor in my code?

How much do you wanna bet that my code finishes WAAAYYY before Roelof's solution??

Believe me, this is a pain in the @$$ on the long term, and the short term. In any term, don't do it