Thanks so much for your reply 🙂

I was just coming back to say I did it this way and it worked 🙂

update a

set a.[verificationID] = #temp_VerificationUpdate.VerificationID

from

#temp_VerificationUpdate

inner join

[adm-v-sql\sql2005].[Gas_Test].[dbo].[Verify] a

on

#temp_VerificationUpdate.EnrollmentID =...

Hello;

There are over 100,000 records in the Customer_Phone table which is the table that relates back to the Company Table and house the additional numbers and types

It is feasible that...

Jack, Ian and Simon,

Thanks so much for all of you putting in the time and effort to help me with essentially my problem 🙂

I will test all of your suggestions...

Hello,

First and foremost thanks for replying.

I have tried to put some data on this to sort of show what I am trying to do.

The two tables that are involved both...

Hello,

I have come across this kind of issue many times before but primarily in SQL 2000; as a consultant I visit different locations almost daily.

With SQL 2000 I found that...

Hello,

Check out this link and see if it helps

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1

Thanks

Ian

Hello,

Depending on the data kept you may want to divide it up amongst other tables if possible

Your queries may be iterating through chunks of data you dont really care about.

Have...

Hi,

As pointed out if your Environmental Variables for the OS are set to an alternate location you can avoid the temp file issue.

I just had this at a client -...

Hello,

I have set up my agent, setup operators, setup jobs and setup DB Mail.

I can send tests as often as I like with no issue - how ever no jobs...

Hello,

MS contacted me recently about this - if you have your MCDBA 2000 to get to 2005 all you need is 431 and 447

I just passed 431

Hi,

MCTS 70-431 - $40 at B&N - dont be cheap - you can use the book even after you pass.

I passed the 70-431 today - woo hoo.  I didnt ace...

Hello and thanks for the reply;

Are you telling me to create two stored procs suchs as:

1)

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

Create Proc  ARDoc_CGS @Date1 char(8), @Date2 char(8)

as

select d.* from...

I had this issue.

After much brain exercise the fix was simply this:

sp_fulltext_database

enable

Woo hoo

Ian

Hello,

I got the same error after deleting a load of tables.

Refreshing didn't work at any level

Exiting and entering fixed it and showed a table I couldn't see before which was...