Miscellaneous

Technical Article

Procedure Search by Keyword(s)

  • Script

Searches SysComments for occurances of entered keywords and returns a list of procedures that contain the keywords. eg1) To find all procedures with 'nMyColumn' in EXEC utl_ProcSearch 'nMyColumn' eg2) To find all procedures with 'nMyColumn' in and 'nMyColumn2' in EXEC utl_ProcSearch 'nMyColumn', 'nMyColumn2' eg3) To find all procedures with temporary tables in... EXEC utl_ProcSearch '#' […]

You rated this post out of 5. Change rating

2002-02-04

206 reads

Technical Article

Auditing Solution - Generate Triggers automatically

  • Script

The procedure looks at the table you want to be audited and writes the INS, UPD, and DEL triggers automatically required for the auditing to work. The auditing requires a table called Progress to hold the audit information in so have provided the DDL for this as well. Typically you would write a cursor to […]

You rated this post out of 5. Change rating

2002-02-04

485 reads

Technical Article

Stored procedure to expose information for a file

  • Script

I wanted to be able to use info about an operating system file in TSQL. So I wrote this stored procedure that uses the special stored procedures xp_fileexist and xp_getfiledetails. This can tell if a file or folder exists, and if it is a file what is its size, created date and time, last written […]

You rated this post out of 5. Change rating

2002-02-01

1,260 reads

Technical Article

Get list of files from dir and put in table

  • Script

This stored procedure reads the file names from a directory and stores just the names in a given table. It returns also the number of files present. The sp uses xp_cmdshell and so permissions are restricted to sysadmins and SQLAgentCmdExec. You can test with the following: Create Table ##tmp2 ( fldx nvarchar(255) ) Declare @FilePath […]

1 (1)

You rated this post out of 5. Change rating

2002-02-01

1,970 reads

External Article

BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server

  • Article

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.

2002-01-28

1,740 reads

Blogs

Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab

By

Are you diversifying your DBA skillset? My recent job search made one thing clear:...

Back in the EU

By

I flew to Amsterdam last night and hopefully by the time this publishes I’ll...

The Feedback Multiplier: How Leaders Can Turn Input into Innovation

By

In every organization there is a hidden currency more valuable than capital, more enduring...

Read the latest Blogs

Forums

RESTORE DATABASE command internal timeout

By MikeDBA

I have run into a very strange issue restoring a large, partitioned database. I...

how to use a variable in a CASE statement?

By water490

hi everyone I am getting an error when I add a variable to a...

How to Use SQL Server Features to Cut Web App Latency in Half

By Muhammad Adnan

Comments posted to this topic are about the item How to Use SQL Server...

Visit the forum

Question of the Day

The New SQL Server 2025 Data type

In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?

See possible answers