MSForEachDB - Create Stored Proc

[JayKusch]

Afternoon,

I need to figure out the syntax to create a stored procedure in every one of our database (all 1200+) which is part of a stored procedure execution logging process.

I have been trying to get MSForEachDB to work.

Any ideas on how to accomplish this task?

Thanks

Thanks

J. Kusch

 

[markros]

See sample at

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/truncate-log-in-all-your-user-databases

 

[JayKusch]

I figured it out use the ole nasty 'cursor' - lol

Thanks!

Thanks

J. Kusch