Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.
2002-09-19
12,176 reads
Do you get tired of reviewing each SQL Agent notifications nightly to determine which SQL Agent jobs failed? Is there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.
2002-09-17
11,735 reads
Having trouble with a target server (TSX)? Steve Jones did in his environment. Read about how he worked around the issue to restore administrative capabilities.
2002-09-16
7,238 reads
This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourself, if you want to be a point-and-click DBA or a T-SQL scripting expert!
2002-09-04
781 reads
Part 4 examines more ANSI options that are available in SQL Server. A simple setting with some unexpected (for the author) results.
2002-09-03
4,756 reads
In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.
2002-08-19
6,819 reads
This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
2002-08-15
14,195 reads
When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.
2007-10-02 (first published: 2002-08-14)
24,686 reads
Bill Wunder has done it again with his newest release of his DDL Archive Utility, which can pull entire schemas into Source Safe automatically.
2002-08-13
203 reads
Recently Steve Jones noticed that someone wanted to use a UDF to enforce uniqueness. No big deal, right? Well this person wanted to enforce uniqueness based on some other column value. A bit of a challenge, but this article presents a couple ways to handle this.
2002-08-12
4,265 reads
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Slip Streaming Installs
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
What does a slipstream installation mean?
See possible answers