Hi Remi,

Thanks for the advice. I am actual extracting the data from a legacy DB and uploadinging it into a new one where the proper constraints are set up.

Regards

CCB

Perfect.

Thanks for the quick reply

CCb.

Ignore the previous post. Have sussed it.

CCB

Hi, I could only get it to work with Noels suggestion.

Thanks to all who responded.

CCB

Perfect Frank, its exactly what I need.

Thanks again.

CCB

Ok,

Where in the SP does this ned to go ?

I am using COLLATE Latin1_General_CI_AS.

Thanks.

CCB

Thanks guys.

went with Ron K's seggestion in the end.

Regards.

CCB

Hi Steve.

thanks for the advice, I have tried this but the column on the where clause is a string (strID). When I try to run it in Query Analyser, I...

Perfect. Do users need any special permissions to run this ?

Thanks again.

CCB

Hi,

 I hoped I could run some t-sql to return the following: -

TableName    Rows   Size

tblAddress    55       1Mb

tblNames      1234   5.98Mb

tblContacts  402     0.87Mb

I have started with: -

Select A.name From sysobjects A Where Upper(A.name) Like 'TBL%' 

Any Ideas.

Thanks

CCB 

OK, I have reduced the number of operators to 2... = and like and used the following code. Any comments on the effectiveness of it - it does what I...

Thanks guys.

I will give it a go.

Perfect. Thanks.

CCB

Thanks, thats perfect. I also took your advice at the botom of the message.

Thanks again.

CCB

Perfect.

Thank you Noel.

CCB