Thanks for that, but it didnt work, I got an incorrect syntax error on the last line:

EXEC sp_executesql @V_UPDATE_SYS_DB

Thanks for that, I knew there was a simple way to do it, somebody gave me a cursur script to use and I knew there had to be a simpler...

EXEC sp_MSForEachTable 'DELETE FROM ?'

what stored procedure is this?

many thanks.

found where I was going wrong..thanks

Marvelous

Thanks  guys for all your help.

thanks...I did what you suggested, but now I get a different error msg:

Server: Msg 156, Level 15, State 1, Line 4

Incorrect syntax near the keyword 'CASE'.

the current select statement:

SELECT IA.ITM_ID AS...

thanks..i'll give it try.

thanks again.

Yes kind off. when you execute the query:

SELECT loi.LOB_ID, loi.EUS_ID, loi.LOI_START_DATE, loi.LOI_END_DATE, eu.CTY_CODE

FROM learning_object_instances loi

JOIN end_users eu ON eu.EUS_ID = loi.EUS_ID

WHERE eu.CTY_CODE = 'RU' and loi.LOI_START_DATE > '20060907'

the data returned...

Hi, thanks for ur reply. Your code works, but it is returning duplicates of all the rows, instead of just selecting those values that occur > once. Perhaps there is...

Its an order that come down from 'on high', theres a problem with certain records being too big, a change of datatype has been suggested.

our stored procedures are more...

I've been asked to change the datatype of the 'text' column in syscomments from nvarchar(4000) to ntext.

so far I havnt been successful in doing this. any suggestions would be greatly...