Using DMO to Execute a Job
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
2001-05-22
5,305 reads
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
2001-05-22
5,305 reads
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,693 reads
Replicating continuously minimizes latency, but at a cost. If you're replicated a lot of databases, read this article for some ideas about how to trade latency for overhead by runnig your agents in non-continous mode.
2001-05-15
4,712 reads
This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.
2001-05-11
4,363 reads
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
2001-05-10
18,027 reads
Need to make changes to table that is an article in a publication? Read this article to get step by step instructions on how to do it without doing a new snapshot!
2001-05-02
8,109 reads
Confused about the difference between using a DSN or DSN-less connection? This article by Andy warren explains the differences and offers some insight into when each is appropriate.
2001-05-02
5,548 reads
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
2001-04-30
9,416 reads
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
2001-04-23
8,278 reads
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Hi, I need to design a data warehouse solution to manage medical records about...
Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...
Gurus, there is a table which is very slow to query , it has...