lundi 2 mars 2015

run a script for all databases


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