Thanks a lot GilaMonster and GSquare to provide me good descreption. I read each post and at last i understood as below:

Non-Repeatable reads: Rows that disappear are non-repeatable reads.

That...

Thanks a lot ! Given link is very helpful to understand those three terms with an example.

http://msdn.microsoft.com/en-us/library/aa213029(v=SQL.80).aspx

but I am not cleared about Phantom Reads. It looks same like...

Hi Alan,

as per your logs error:

"Error: 18456, Severity: 14, State: 58. Login failed for user ''. Reason: an attempt to login using SQL autentication failed. Server is configured for windows...

Hi

I think you need to add specific rights to your windows account through which you are connecting Dabasae engine.

Go to user's properties and select MemberOf tab and add the...

According to me, each database restric access is set to "Multi_User" by default. So no need to perform anything. I have one sql server instance isntalled on another machine and...

Hi Hector,

Is import/Export good solution?

I mean we will first export db to excel file and than copy that excel file to remote server where we can import that db.

Thanks,

Yes, I am asking question. I have not observe it before but i attended an interview and inverviewer asked me this question " What is update state?"

So i want to...

It is working... !! I just try to failover it and could see the chagnes in status of mirror database from "Restoring..." to "Principal, Synchronized" and vice-versa.

Thanks all of you...

It is working... !! I just try to failover it and could see the chagnes in status of mirror database from "Restoring..." to "Principal, Synchronized" and vice-versa.

Thanks all of you...

Thanks for the response Perry !

Yes, I tried to refresh database but status "Restoring..." not chagned. I ran the query you given on both principal and mirror database and can...

I did that... I restored backup with NORECOVERY option and than restore transaction log backup with NoRecovery option.

I setup mirroring and can see "Principal, Synchronized" status of Primary database....

Yes Pettis,

I selected the option " Restore With Norecovery" during restore of db. But still the same status.

Is TCP\IP and named pipe services enabled ?

To enable them you need to go to Configuration tool--> SQL Server configuration manager-->SQL Server Network Configuration and on the right pane click...

Thanks Vinu for suggestion, i tried it but it did not work when I save the changes.. its give me an error..

"Saving changes is not permitted. The changes you have...

Thanks a lot Pettis and Paul !

Now i m cleared about primary key concept. I also tried to insert a column using Alter command with not null, but it did...