shared memory

tcp/ip

Not sure what you mean ?

I dont understand ?

I asked a full question and was in the middle of an ongoing dialogue.

Where would you lioke me to add information ?

yes and when i do an ODBC test connection it works ?

I restored my DB to the new instance and now get:

Microsoft SQL Server Login

Connection failed:

SQL State: '01000'

SQL Server Error: 53

[Microsoft][ODBC SQL Server Driver][DBNETLIB]

Connection...

Thanks for the feedback.

Once i copy my DB's over, can i not just delete the original instance ?

How do you access the second instance ?

I have the original default instance, which was the Evaluation Edition, and a new instance which is named 'Developer Edition'.

In SQL Mgmt Studio...

Thanks:)

Thanks for the information!

Sometimes it would delete the log file, other times it would not.

So i did a restore and and am back to square one.

I will follow your advice...

Thanks guys!

I right clicked on databases and attach was one of the options.

That worked great! Many Thanks.

I used a CSV input file.

Is it possible to read multiple CSV files by referencing a folder ?

I have a bunch of text files i need...

I am trying to migrate my data from Goldmine to CRM 4.0

The Client (account) records have imported fine, based on running a sql query with unique account number.

The history (note)...

I tried again and it did. duh!

What i need to do is manage the records in unique order based on the temp field which equals 'field1+field2+field3'

Would i need to do...

Thanks, that worked!

Where do you add the distinct function, to make it unique?

It normally comes after the select, but that wont work now.