I need help what statement or function i can use to run a query in all database using one script , i want to run the below script at the same time to retrieve output in all databases
select
@@SERVERNAME as ServerName,
DB_NAME() as DatabaseName,
Object_ID = (id),
OBJECT_NAME (id) as StoreProc,
Text
from syscomments
where text like '%Janice\SQL%DTS%'.
Aucun commentaire:
Enregistrer un commentaire