Feeds:
Posts
Comments

Archive for the ‘SQL Error Messages’ Category

Recently, while I was scheduling a live meeting for one of my online training sessions, I kept receiving the following error message repeatedly. I had never encountered this type of error before, and despite searching online for a long time, I could not solve this problem.

After several failed attempts, I finally managed to fix this [...]

Read Full Post »

I have set up replication at many different organization. One error I quite commonly face is after I have removed replication I can not remove database. When I try to remove the database it gives me following error.
Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
Fix/Workaround/Solution:
The solution is [...]

Read Full Post »

I am currently traveling on a month-long training assignment for Business Intelligence. For demonstration purposes, I use Virtual PC files and hands-on lab examples for attendees of the training. The size of my VPC file is about 15 GB. Initially, I copy this file to a USB Drive and then move it to other computers, [...]

Read Full Post »

Unlike my usual articles today’s article is not at all related to SQL Server but something drove me to include it on my blog. This issue snatched away my precious few hours. It took me over 2 hours to resolve it yesterday, which barred me from doing research on SQL Server. I am sure many [...]

Read Full Post »

I had previously written two articles about an intriguing observation of triggers online.
SQL SERVER – Interesting Observation of Logon Trigger On All Servers
SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution
If you are wondering what made me write yet another article on logon trigger then let me tell you the story [...]

Read Full Post »

Just a day ago, I was installing SQL Server Express on backup computer. I only use this computer when I have something to experiment. While installing SQL Server Express I found following error in my error log which prevented successful installation to computer. It was difficult to initially understand the problem by itself, after some [...]

Read Full Post »

I often receive emails from reader requesting solution to following error:
“SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem.” in a modal dialog with the title “SQL Writer”
While searching online there are so many different solution and many time [...]

Read Full Post »

Regular readers of my blog are aware of the fact that I have written about this subject umpteen times earlier, and every time I have spoken about a new issue related to it. Few days ago, I had redone my local home network. I have LAN setup with wireless router connected with my four computers, [...]

Read Full Post »

Today, we will delve into a very simple issue that one of the Jr. Developers at my organization confronted. I have a preference for T-SQL. According to me, all the developers should always use T-SQL instead of Design feature of SQL Server Management Studio (SSMS). In fact, sound knowledge of T-SQL has the potential to [...]

Read Full Post »

Older Posts »