Technical Article

Where_Am_I

This SP takes a string to be searched as input parameter, loops through all tables, views, Sp-s in the database andreturns the name of the object it was found and number of occurences

5 (1)

2004-12-10 (first published: )

646 reads

Blogs

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Read the latest Blogs

Forums

Failed to build the OLAP cubes

By ramana3327

Hi, We installed default standalone SSAS in tabulator mode (SQL 2017 license). When they...

Exporting the Database Encryption Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Exporting the Database Encryption Key

SQL Duplicate remove Query

By rocky_498

Hi Guys, I want to remove duplicates from the table. The duplicate is a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers