they are SQL Logins or windows logins?

If windows logins, you can add them to a group and give granular permission into the database

That was good 🙂

I have never heard of 90 days eval version of SQL.

Anyways, You can contact Microsoft and purchase licence of Enterprise/Standard Edition.

http://www.microsoft.com/sql/howtobuy/getsql.mspx

HTH!

Balmukund

I am sure that patch is not applied for Tools properly. Look at Management studio (Help>About)

Microsoft SQL Server Management Studio

Can you also check setup logs for...

there is high possibility that either

1. server and client are not on same service pack level

OR

2. we did ignore some error during service pack OR RTM setup

if you can...

I don't have any mirroring setup for three instances. but my question is the new mirroring session has same database name as earlier pair? Since you said two are working,...

SQL Server Setup fails unexpectedly when you try to install SQL Server 2005 Service Pack 2

http://support.microsoft.com/default.aspx?scid=kb;EN-US;935297

then go for it 😀

1. it does not need reboot.

2. If any applicaiton is using sa login to connect to SQL database then you need to modify application(s) also

As per KB, There was a bug which will not allow to add witness if the database name is same for another pair. By applying the fix mentioned in KB,...

get the SPID of the process which is running stored procedure and kill the spid.

contact me at bmlakhani@yahoo.com if its urgent

Standard to Entrerprise is completely supported

http://msdn2.microsoft.com/en-us/library/ms143393.aspx

Adam Bean (3/14/2008)

---

Think I found my answer ...

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Database mirroring will not be able to initialize if transaction log records have been truncated from the log by log backups....

I would repeat your answer "NO" 😀

SQL Server 2008 would have this feature out-of-the-box.

its called Change data capture (CDC)

It runs on Virtual desktop which you would not be able to see..

What exactly you want to achieve?