(K Balaji) SQL Server 2000 Reporting Services is a server-based reporting solution that can deliver interactive Web–based reports. This article describes a problem that occurs when you access a custom assembly in your Reporting Services report that does not have sufficient permissions on the resourc

(Greg Robidoux) There are many reasons that you would want to move a database from one server to another, disaster recovery, refreshing a test environment, data analysis or maybe something else. Restoring the database is the easy part, but then you may be left with mismatched logins and database use

When an encrypted logon packet is received in two network reads, you may receive an exception access violation in Microsoft SQL Server 2000. This problem occurs when the following conditions are true: • The Ssnetlib.dll file is build 818 or a later build. • Encryption is supported, and both the

(Donald Farmer) For years we have been told that Extract Transform and Load (ETL) development is a struggle between hand-coding and tools. Well, the ETL struggle is over and the winner is the developer who chooses Microsoft SQL Server Integration Services (SSIS). SSIS enables you to easily integrate

(Gregory A. Larsen) There are many different kinds of joins, like INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN. The first three of these different join types are implemented in Access, but FULL OUTER JOIN is not. If you need to perform a FULL OUTER JOIN in Access, are you ”

During a logon process to SQL server the following error may appear: “Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)”.

(Randy Holloway) SQL Server 2005’s HTTP/SOAP endpoints provide SQL Server developers with new capabilities for using Web services within SQL Server. It’s worth noting though that Web services aren’t new to SQL Server 2005. In SQL Server 2000, SQLXML provided a set of supplemental tools that exte

(Muthusamy Anantha Kumar) In order to satisfy the demands of General-Controls review by public auditors and regulatory agencies, companies should monitor the security events of every production system they have. This article illustrates how to use Microsoft Logparser 2.2, Job Scheduler and SQL S

(Scott Mitchell) Virtually all ASP.NET applications of interest work with database data at some level, and one of the most common databases used in ASP.NET applications is Microsoft’s own SQL Server database. With relational databases like SQL, commands are issued through the SQL syntax, which inclu

After you upgrade to Microsoft SQL Server 2000 from SQL Server 7.0, query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column. For example, a query that is similar to the following may perform slower after you upgrade to SQL Server 2000: