When the SQL Server is faced to the internet then you have to take utmost care to ensure that the each row in the table is not compromised to avoid any unprecedented activity. As it is getting popular that rise in SQL injection attacks has reminded the best practices and rules to secure the database...

Ok this is not new to say you can write stored procedures in any language to manage them in SQL Server, as 2005 version has started this CLR integration functionality that is exposed in an assembly called system.data.dll, which is part of the .NET Framework. So think about code access security in addition...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications A System.InvalidOperationException exception may occur when you try to use a Visual Studio .NET 2003 client application against a SQL...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server 2005 Reporting Services report http://support...

Keeping up with new technology is hard to do. Many years ago, I prided myself in keeping up with all of Microsoft technology, including SQL Server, Windows, Exchange, ASP Development, Visual Basic, and more. Today, I just can't keep up. I just can't find the time to know everything, so I have...

Very confusing error when trying to connect to a Database Engine (SQL Server 2008) using 'usual' windows authentication getting the following error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider...

I have had problem when installing SQL Server 2005 on one of the 64-bit server, the error was: There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. So as per the message I have looked in to the specified directory for...