Manage Multiple SQL Server Installations and Databases with OSQL
This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers.
2002-10-24
9,852 reads
This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers.
2002-10-24
9,852 reads
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Jayram Tallamraju
2002-10-23
7 reads
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,153 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,743 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,807 reads
The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.
2002-08-07
3,823 reads
In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.
2007-11-01 (first published: 2002-08-01)
38,743 reads
Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.
2012-12-14 (first published: 2002-07-31)
10,531 reads
In a follow up article to Rahul's article on 'Copying Databases from Server to Server' Andy looks at another option, the Copy Database Wizard introduced in SQL 2000. Easy to use, but like most wizards it has a couple gotchas you need to know about. Good article for beginners and pro's alike!
2002-07-18
11,101 reads
The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.
2002-07-08
5,883 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers