Around almost anyone with more than 250 post actually .

Please post the whole code so we know what we're working with.

Select id, dbo.fnName(id) from dbo.YourTable????????

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items = @Items + C.Name + ', '

FROMdbo.SysColumns C

WHEREC.id = @TableID

AND OBJECTPROPERTY(@TableID, 'IsTable')...

You're seriously suggesting dynamic SQL for this?

Dude read the code, it EXACTLY what it does.

Use netscape so the identation is lost... maybe someday I'll translate to html code...

Works well and it is easy to copy and paste .

Besides you'd be the first to figure it out all by himself (without having...

And I thaught we only had to backup after .

Still can't be reminded when you don't know it in the first place...

Check the script section... there's surely something there.

Dynamic Search Conditions in T-SQL

Arrays and Lists in SQL Server

Neat function to do this :

IF EXISTS (Select * from dbo.SysObjects where...

The parameters are not all varchars and of variable datatypes???

You'll have to quote the varchars in the raw data directly and remove the quotes from the select statement (4 per...

EXEC master.dbo.xp_execresultset 'SELECT Statement + '' '''''' + ServerName + '''''', '''''' + ReplaceValue + '''''''' AS ExecStatement FROM dbo.MyTable', 'DB you want the code executed from'

Check the list of foreign keys on the main table?!