i again sort this out:

execute ('select * from ' + @tempFinal + ',' + @tempFinalOD )

i sort this out. thanks though.

besides now i am stuck in another dilemma. here it is :

i want to do this :

execute ('select * from ' + @tempFinal )

union

execute ('select...

HI Jordan, I had previously run your script too. Yet again I did it in my Principal Server. Is there any step left to do 'coz I haven't received any...

Hi Jordon, someone early in this thread has thanked you for your new script. But I couldn't find that script, would you please guide me to your script!

Comprehensively, here's the description.

Pre-Failover State:

SQLPrincipal - Principal Server

SQLMirror - Mirror Server

Post-Failover State:

SQLPrincipal - Mirror Server

SQLMirror - Principal Server

Now, let me tell you that, our main MSSQLSERVER(from which Application Server runs)...

Yeah, we've SQL 2008 instance and our application is configured with the computer name.Besides, the computer name is same as the instance name of MSSQL server. So i've a confusion...

Hi there, the same is my problem. Our application also uses the Computer Name. I don't have an idea about adding the computer name of Mirrored Server in order to...