 |
Reading Text Files Into Tables with line numbers.
|
| Total Hit (2372) |
Some times we need to read text file line by line or read a specific line using T-SQL. This article will explain a simple technique using xp_CmdShell stored proc.
Let's first create a sample file which we will import into SQL Server table.
<b>test.txt</b>
«code LangId=999»<Pre>Hello this is a
....Read More |
Rating
 |
|
|
|
|
|
|
|
File details using NT commands & undocumented SP.
|
| Total Hit (2288) |
Getting file details is easy using the undocumented extended SP 'xp_getfiledetails'. But you can't rely on this to be the same between versions of SQL Server or even service packs. So here is an alternative method using the standard NT commands. The undocumented SP is also shown for completeness.
....Read More |
| Rating
|
|
|
|
How to install MSDE
|
| Total Hit (4038) |
To install MSDE first extract files to a folder e.g. c:\sql2ksp3 then run folloing command on command prompt
c:\>cd sql2ksp3
You can specify installation option either in command line itself or specify in setup.ini
«b»[1] Specifying parameters in command line«/b»
For example the following
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Stored procedure to set/reset columns's identity property
|
| Total Hit (3391) |
You can use ALTER TABLE statement to add/remove column and to change some attributes of a column but there are some limitations with ALTER TABLE statement. You can not use ALTER TABLE to set a column as an identity column (Auto Increment field). You can ADD a new column with IDENTITY property but ca
....Read More |
Rating
 |
|
|
|
|
|
Monitoring Disk Space and Sending Alerts with TSQL
|
| Total Hit (5706) |
Monitoring disk space is one important task for SQL Server DBAs. To proactively monitor disk space, we want to be notified when disk space is below certain level. We also want to collect database file size information over time for trend analysis, for which Gregory Larsen has an excellent article "A
....Read More |
| Rating
|
|
|
|
How do I set up and configure SQL Mail?
|
| Total Hit (1193) |
SQL Mail provides a way to send EMail from Micosoft SQL Server. The focus of this FAQ is configuration of SQL Mail. There are other ways to send Email from SQL Server. Links to articles about these alternatives to SQLMail are listed at the end of this FAQ.
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
How to Install Windows 2000 Cluster Services
|
| Total Hit (546) |
SQL Server clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL Server 7.0 or SQL Server 2000, and time. Lots of it. The purpose of this article is to get you started along your way to SQL Server clustering. As a precursor to this step, you must first install and configu
....Read More |
| Rating
|
|
|
|
Multiple Paths in Workflow
|
| Total Hit (970) |
Branching workflow is a common requirement, and is quite easy to achieve using the basic On Success or On Failure constraints available through the designer. However branches go in different directions and do not meet up again.
|
| Rating
|
|
|
|
Application Design Optimization Tips
|
| Total Hit (1019) |
Here are fifteen tips that you can use to ensure your Application Designs are performing in the most efficient manner possible.
|
| Rating
|
|
|
|
|
|
XML and SQL 2000 (Part 4)
|
| Total Hit (1146) |
In the fourth article of the series dealing with XML related features of SQL Server 2000, I will discuss the implications of various configuration options available when using IIS Virtual Directory Management for SQL Server. As described previously, the Settings tab of the Virtual Directory Properti
....Read More |
| Rating
|
|
|
|
Bryan's WebLog for Reporting Services
|
| Total Hit (1019) |
Using an External DataSet with Reporting Services Reports
Writing Custom Code for Reporting Services Reports
GetReportParameters method
Welcome Tudor to Reporting Services Blogging
Reporting Services Service Pack 1 Now Available!
And many more....
....Read More |
| Rating
|
|
|
|
Troubleshooting SQL Server Alerts
|
| Total Hit (1091) |
If you have problems with Microsoft SQL Server alerts, review this troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
Exporting SQL Data as XML
|
| Total Hit (3228) |
In my last article, Importing XML into SQL Server 2000, we looked at various techniques to import the XML data into SQL Server. To complement that, this article will focus on some of the methods that you can use to export relational SQL data to the XML format.
More specifically, we'll explore th
....Read More |
| Rating
|
|
|
|
Using Sets in MDX Queries
|
| Total Hit (1434) |
This is the sixth tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services ("Analysis Services,"); our primary focus is the manipulation of multidimensional
....Read More |
| Rating
|
|
|
|
Dynamic ORDER BY Statements in Stored Procedures
|
| Total Hit (1645) |
When creating data-driven Web applications, it is ideal to place the actual SQL statements into stored procedures, and to have the Web pages, then, call the appropriate stored procedures rather than executing the SQL statements themselves. (If you are unfamiliar with what stored procedures are, or t
....Read More |
| Rating
|
|
|
|
XML and SQL 2000 (Part 3)
|
| Total Hit (1077) |
In the third article of this series, we will look into executing T-SQL statements against SQL Server 2000 via HTTP. This functionality is provided by SQLXML component (implemented in the form of SQLISAPI.DLL, which is included as part of SQL Server 2000 installation). The updated versions of this co
....Read More |
| Rating
|
|
|
|
Implementing Application Roles
|
| Total Hit (1157) |
SQL Server 7.0, as well as SQL Server 2000, support several technological feature enhancements that allow for a faster time to completion for database and application development. Application roles exist as SQL Server database objects that allow developers and database administrators to assign SQL S
....Read More |
| Rating
|
|
|
|
How to Create ODBC DSN on multiple SQL server machines
|
| Total Hit (2084) |
In a typical Client - Server environment it is often necessary to create ODBC DSN on many client machines or servers for front-end applications such as VB, or MS-Access, which uses ODBC DSN for linked tables. Even for creating linked servers to heterogeneous systems like Oracle, Sybase and mainframe
....Read More |
| Rating
|
|