 |
Send fax from SQL Server using Microsoft Word
|
| Total Hit (9981) |
This article explains how you can create a Microsoft Word document from T-SQL and fax it through a method exposed by its Automation object model.
You can create and destroy OLE Automation object using the sp_OACreate and sp_OADestroy, whereas you can use the sp_OAMethod to invoke a method, and t
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change Object Owner
|
| Total Hit (3472) |
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
|
|
|
|
|
|
|
|
|
|
|
|
Useful undocumented extended stored procedures
|
| Total Hit (3228) |
An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can run extended stored procedures from the Query Analyzer, for example, just as you would normal stored procedures. Ex
....Read More |
Rating
 |
|
|
|
SQL Server 2000 useful undocumented stored procedures
|
| Total Hit (3994) |
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
|
|
|
|
|
|
generate INSERT statements from existing data.
|
| Total Hit (3295) |
This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It's very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample d
....Read More |
| Rating
|
|
|
|
Find out the nth highest number in a column.
|
| Total Hit (2718) |
Ever wondered how to find out the second highest salary from the employees table? Or how to find out the third oldest employee in the company? Here is a stored procedure which accepts the table name, column name, and nth number and displays the nth highest number from the given column.
....Read More |
| Rating
|
|
|
|
|
|
|
|
How to search all columns of all tables in a database for a keyword?
|
| Total Hit (3600) |
While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns of all the tables in a given database for a specific keyword. I never took such posts seriously. But then recently, one of my network administrators was troubleshooting a pro
....Read More |
| Rating
|
|
|
|
Procedure to import SQL Server error log into a table (SQL 2000)
|
| Total Hit (3371) |
This procedure reads the SQL Server error log using sp_readerrorlog and imports the error log's contents into a specified table. It accepts three parameters:
@log_name is the name of the table into which the error log will be imported
@log_number is the error log number, 0 is default and refers
....Read More |
| Rating
|
|
|
|
Stored procedure to generate a simple or complex random password
|
| Total Hit (3150) |
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
|
|
|
|
|
|
|
|