Check out the sysdepends table in 2000.

As I said it is not reliable (you could miss quite a few objects).  I have no idea if it is more reiable on...

There are no reliable (100%) way of getting that information in sql server.

The best you can do is scan the syscomments table and try to find them by yourself.  I...

What error are you getting?

I would assume 25% and 50% more rows...  but the performance could still be very tolerable even with 200 M rows.  Depends on the server, the queries and the load you...

If the udf returns rows, then you cannot use it like this in 2000.  In 2005 you could use the cross apply operator but there's no workaround in 2000 other...

... but if I had to rebuild me dunction it would use John Mitchell's approach... would be much more efficiant that way.

Isn't it what my function do?

Ok, this ain't set based... but I don't have time to rewrite it at the moment.  It'll at least give you another option if needed.

CREATE FUNCTION dbo.fnStripHtmlTags (@Text AS VARCHAR(8000))

RETURNS...

What happens if there are more than one line of text to extract in a single row?!?!

Are you sure you are not getting the error on that unique constraint (GBIInvoiceDetailID) it would make more sens as you are not checking for uniqueness on that column??

I have never...

Can you post the ddl script for tab1?

DELETE A

FROM _FinalTrans A

INNER JOIN _FinalFlat B

ON A.AcctNo = B.AcctNo

WHERE B.Tagged <> 0

AND B.SupervisorMark = 0

or add the return in the code that generates the statement...

vbcrlf in vb

char(13) + char(10) in sql server.

That's what happens when you read too fast... Dave had already mentionned the systypes table... obviously.

Good thing that the week is almost over

If you want to write your own queries you will also need to check out the SysTypes table.

Good luck .