Execute SQL-DMO Database method on all databases

This script allows you to specify a method and a server (or multiple servers.) It will then execute the method on every database on the server. With very minor tweaking you could have it search for the servers, then call the server db script with each one, or add another nesting to call tables or […]

2005-04-27 (first published: )

689 reads

Blogs

Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?

By

I have held various certifications through my DBA career, from CompTIA A+ certification back...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

Read the latest Blogs

Forums

Set Variable to lookup first row value with white space in property name

By jdlayton83

Hi, How can I set the value of a variable from a Lookup activity...

How to aggregate Dimension values properly

By ktflash

Ahoi, im trying to deal with a user request to combine 2 values of...

questions about sys.sysprocesses/sys.dm_exec_sessions and sys.dm_exec_requests

By 892717952

I have some questions   about sys.sysprocesses/sys.dm_exec_sessions and sys.dm_exec_requests, please kindly give your guidance and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers