|
Stored procedure to generate a simple or complex random password
|
Total Hit (3025) |
This procedure generates random passwords using RAND() function. It can be configured to generate a simple or a complex password. You can also customize the length of the password generated. Complex passwords will include upper and lower case letters, numbers and special characters. See the code to
....Read More |
Rating
|
|
|
|
SQL Server 2000 useful undocumented stored procedures
|
Total Hit (3883) |
In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 2000.
«B»sp_MSget_qualified_name«/B»
The sp_MSget_qualified_name stored procedure is used to get the qualified name for the given object id.
Syntax
sp_MSget_qualified_name objec
....Read More |
Rating
|
|
|
Enumerate the users' rights on a DB's objects
|
Total Hit (2732) |
SQL Server provides several security levels, and the control that the system administrators can pursue over the DB's objects is extremely accurate. It's often useful to know which rights each user has. As you might know already, a lot of administrative SQL Server tasks can be performed through the p
....Read More |
Rating
|
|
|
The ALL clause can speed up UNION statements
|
Total Hit (2814) |
If you omit the ALL clause in an UNION statement, SQL Server must delete duplicate values, which in turn means that it has to sort the two sub-resultsets that have to be combined. Needless to say, this is a time-consuming operation.
In most cases, you decide whether to use the ALL clause dependin
....Read More |
Rating
|
|
|
Quickly Disable Constraint and Triggers
|
Total Hit (2005) |
In a previous article, I covered how to use the sp_msforeachtable system stored procedure to look through a list of tables and perform an action on them.
When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you k
....Read More |
Rating
|
|
|
|
Updating a table from another table
|
Total Hit (1556) |
As the article title suggests, an UPDATE statement is able to reference data in other tables. This is done using a FROM clause.
Let's use the Northwind database as our example here. A usual update statment to update a product's list price might look something like this.
«Code LangId=6»
UPDATE P
....Read More |
Rating
|
|
|
|
|
Copy text or image into or out of SQL Server
|
Total Hit (7323) |
In this article, I want to show, how you can copy a single text or image value into or out of SQL Server by using the textcopy.exe utility. You can find this utility in the directory containing the standard SQL Server EXE files (C:\Mssql\Binn for SQL Server 6.5, by default and C:\Mssql7\Binn for SQL
....Read More |
Rating
|
|
|
How to configure E-Mail Subscription with SQL Reporting Services.
|
Total Hit (4883) |
When you install reporting services it will ask you for SMTP settings. If you skip those settings then probabbly when you create new subscription you will only see "file share" option.
In order to enable "Email Subscription" you need to do couple of steps.
1. open the RSReportServer.config fil
....Read More |
Rating
|
|
|
|
|
|
Log Shipping
|
Total Hit (696) |
It is 2 PM on a record business day. The Microsoft® SQL Server™ 2000 server housing your mission-critical customer database experiences a disk failure. What do you do? When was the last known good backup? Is there another server available to restore the backup onto? Is SQL Server even on that server
....Read More |
Rating
|
|
|
|
Using Forms Authentication in Reporting Services
|
Total Hit (993) |
Learn about Reporting Services security extensions with a primary focus on Forms Authentication. In addition, download and deploy a sample Forms Authentication extension for Reporting Services. (23 printed pages)
|
Rating
|
|
|
|
Sequential Numbering/Counting of Records with SQL Server
|
Total Hit (666) |
Microsoft SQL server does not support a method of identifying the row numbers for records stored on disk, although there are a number of different techniques to associate a sequential number with a row. You might want to display a set of records where each record is listed with a generated number th
....Read More |
Rating
|
|
|
MDX at First Glance: Introduction to SQL Server MDX Essentials
|
Total Hit (1372) |
To get the most out of the MDX Essentials series, we need to have installed at least the Analysis Services component of MSSQL Server 2000. While the full installation of SQL Server 2000 allows for virtually any exercise we might undertake, the majority of our sessions center on Analysis Services, th
....Read More |
Rating
|
|
|
How can I dynamically set the Access System Database
|
Total Hit (668) |
You can easily change the filename for an Access database connection using the Dynamic Properties Task in SQL Server 2000. Unfortunately the property selection dialog does not allow access to the system database property (Jet OLEDB:System database) which you need to specify correctly when accessing
....Read More |
Rating
|
|
|
A better Soundex code
|
Total Hit (1029) |
Terms that are often misspelled can be a problem for database designers. Names, for example, are variable length, can have strange spellings, and they are not unique. American names have a diversity of ethnic origins, which give us names pronounced the same way but spelled differently and vice versa
....Read More |
Rating
|
|
|
The comparison of SQL Server 2000 with MySQL v4.1
|
Total Hit (889) |
Often people in newsgroups ask for a comparison of Microsoft SQL Server and MySQL. In this article, I compare SQL Server 2000 with MySQL version 4.1 regarding price, performance, platforms supported, SQL dialects and product limitations.
|
Rating
|
|
|
Data Transformation Services (DTS) in Microsoft SQL Server 2000
|
Total Hit (671) |
Database administrators often import, export, and transform data in support of tasks such as data consolidation, archiving, and analysis; for application development purposes; and for database or server upgrades. Data Transformation Services (DTS) in SQL Server 2000 provides a set of graphical tools
....Read More |
Rating
|
|
|
|
Minimizing SQL Server Stored Procedure Recompiles
|
Total Hit (699) |
This article discusses the reasons that SQL Server 2000 decides to recompile a stored procedure and demonstrates techniques that can be used to minimize recompilation. If your system makes extensive use of stored procedures, minimizing recompilation can give you a nice boost in performance.
....Read More |
Rating
|
|
|
|
MDX Essentials: Member Functions: More "Family" Functions
|
Total Hit (678) |
This is the sixth article of the series, MDX Essentials. The primary focus of this series is an introduction to MDX. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designe
....Read More |
Rating
|
|
|