Hi Gianluca,

Apologies for that...wasn't sure if I'd posted in the right forum

Hi Gianluca,

Apologies for that...wasn't sure if I'd posted in the right forum

Hi Brigadur

Thank you for the reply

Thanks all for the replies.

Would I be right in saying when I created the table to store the different combinations...I should have created that field as a varbinary

Apologies...the error is :Procedure CleanUpSP , Line 0 Error converting data type nvarchar to int and not Implicit conversion from data type nvarchar to int is not allowed.

Thanks to all for the feedback

Hi Mark and Lowell,

Thank you very much for your assistance. It is greatly appreciated.

Thanks

Denesh

Hi,

None of the dbs are in compatibility 80.

It's the computer account allocated to that server in Active Directory. The server that is running the Lotus Notes application.

The developer has just gotten back to me to confirm it's...

Have a look at the link below:

http://searchsqlserver.techtarget.com/tip/Avoid-cursors-in-SQL-Server-with-these-methods-to-loop-over-records

Thanks to all for your replies. It is greatly appreciated

Maybe have a look at the following link:

http://social.msdn.microsoft.com/forums/en-US/sqldisasterrecovery/thread/189be01f-23de-48b0-96cc-8f1292c13c54/

Hi,

Please try the following:

1. Create a new blank database on the server you want to attach your MDF

2. Detach database from SSMS

3. Delete database files for database that you just...

Hi,

Create a new table in the database with columns First, Last.

Import the data from the Excel file into the new table.

Run a query join the existing table and new table.

Delete...

Hi,

When you setup your Secondary server...did you restore a Full Backup from your Primary server with NORECOVERY or with RECOVERY