small talk about Database Connections

I had a customer who had this PROBLEM. He said ” My Connection strings have changed! I don’t know how to get the right connectionstring in my application, and with .NET’s automatic garbage collection, I’m never quite sure what’s going on with database connections in my application. “ After my best effort to calm him down…

1

Creating a Linked Server from SQL 2K5 64-bit to SQL 2K5 32-bit

I ran into an issue creating a linked server on SQL 2005 64-bit. I was trying to connect to a 2000 32-bit server. The error I received was: OLE DB provider “SQLNCLI” for linked server “servername” returned message “Unspecified error”. OLE DB provider “SQLNCLI” for linked server “servername” returned message “The stored procedure required to…

1

Virus Programming

Everybody is scared of computer ‘virus’ as it does harmful actions on our computer. But when we look into the virus programming, we may certainly come out with the conclusion that it requires intelligence to code a virus.so it hought i pen down an article about basics of virus programing.LogicIt is easy to mess-up the…

4

Deadlock issues in Sql Server

Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. When this happens, SQL Server identifies the problem and ends the deadlock by automatically choosing one process and aborting the other process, allowing the other process to…

1