Well, if you do get stuck for something like that Lowell.. PM me and I'll write you one to your spec. FOC (as its for charity).

I like little...

or free if you write your own 😉

Personally, I write a simple vb programs to loop through the email addresses from DB, A simple threaded sub will allow me to see real time progress.. Then you can...

.

hello,

On SQL 2k8 express,

I followed your steps of

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ad Hoc Distributed Queries', 1;

GO

RECONFIGURE;

GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1

GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

GO

then used this...

OK, I think I've fixed it..

You have to speech mark the included text like shown.

select * from dbo.Documents where contains(DocBody, '"Some Text"');

You can also use NEAR to say the text...

Hello All,

I think I'm about to give up with this one, I can't get it to work properly

I'll cover every step i've performed..

I've Installed SQL 2k8r2 sp2 adv with...

Thank you arthurolcot very very much! That did exactly what I was looking for.

Many thanks

David

I have had this once in SQL 2k.

I had to add a secondary Data File / transaction log File

Then setting the secondary Data file to primary.

hb

please note: all comments listed below are my personal opinion, all rights reserved for changing at anytime. and not to be taken literally. as It refers to any manufacturers of...

what ever happened to informix databases? I did a little work with those when they was the backend for avaya phone systems.. supprised that hasnt been mentioned yet.

It would appear that I have made a bit of a stir with this question. Sorry all,

I think I’ll just stick at my MS SQL. Should be ready to sit...

Many thanks for the replies,

I'll implement these tomorrow

😀

Dave

yeah,

I have a table of called tbl_Router_details with stuff like IP, subnet, etc,

another table with router configs,

another table with router locations etc

these are all inner joined.

When I...

Appologies guys,

I only needed a SQL line to run from an ASP page, I didn't want to do this through an SP as there is more going on with...