(Sriram Chitturi) SQL Server presently does not provide option to generate script for linked servers on an existing instance it provides for other objects which we see as “Generate SQL Scripts” on context menus. The tool provided in this article creates script for linked servers and gives an opt

(Brian Knight) This is the first part of a series of articles where I take you through my exploration of SQL Server 2005 Beta 2. In this part of the series, I’m going to cover what is SQL Server 2000’s strongest asset, its tools. The tools like Enterprise Manager and Profiler give you the quickest w

This article describes how to run SQL Server stored procedures and use parameters from an Active Server Pages (ASP) page.

Sometimes the need arises to select one or more unique values from a single field in an application. For example, this is useful when you want to query a multiselect list box. The sample code in this article demonstrates how to return a recordset based on values that match a list of comma-delimited

(Anup Kafle) You can use features in Microsoft Office InfoPath 2003 Service Pack (SP) 1 to work more efficiently with image objects and other data. Learn how to use BLOB data types to work with data stored in a Microsoft SQL Server 2000 database from an InfoPath form. InfoPath 2003 provides a ro

(William Pearson) We have touched upon partitions over the life of the Introduction to MSSQL Server 2000 Analysis Services series, as well as within other series at Database Journal. We recently discussed partitioning more specifically within our article Basic Storage Design, within which we introdu

The SQL Server 2000 Report Pack for Financial Reporting is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with a sample financial database called FinSampleDB. With the Report Pack, you have the choice of using the sample reports either as-is or as templates for design

(Jon Winer) Are you familiar with using the Command object in ADO? If so, migrating to ADO.NET shouldn’t be as much of a headache as you might think. Here I discuss a couple of the methods available using ADO.NET’s SqlDataReader and SqlCommand objects that map well to coding practices commonly utili

(Scott) Security in computer software applications allows you to control the answer to two critical questions. Who will you grant access to? What operations will you allow them to perform? The first step in answering these questions is determining the identity of the person trying to access the data

When you use the PivotTable component and you choose the option to calculate totals based on visible items only, you may receive the following error message: The data source does not support totalling only visible items.