A Simple way to find the line of script.

You can use this procedure to find any word or sentance, which u used in procedures, views, triggers and function. This procedure is basically a modified form of system procedure "sp_helptext". Now its upto you to use that and modified that. To execute the procedure, first create it in your Database and then execute it […]

2003-02-24

102 reads

Blogs

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Azure SQL - Handling JSON column in the table

By mohankumar.trs

Hi I want to convert table content which contain the json values in the...

ALTER DATABASE Issue

By genadyd

Hello, I faced  very strange issue. When I try from management studio to put...

Simple query question

By Mysterio

I'm new to SQL and I'm struggling to return a result set which I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers