Two days ago, I was participating TechEd India 2011 and I had a great time presenting on various subjects. My computer fortunately behaved very well and I consider myself lucky for it. However, very next day, today, when I went to the office and turned on the machine, it did not start SQL Server. I was a bit confused and very quickly checked SQL Server Services. I noticed that services were OFF. I tried to turn on the services, but it keeps on giving me following error about request failed.
SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal
Earlier I wrote SQL SERVER – Challenge – Puzzle – Usage of FAST Hint and I did receive some good comments. Here is another question to tease your mind. Run following script and you will see that it will thrown an error. DECLARE @mymoney MONEY; SET @mymoney = 12345.67; SELECT CAST(@mymoney…
Read More
SQL SERVER – FIX ERROR 3702 Cannot drop database “MyDBName” because it is currently in use
I often go to do various seminars and presentations at various organizations. During presentations I often create and drop various databases for the demonstration’s purpose. Recently in one of the presentations, I tried to remove my recently created database, I got following error 3702 which is related to user cannot drop database.
SQL SERVER – Recycle Error Log – Create New Log file without Server Restart
The job of a consultant is always interesting – sometimes one becomes very busy and at times, over busy. I have been overwhelmed with recent performance tuning engagements. In one of the recent engagements, a large number of errors were found in the server. I noticed that their error log filled up very quickly. I also noticed a very interesting action by their DBA. I observed that after we make some changes in the server to avoid the errors, the DBA restarted the server. I asked him the reason for doing so. He explained every time that when he restarts the server, a new error log file is created. The current log file is renamed as errorlog.1; errorlog.1 becomes errorlog.2, and in a similar way, it continues. This way, after making some change, we can watch the error file from the beginning.
SQL SERVER – Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.
I recently got email from blog reader with following error. MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode. The fix of the same is very easy. Fix/Workaround/Resolution: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ad Hoc…
Read MoreSQL SERVER – Corrupted Backup File and Unsuccessful Restore
If you are an SQL Server Consultant, there is never a single dull moment in your life. Quite often you are called in for fixing something, but then you always end up fixing something else! I was recently working on an offshore project where I was called in to tune…
Read MoreSQL SERVER – Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it
I was recently getting following error in my StreamInsight Application. Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it. The solution was very simple, I had to enable exception of the my port in my windows firewall. The way…
Read More