Miscellaneous

Technical Article

Script to obtain datadictionary from a SQL2000 db

  • Script

This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]

You rated this post out of 5. Change rating

2001-08-27

3,119 reads

Technical Article

Script to Search SQL Error Log For a String

  • Script

This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III

4 (1)

You rated this post out of 5. Change rating

2001-08-13

1,921 reads

SQLServerCentral Article

Using Cursor Metadata to Dynamically Generate HTML Tables

  • Article

The following stored procedure will demonstrate the use of cursor metadata. Using cursor metadata we can get information about an SQL statement and use that information to dynamically generate other code such as HTML or other stored procedures.

5 (1)

You rated this post out of 5. Change rating

2001-07-27

5,229 reads

Blogs

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...

Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)

By

Update for SQL Server 2025: This post and the GitHub repo have been updated for...

Read the latest Blogs

Forums

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...

Choosing an AI in Sept 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Choosing an AI in Sept...

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