问题描述
我有一个会改变的链接服务器.一些过程像这样调用链接服务器:[10.10.100.50].dbo.SPROCEDURE_EXAMPLE.我们有触发器也在做这种工作.我们需要找到所有使用[10.10.100.50]的地方来改变它.
I have a linkedserver that will change. Some procedures call the linked server like this: [10.10.100.50].dbo.SPROCEDURE_EXAMPLE. We have triggers also doing this kind of work. We need to find all places that uses [10.10.100.50] to change it.
在 SQL Server Management Studio Express 中，我没有在 Visual Studio 中找到在整个数据库中查找"这样的功能.特殊的 sys-select 能帮我找到我需要的吗?
In SQL Server Management Studio Express, I didn't find a feature like "find in whole database" in Visual Studio. Can a special sys-select help me find what I need?
推荐答案
这里是我在系统上用来查找文本的过程的一部分....
here is a portion of a procedure I use on my system to find text....
DECLARE @Search varchar(255)
SET @Search='[10.10.100.50]'
SELECT DISTINCT
o.name AS Object_Name,o.type_desc
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id=o.object_id
WHERE m.definition Like '%'+@Search+'%'
ORDER BY 2,1
这篇关于如何在 SQL Server 程序/触发器中查找文本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！