(Roger Jennings) In SQL Server 7.0, servers linked by OLE DB providers replace the remote server feature of earlier versions. In the past, servers used remote stored procedure calls for interserver communication. Judging from the few non-Microsoft hits returned by Web search engines on linked server

(Eli Robillard) The document assists users migrating from Microsoft Access to Microsoft SQL Server. Though written specifically for users of GenericDB, the process may be applied to any Access database. Of particular note are the steps to convert a Random Autonumber field to one which uses Increm

In a Crystal Enterprise (CE) environment with a SQL Server 7 APS database, when Service Pack 3 for SQL Server 7 is applied to the database, the password for username ‘sa’ can no longer be left blank. Therefore a password is entered. When an attempt is then made to restart the APS, it does not st

Within SQL Server there are several tools that you can employ to monitor, tune, and optimize performance. Here, I will explain how to utilize and interpret the results of SQL Server tools to optimize the use of database indexes. I’ll also discuss general indexing topics. Indexes are one of the b

There are some common reasons why a transaction log might not shrink when you use the DBCC SHRINKFILE or DBCC SHRINKDATABASE command. The SQL Server Books Online topics “DBCC SHRINKFILE” and “DBCC SHRINKDATABASE” provide detailed information, but a brief summary follows.

Every SQL Server application manager needs to move a large amount of data into or out of a SQL Server database at least once, so SQL Server has several tools for bulk data-transfer operations. In this article, I compare two familiar SQL Server utility programs—bulk copy program (bcp) and Data Transf

(Darren Green) This article will try and explain the different ways you can transfer packages between servers and other storage locations, either directly or as files. The most common requirement is to transfer between two SQL Servers, and this is the main focus here, but some methods can be adapted

DTS Import Wizard does not show Index Server OLE DB Provider in the list of sources. However, you can specify a distributed query with Index Server OLE DB provider as the source of your data. Steps to Copy FileSystem Data –Run SQL Enterprise Manager and run Data Transformation Import Wizard.

SQL-Server-Performance.Com and LockwoodTech Software are offering you an opportunity to participate in the shaping of a new software product for SQL Server. LockwoodTech Software has recently introduced Log Navigator, a software utility designed to read SQL Server’s transaction log. Although rec

(Gary Zaika) In SQL Server 2000, Microsoft introduced new features to satisfy its customers’ growing concerns about data security. One little-understood feature is automatic support of Secure Sockets Layer (SSL)-encrypted network traffic between the clients and the server. Encryption slightly slows