Yes, I think that is smart solution.

But I already altered all SPs and Views :-).

I'll do that, if I have same problem like this.

Thanks

Thank you it works..

but the problem is..

I have a function (other function, not CalculateNumber) that have been used in many View and SP,

then I need to add a new...

Thank you... it works..

but when I execute

:connect MyServer

use MyDB

sp_help customer

go

OR

:connect MyServer

use MyDB

sp_helptext spGetCustomer

go

notes:

customer is a table

spGetCustomer is an SP

I've error like this

Connecting to MyServer...

Msg 102, Level 15, State...

Hi..

You can use sp_tracexxx

There's an article about this SPs

"Using SQL Trace to Audit Database Access"[/url]

Or

Auditing Store Procedure Execution

for eventID, EventName and Description : please see SQL Server Books Online, search...

sorry ... should be

select top 10 s2.text ,s4.* --login_name,nt_user_name,nt_domain,program_name,host_name

FROM sys.dm_exec_query_stats AS s1

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2

JOIN sys.dm_exec_requests as s3 ON s1.sql_handle = s1.sql_handle

JOIN sys.dm_exec_sessions as s4...

Hi... here is query to track who & when sp is executed

SELECT distinct so.name, s2.text

FROM sys.dm_exec_query_stats AS s1

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2

left join sys.objects so on s2.objectid =...

Sorry...

I missed the 'trigger' word 🙂

I re-write my post :

Hello..

I have restore problem.

In my production server there's a DB that have DDL Trigger

This DDL insert to another DB on linkedserver.

I...

ah.. ok.. thanks

Thanks... it works..

My purpose is.. I want to create a table from the record returned by SP. The SP is containing dynamic SQL, so it execute different SQL depends on the parameter.

example:

exec SPExecSQL...