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')...

What do you want to do exactly?? and why?

In the comment column I'd enter : "Guess why"

When you hit save in EM... or when you run the create index script in QA.

Nice... never thaught of that one .

And here's a repost of the solution.

IF EXISTS( SELECT * FROM dbo.sysobjects WHERE id = object_id( N'dbo.ReplaceSpecialCharacter2000') and XType = 'FN')

DROP FUNCTION dbo.ReplaceSpecialCharacter2000

GO

IF EXISTS( SELECT * FROM dbo.sysobjects WHERE id...

"I still want to know what I did wrong in my hyper-link code above... "

You posted it using IE with a text editor, it creates the link automatically for you...

That would just be torture .

There's an actual meaning to that name... care to take a guess?

I'll be able to answer that one once Farrell finds the right post.

Farrell I meant the one where there was a search/replace table and where the udf search/replaced all the...

If it's only in the QA grid, you're screwed.

If you made the right choice for that query yes (assuming there's enough data for the index to be usefull). But you have to also consider all other queries...

Not gonna happen .

Now it became interesting. Are you sure it's not possible that the access db has LINKED TABLES?

Is it possible that some tables are linked to msde??