Hi, We have a website that runs on SQL express 2005. When we send news letters to our readers, the SQL express database stops accepting connections after some time. For example, before sending the news letter. sp_who2 shows say 80 connections. After the news letter are gone, connections shown by sp_who2...

Hi, Sure, you can use your Mirrored database for the reporting purpose, to achieve this you should create a snapshot on mirrored database point all your reporting to it read article http://technet.microsoft.com/en-us/library/ms175511.aspx AFAIK, without breaking the LS we can not move it. Regards

I have one reporting application which was running smoothly for last 3 years without any problem.For last 3 days I observed lots of blocker processes which brought down the performance Every maintainence activity(like re indexing,update statistics,reorganizing,shrinking etc) is working fine. There is...

Hi, I would suggest you to go through the articles http://msdn.microsoft.com/en-us/library/ms151172(SQL.90).aspx , http://msdn.microsoft.com/en-us/library/ms152569(SQL.90).aspx and http://www.sql-server-performance.com/articles/dba/replication_across_internet_p1.aspx I have configured merge replication...

i have an application in VB.net which retieves about 1 million records. all this time it worked fine. but today when i tried to retrieve the information i got a sql timeout. wt can i do to avoid this??

Hi, We have two query plans for the same "prepared SQL statement", one runs slower and one runs faster. The on runs slower does SORT operation which takes more CPU resources and has StatementOptmEarlyAbortReason="GoodEnoughPlanFound", the other one (Good one) doesn't do any sort...

i had gone through this url and find the network connectivity issues but both of my servers pinging each other still my jobs fails please find the DTD Package which may have issues:-- DTSRun /S "shsqlfilt01" /N "Transfer Foreign Returned Serial Numbers (new to new)" /A "Customer"...

Hi All, Yesterday one of my jobs failed and from the job history i got the message below could you please anyone help me out to solve this issue Server SHSQLFILT01 Job Name Transfer SNs (and returns) to Shipley Step Name Transfer HU Duration 00:00:42 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator...

Hi Frank, I ran the query which you have suggested and got the error message :-- Msg 1016, Level 15, State 2, Line 38 Outer join operators cannot be specified in a query containing joined tables select r . Description , b . build , s . serialno , bc . childserialno From TbltcvRev r , Tblsn s , Tblsnbuild...

see if the snapshot folder is their and by any chance not deleted by anybody and it has a proper NT permission for the SQLServer Agent account....also check the snapshot agent job history for the exact error message which will help u rectify this issue