Great Article, I never imagined this kind of use for SQL Server...

Hi, Will this report disk/drive space for mounted Volumes?

Thanks

few other things to consider,

privilage for the service accounts?

using different service accounts for different applications.

If you are using replication etc ar you planning on using a separate account/or do...

Can the Service Broker Target(consumer) be an non SQL Server ? like an application server? Also can the service broker send messages to two seperate target servers?

Thanks

Thanks, We will remove the rowlock hint and also wrap the insert and Update in one transaction, So how having the insert and update in separate transaction within the same...

Thanks for the response. We haven't been able to reprodue the problem at all.

I didn't try removing the ROWLOCK HINT, will it help?

These are the procedures getting deadlocked.

CREATEPROCEDURE [dbo].[PROC_A]----...

Thanks

Ok , I Will try the open query but if thats slow is there an option in SQL 2008/R2 where I can put the database(with big talbe) on a shared...

I thought CTE's are not a feature in sql 2000?.The servers are in the same physical location. I will tell the LAN administrator about 1 GB NIC's.

Thanks

I found the log backups increased in size significantly(from few megs to over 20 GB ) around the time the index rebuild failed. The index rebuild happen only if the...

But why the log filled yesterday when its been running fine for ever is a mystery to me. There are about 15 indexes that are either rebuit or reorganized.

The index is rebuilt or reorganized every day based on fragmentation level. Never had an issue till it failed yesterday.

The autogrow is turned off for this database. The index maintenance ran sucessfully today. But still not sure why it didn't complete yesterday.It filled the log yesterday and never finished.

Thanks

Hi,Thanks for the reply. The insert/update operations at that time was no different than any other day. The recovery model was not changed ,its always in full recovery model. The...