(Vinod Kumar) In the first part of the article we have seen how we can write an tables data into SQL Server using simple DTS techniques (read Part I). In this article we look at the other side of getting data out back from an Excel sheet back into SQL Server.

(Alexander Chigrik) If you have problems with SQL Server jobs, review this troubleshooting checklist to find potential solutions.

(Eli Leiba) This user-defined in-line T-SQL function for SQL Server 2000 creates an in-memory sequence flush 1,2,3….N where N is a natural number with a value less than 1000. If N needs to be greater than 1000, the function can be modified to satisfy this as well. (script)

(Steve Kass) SQL Server provides several solutions for importing and exporting text files. Data transformation services (DTS) supports text as a data source or destination; the bcp and osql utilities can import and export text files; and T-SQL provides BULK INSERT for importing text. Another solut

(Erland Sommarskog) Error handling in stored procedures is a very tedious task, because T-SQL offers no exception mechanism, or any On Error Goto. All you have is the global variable @@error which you need to check after each statement for a non-zero value to be perfectly safe. If you call a stored

(Gregory A. Larsen) If you have ever had the need to show detailed data of individual transactions and also keep a running total, subtotals, and grand total columns at the same time, but were not exactly sure how to tackle the problem then this article might help. In this article I will show you a f

(Barbara Darrow) Reporting Services for SQL Server 2000 will make its official debut on a Jan. 27 Webcast, according to a Microsoft spokeswoman. The company had been trying to get the database add-in out by year’s end. Last June, Microsoft changed course on reporting services, which were to be a

(Allan Mitchell) One of the most common things asked for by people using DTS is the ability to loop through a directory and process files along the way. This is how I do it. Although it may look a little complicated for what is quite an easy task it isn’t trust me.

(Michael Otey) Security continues to be one of the hottest topics in IT. The Internet and protocols such as Simple Object Access Protocol (SOAP) and XML have driven constant-connection computing to new levels. And as new technologies make your systems more accessible, the threat from viruses and int

(Lennart Gerdvall) This VBscript code will check for low disk space on the local SQL Server. Schedule the package to run once a day, and let the job report to you by e-mail when a drive runs low on free space.