Thanks for that! As I'm supposed to have a day job, I couldn't spend too much time wading through your stored proc - no offence

Hi David

Can you provide sample data for cl.hours, cs.hoursperday, cs.startdate etc and also what you want to be returned in each case? As your expression is getting quite complex,...

Haven't seen this myself, but ...

Check out this link and see whether it's of any use:

http://dbforums.com/t485458.html

By default, SQL Server tables/databases are not full-text indexed. As the error message indicates, you cannot use CONTAINS or FREETEXT within queries unless the underlying data is full-text indexed.

As...

That's because it hasn't changed. It changed only for the duration of execution of the sp_executesql command. I could not find a way of making the db context...

OK, what I think happens is that the database context changes only for the duration of the sp_executesql command and then reverts immediately afterwards.

So ... if you expand your definition...

I'm assuming that you're using Enterprise Manager...

When you perform the restore, the destination file paths default to what they were on the previous server and you need to manually amend...

The statement works, but the change in database context lasts only while the SQL statement executes. Here's a quote from BOL:

"If the executed string has a USE statement that changes...

Don't know why you didn't have success with the methods you mention, but try this:

declare @sql varchar(400)

set @sql='select ''?''as dbname;select * from information_schema.routines

where charindex(''shipping_total'',specific_name) 0'

exec sp_msforeachdb @sql

(Assuming you want...

Your restore error message is not appearing - I think it is looking for a linked jpg file - please update your post to include it.

Backup/Restore should have no problem moving databases between servers. How far are you getting when you try this method?

As a result of using the 'distinct' keyword, duplicate records in the output recordset are not displayed. Remove 'distinct' from my query and the multiple records will be displayed.

My previous query is equivalent to the following:

select distinct b.firstname, b.lastname

from tablea a, tableb b

where contains(a.field1, ' "run" and "hide" ') and

(a.field3 = b.field1)

so that should help you understand....

Sounds nasty! First point to make is that if you do not have a shared unique identifier (or combination of identifiers) that will allow direct matching between the imported...

Something like this?

select distinct b.firstname, b.lastname

from tablea a

inner join tableb b on a.field3 = b.field1

where contains(a.field1, ' "run" and "hide" ')

Regards

Phil