Got it working with Insert now, i just had to specify dbo.tablename..

Thanks alot guys, i love this site. 🙂

i still get that the column is read only after execution of :

set IDENTITY_Insert tablename ON on the table.

opc.three (1/21/2013)

---

It is, so you probably do not want to key off it unless that is only one of two applications that ever connect to the instance.

You may want...

Thanks for the reply.

Seems like the next application im planning to run there (in production) use the following:

59.Net SqlClient Data Provider

I dont know if this is a "standard" app...

The difference is the applications, and as i said, i want to give the legacy/test AG less resources since those are not business criticall.

As long as your application do not use any specific SQL 2008 specific queries etc it should be no problem.

Nope.. SQL2012 have support for older modes.

I resolved this problem, it was due to network issues with the inboard NICs, i switched out with Intel card and it worked.

the issue might be related to this event:

System.ApplicationException: Failed to receive the event log entry. ---> System.ComponentModel.Win32Exception: The remote procedure call failed

--- End of inner exception stack...

This is Server 2012 cluster.. and there is no such tool for WS2012..

I have also tried to reinstall the one server, but the exact same result came.

David Webb-200187 (10/26/2012)

---

Were these files copied from a SQL Server that was running when the files were copied? If so, they may not be in a state that will...

Tried this with no success, the DB popped up in suspect mode, and i could not reset it with emergency mode, guess...

i will try the new db restart sequense

i actually tested that tool also, it worked.. only tool i got to work

Im using trusted connection with sa user, i also verified that that SP is not in the master db.