|
|
|
|
|
|
 |
Perform an MSDE database backup through Transact-SQL
|
| Total Hit (2642) |
The MSDE database engine is 100% compatible with SQL Server and subject to the same license policy of the Jet engine. One of the fundamental differences between MSDE and SQL Server is the lack of any graphical tool for the administration. Many users take advantage of Access 2000 as administrative fr
....Read More |
Rating
 |
|
|
|
|
|
|
|
How to write a trigger for INSERT, UPDATE or DELETE operation ?
|
| Total Hit (2335) |
Here is very basic code to write trigger for INSERT, UPDATE or DELETE operation on a table. Internally SQL Server manages two tables (inserted and deleted) to perform trigger operations.
All inserted records can be retrived by quering "inserted" table
«code LangId=6»select * from inserted«/cod
....Read More |
Rating
 |
|
|
|
Database Backup Script
|
| Total Hit (3411) |
The procedure should be placed in an Admin database and scheduled - normally to run every day. The table DatabaseBackup should be created as defined near the top of the procedure. The call to be scheduled is in comments near the top of the procedure.
It will backup every database on the server to
....Read More |
| Rating
|
|
|
|
Create temporary or regular table with SELECT INTO
|
| Total Hit (3160) |
The SELECT INTO statement is a combination of the SELECT and INSERT T-SQL commands, that lets you create a new table from a subset of the rows and/or the columns of another table. The target table of this command is often a temporary table:
«Code LangId=6»
SELECT au_fname, au_lname INTO #authors
....Read More |
| Rating
|
|
|
|
Read current sql server error log.
|
| Total Hit (3208) |
This procedure reads the current SQL Error Log. Optionally it can read any log (or text file) specified by @LogFilename
|
| Rating
|
|
|
|
UDF in CHECK & DEFAULT CONSTRAINTS.
|
| Total Hit (3264) |
User-defined functions in SQL2000 provide a powerful way to reuse code / logic. This example shows how you can use UDFs in CHECK & DEFAULT constraints of a table.
|
| Rating
|
|
|
|
|
|
Troubleshooting SQL Mail
|
| Total Hit (745) |
If you have problems with SQL Mail, review this 20-point troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
MDX in Analysis Services: Calculated Members: Introduction
|
| Total Hit (767) |
This is the seventh 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 multidimension
....Read More |
| Rating
|
|
|
|
Introduction to Database Replication
|
| Total Hit (747) |
As it relates to SQL Server, replication is a way of keeping data synchronized in multiple databases. Implementing and maintaining replication might not be a simple proposition: If you have numerous database servers that need to be involved in various types of replication, a simple task can quickly
....Read More |
| Rating
|
|
|
|
Working with files and the FileSystemObject
|
| Total Hit (1110) |
The ability to work with files gives us great flexibility in how we use DTS. It allows us to add some intelligence into a package, and cope with unexpected situations automatically. The key to working with files is the Scripting Run Time as this gives us the FileSystemObject, which can be fully expl
....Read More |
| Rating
|
|
|
|
|
|
XML and SQL 2000 (Part 8)
|
| Total Hit (1058) |
So far, this series has concentrated on configuration options available via the graphical interface of IIS Virtual Directory Management for SQL Server. However, newer versions of SQLXML, in addition to the features we have already covered, provide another type of functionality, accessible through sc
....Read More |
| Rating
|
|
|
|
Working with COM Objects from within T-SQL
|
| Total Hit (2219) |
In this article I want to tell you about how you can work with COM objects from within Transact SQL. You can use OLE Automation Stored Procedures (extended stored procedures with sp_OA prefix) to create a COM object in T-SQL and use that object's methods and properties.
Introduction
General co
....Read More |
| Rating
|
|
|
|
SharePoint and Reporting Services - Installation Resources
|
| Total Hit (1041) |
As posted in several blogs recently, Microsoft has made available a collection of Reporting Services reports based on SharePoint Portal Server data (”Microsoft SQL Server Report Pack for Microsoft Office SharePoint Portal Server 2003”). The integration story between SharePoint and Reporting Service
....Read More |
| Rating
|
|
|
|
Coping with No Column Names in the SSIS OLEDB Data Source Editor
|
| Total Hit (862) |
Sooner or later you'll create a DataFlow and come across this type of dialog box for the OLE DB source:
So, why does this problem occur, when all previous attempts have worked? Well the most likely case is that you are selecting from a temporary table as the last statement in the source stored pr
....Read More |
| Rating
|
|
|
|
Tutorial : Importing A Text File Using The DTS Wizard
|
| Total Hit (686) |
This tutorial came about from watching the Newsgroups and realising that although people had heard of DTS they were unsure as to what it is and where to find it. We wanted to explain DTS to people and give them an understanding of what it does so they can go away and use it themselves.
....Read More |
| Rating
|
|
|
|
|
|
SQL Server 2005 Full-Text Search: Internals and Enhancements
|
| Total Hit (989) |
The full-text search feature of Microsoft SQL Server 2005 delivers enterprise search functionality integrated into the database. Significant enhancements in the areas of performance, manageability, and functionality deliver best-of-breed search capabilities for applications of any size.
This pap
....Read More |
| Rating
|
|
|
|
Tutorial : Write File Transformation
|
| Total Hit (729) |
In this article we will show you how to export a file stored in your SQL Server table out to disk. For this we will need two tables. One will be the table that holds the file and its name and the other is a dummy table that we need when using the WriteFile transformation.
....Read More |
| Rating
|
|
|
|
Reporting Options for Analysis Services Cubes: MS Excel 2002
|
| Total Hit (1665) |
This is the tenth article of the series, Introduction to MSSQL Server 2000 Analysis Services. As I stated in the first article, Creating Our First Cube, the primary focus of this series is an introduction to the practical creation and manipulation of multidimensional OLAP cubes. The series is design
....Read More |
| Rating
|
|
|
|
Data Extraction, Transformation, and Loading Techniques
|
| Total Hit (2291) |
Chapter 17, "Data Warehouse Design Considerations," discussed the use of dimensional modeling to design databases for data warehousing. In contrast to the complex, highly normalized, entity-relationship schemas of online transaction processing (OLTP) databases, data warehouse schemas are simple and
....Read More |
| Rating
|
|
|
|
JOIN Fundamentals
|
| Total Hit (695) |
Very often we need to pull data from 2 or more sources (tables or views) and combined them into 1 logical unit.
There is often a bit of confusion on when and how to use them.
I will first describe each JOIN type and how it works with the 2 tables involved. The major JOIN types are color cod
....Read More |
| Rating
|
|
|
|
Monitor Disk Space on Multiple SQL Servers
|
| Total Hit (616) |
In the typical IT department, an un-avoidable task is to monitor the disk space on all drives on certain servers. In addition, the methods presented here will help in monitoring the growth of files. In this article, I am going to discuss three different ways to monitor disk space on a list of server
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables
|
| Total Hit (1985) |
In the previous article of this series, we covered types of DTS Designer tasks that are more straightforward. We will continue this discussion here, focusing on ones that are more complex. However, before we proceed, we will look into the concept of DTS Global Variables, which will help us understan
....Read More |
| Rating
|
|