Technical Article

Script to find text in stored procedures

This is a simple script that when used by command-line OSQL/ISQL can help you locate a stored procedure.How many times have you been looking for stored procedure code and could not find it?  This is a simple method to locate lost code.When you manage many database servers this can become a common problem.  The scenario […]

5 (2)

You rated this post out of 5. Change rating

2007-09-14

2,055 reads

Blogs

A New Word: Immerensis

By

immerensis – n.  the maddening inability to understand the reasons why someone loves you...

Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault

By

In this post, I will guide you on how to deploy a dockerized simple...

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

Read the latest Blogs

Forums

is it cache or something else

By stan

hi a few days ago i narrowed down the cause of a new problem...

SQL Server - Log file not getting smaller on Log backup

By matt019

I have a database that is in full backup recovery model. When the log...

Edition features

By mtz676

SELECT * FROM sys.dm_db_persisted_sku_features If the result set has no records is it conclusive...

Visit the forum

Question of the Day

SQL Server Collations

At what levels can we set the collation in SQL Server 2022?

See possible answers