|
SQL 2000 Install Generates PENDING FILE OPERATIONS Error
|
Total Hit (2833) |
When trying to install SQL Server 2000 on an NT machine sometimes you may receive the following error.
<font color=red><b>"A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."</b></font>
SQL Setup is
....Read More |
Rating
|
|
|
Change Object Owner
|
Total Hit (3396) |
This is very handy stored procedure which I use all time to change object owner. Many times you create object as a different user other than "dbo" and things start breaking. I use this sp to change owner off all objects to "dbo".
«code LangId=6»/*
This stored procedure can be used to run through
....Read More |
Rating
|
|
|
|
|
How to script SQL tables using SQL DMO
|
Total Hit (2253) |
«B»Introduction«/B»
SQL-DMO encapsulates SQL Server components and presents them as attributes of the component piece to you as properties of an object instance. You would have to alter the properties of the instance or use object methods to automate SQL Server administration. This article takes
....Read More |
Rating
|
|
|
Can I Backup Across the Network?
|
Total Hit (2548) |
You can backup over the network. I prefer to use UNC paths because mapping drives under SQL Server can cause some weirdness (Hmm... maybe an article on that).
My favorite method is to not even muck with backup devices:
BACKUP DATABASE Foo TO DISK = '\\myserver\myshare\foo.bak' WITH INIT
....Read More |
Rating
|
|
|
How to recover database from suspect mode?
|
Total Hit (26307) |
Sometime your database may go into suspect mode. A database can be marked suspect for one of the following reasons (this is from SQL Server Books Online):
«code LangId=0»If one or more database files are not available.
If the entire database is not available.
If one or more database files are
....Read More |
Rating
|
|
|
Strip dirty characters from a numeric string.
|
Total Hit (1733) |
A technique to search & remove dirty characters from a numeric string. This problem shows how you can simplify the solution by looking at only what is needed.
|
Rating
|
|
|
|
|
Wrong usage of UPDATE FROM clause.
|
Total Hit (1518) |
This script demonstrates the wrong usage of UPDATE statement with a FROM clause esp. in case of a table with 1-to-many relationship with another tables(s).
|
Rating
|
|
|
Check job status using T-SQL
|
Total Hit (4882) |
You can use the following stored proc to retrive status of SQL Server job.
If user executing this SP is not in sysadmin then make sure that user has "Select" permission on <Code>msdb..sysjobs</Code> table and execute permission on <Code>master.dbo.xp_sqlagent_enum_jobs</Code> extended stored pro
....Read More |
Rating
|
|
|
Tutorial : A Tour Of ActiveX Script
|
Total Hit (644) |
One of the ways to gain a lot of Flexibility in DTS is to use an ActiveX script. They can be found in the transform Data Task, the Data Driven Query Task and as a standalone task. When we look at the actual screens there is a lot to see and some of the things can be daunting especially if you have n
....Read More |
Rating
|
|
|
Locking in SQL Server 7.0
|
Total Hit (1819) |
In this article, I want to tell you about general details of SQL Server 7.0 locking, about Transaction Isolation Levels, what kind of Transaction Isolation Level exists, and how you can set the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hints, about Lock Escalati
....Read More |
Rating
|
|
|
|
Implementing CRUD Operations Using Stored Procedures: Part 2
|
Total Hit (547) |
In database terms, CRUD stands for the four essential database operations: Create, Read, Update and Delete. To create a high performance system, these four operations should be implemented by stored procedures, each procedure implementing one of the four operations. This is the second in a two part
....Read More |
Rating
|
|
|
Implementing Error Handling with Stored Procedures
|
Total Hit (631) |
This is one of two articles about error handling in SQL Server. This article gives you recommendations for how you should implement error handling when you write stored procedures, including when you call them from ADO.
|
Rating
|
|
|
SQL Server "Yukon" Beta 1 Transact-SQL Enhancements
|
Total Hit (943) |
This white paper introduces several of the new enhancements to Transact-SQL in Microsoft SQL Server "Yukon" Beta 1. These new features can increase your expressive power, the performance of your queries, and your error management capabilities. This paper focuses mainly on relational enhancements tha
....Read More |
Rating
|
|
|
MDX in Analysis Services: Intermediate Concepts - Part 2
|
Total Hit (913) |
This is the third 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 (to which I will refer in most cases as simply "Analysis Services," to save time
....Read More |
Rating
|
|
|
Random Sampling in T-SQL
|
Total Hit (784) |
Imagine a company with a data warehouse that contains tens of millions of records on individuals. The analysts want to use it to do statistical analysis or data mining. Because it can be time-consuming to work with such a large number of records, analysts often select a small, random subset of recor
....Read More |
Rating
|
|
|
Linked Servers : An overview
|
Total Hit (1949) |
Linked servers provide connectivity to external data sources, allowing you to access data and run procedures in SQL Server other than the one you are currently running on.
|
Rating
|
|
|
|
|
|
|
|
Shrinking Databases and Logs - SQL 7 and Higher
|
Total Hit (1869) |
SQL 7 and SQL 2000 allow automatic file growth. Therefore, the files can grow large. It is important to understand how to reduce the database and log files sizes.
There are two DBCC commands to help shrink databases and files. Both are needed to reduce and maintain file sizes.
....Read More |
Rating
|
|
|
Backing Up and Restoring SQL Server Databases and Transaction Logs
|
Total Hit (1130) |
The backing up and restoring of databases and transaction logs is a way that SQL Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if media failure occurs or if the database is somehow damaged (for example, fro
....Read More |
Rating
|
|
|
A Comparison of SQL Server 2000 with Access 2000
|
Total Hit (1014) |
Often people in newsgroups ask about some comparison of Microsoft SQL Server and Microsoft Access. In this article, I compare Microsoft SQL Server 2000 with Microsoft Access 2000 regarding hardware and software requirements, price, features and products limits.
....Read More |
Rating
|
|
|
Developing with English Query
|
Total Hit (797) |
It is easy enough to build a query form that allows users to search based on one or two fields, but it is much more difficult to build form-based Web pages that allow searches across multiple tables and multiple fields. A more flexible search is difficult to implement (there are many problems beyond
....Read More |
Rating
|
|