I have been on both sides of the fence.

Developnig being one and guarding the DB against the developers being the other.:D

I think I still am, on both, at the...

I guess everybody is missing my point. I even submitted a short article on this subjects few days ago and it is under review - I guess I did not...

Yes Steve

string like column

It works and several times saved me a lot of coding. It is just another tool to be used. I understand that in many cases the performance...

ALZDBA

I think the

where '%,'+thecolumn+',%' like '%,' + @theCSVstring + ',%'

in your post should be the other way around

where '%,' + @theCSVstring + ',%' like '%,'+thecolumn+',%' 😛

I...

ALZDBA is probably right and the 1=1 is because of the dynamically generated SQL Select by the user interface.

My comment is that such a technique is a BAD, BAD...

I do not think the sysmessages table structure changed since at least version 7

Plus I am not linking to sysmessages but using FORMATMESSAGE function so I do not care much...

I do not know if everyone here is going to agree with me but I got two comments

1. Try to avoid 1:1 relationships - make it into one table =...

I have to admint I did not spent too much time reading all the posts carefully but I think I did not find anyone suggesting the usage of the sysmessages...

There is one problem with your script: it will not find all instances of the text in SPs, Views or functions that are larger then 4000 characters and the searchabe...

One time I was faced with an old database system and had to figure out which SPs are not being used.

There is no easy and nice way of getting...

Try this:

SELECT *

FROM User_Detail

WHERE ',' + @Temp + ',' LIKE '%,' + NAME + ',%'

OK. I am assuming the data type is VARCHAR because if it was numeric a simple SUM and a subquery would work.

What you may want to do is this:

create a...

What is the data type in TABLE3.FIELD2A and TABLE1.FIELD1 ?

The order was supposed to be maintained by the IDENTITY field. Unfortunatelly the DB was not fast enough so we had to log into a file.

Please remember that this encryption is quite simplistic and is not bullet proof. There are tools to crack this encryption.

I wish Microsoft built the encryption a much better way.