I don't think you can. Read only means that no transactions are allowed to the database, either user transactions or maintanence transactions like reorgnize data pages, defrag index etc.

I cannot figure out a simple solution. One possible way is to use event notification to monitor login event:

CREATE EVENT NOTIFICATION Check_Login

   ON SERVER

   FOR AUDIT_LOGIN

   TO SERVICE 'YourServiceName', 'current database'

You...

If you are using SP4, take a look http://support.microsoft.com/default.aspx/kb/906344.

When you catch an sqlexception, it has an sqlerror object, which has a property "Class". this is the severity value in sql server. the sqlerror class has other properties like Source, Message,...

System databases cannot be detached and attached.

When you setup the second instance, the system databases are all created by the setup. You can just attached Your database if you donot...

The registry change Steve mentioned is to disable security for RPC. If MSDTC is configured properly, you do not need to do this. But sometimes it just does not work regarless...

Parallel execution plan sometimes really hurts the performance. I encountered several times that the parallel plan was more than 10 times slower for the same query. Once it even hang there...

SQL junkie: Agree with you , your company is really burning money. For a 2GB database with increasing rate of 1GB annually, the server is much over qualified.

To SQLBill: the question is about file size, not memory size. They are different thing.

To Vishal:

One possible reason is you enabled disk quota on the database file drives and setup...

SQL server generated a parallel execution plan with 3 threads(ecid=0 to 2). 0 is the main thread. It can happen if the 3 threads have unblanced load and the main thread...

I agree with the above comments about database.

Usually it's not a good idea to put business logic on web server. It's better to be on a dedicated server protected...

The following link lists the features for each edtion. peer to peer replication is an option for transactional repl. So based on the link, it's supported by standard edtion.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

I tried the bulk insert scenario, no problem.

I used to have a SP that had performance issue. My trick is adding WITH RECOMPILE option in the create procedure statement. It finished within 1s and very stable.

Recompiling does...

SQL 2005 supports encrypting/decrypting data natively.

The following code is from BOL:

USE AdventureWorks;

GO

--If there is no master key, create one now

IF NOT EXISTS

    (SELECT * FROM sys.symmetric_keys WHERE...