Miscellaneous

Technical Article

Find strings in a stored procedure

  • Script

Really simple... it returns a list of stored procedure names that contain the passed in string. Useful for finding all stored procedures that call another specified stored procedure. Call with the following command: exec usp_functions_findinUSP @str='sp_lastmodified'

3.5 (2)

You rated this post out of 5. Change rating

2001-10-08

2,201 reads

Technical Article

Script to Attach Multiple MDF

  • Script

Copies mdf files located in a directory on a client and attaches them to the connected server. This is the winning solution to the contest that was presented in an article posted at http://www.sqlservercentral.com/columnists/awarren/reattachingdatabases-somecodeandacontest!.asp. That article shows how to do the same thing using DMO. Wynn Muse is the author of this stored procedure.

You rated this post out of 5. Change rating

2001-09-23

3,580 reads

Technical Article

Automatic Backups

  • Script

Creates the backup devices where sql server is installed, creates an error message above 50001, an alert, and an adittional job in case the scripts fails. In the first time backups all databases and then backups the logs until two days past from the last full backup. Then backups the databases again and so on. […]

2 (1)

You rated this post out of 5. Change rating

2001-09-07

1,238 reads

External Article

SQL Server 2000 User-Defined Functions White Paper

  • Article

The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL.

2001-08-31

2,233 reads

Blogs

Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition

By

In my previous post, I showed you how to build a snapshot backup catalog...

Advice I Like: Training Employees

By

Train employees well enough that they could get another job but treat them well...

Creating a Striped Backup Set with AI

By

I needed to test a striped backup, so I decided to ask the AI’s...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Docker Advice for SQL Server in Production

By Vincent92

Comments posted to this topic are about the item Docker Advice for SQL Server...

DevOps is DevOps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DevOps is DevOps

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers