smo Archives - DbaFix

Are cursors/While loops the only way to make administrative changes to multiple databases?

By adminPosted on August 24, 2022

Question : I specifically want a programmable way to change the recovery model of all the databases on a server, […]

By adminPosted on August 5, 2022

Question : Archiving to avoid ID Exhaustion We are about to run out of IDs in one of the tables […]

By adminPosted on August 2, 2022

Question : I got strange delays when backed up a group of databases (20 more) in one scope (TSQL) to […]

By adminPosted on April 29, 2022

Question : Background At my current organization, we’ve got a SQL Agent Job running a Powershell script, originally based on […]

By adminPosted on February 27, 2022

Question : I think I just found the coolest thing every with SQL Server SMO and PowerShell. I was asked […]

By adminPosted on September 11, 2021

Question : Query Store can be enabled on the model database and ensures that every new database has the same […]

By adminPosted on July 11, 2021

Question : I want to be able to script the schema of a given database into a .sql file from […]

By adminPosted on November 10, 2020

Question : I need to implement the following requirement. I have setup a remote sql server express, certain users shall […]

By adminPosted on October 4, 2020

Question : Running SQL Server Express 2005 here. We are creating several programs which run a backup on the database […]

By adminPosted on June 9, 2020

Question : I have c# SMO script which copy all database objects to existed empty database or to a new […]