This article by Andy warren shows you how to get started with DMO using either VB or VBScript. The article includes sample code that will backup all databases on a server and will update the statistics on all databases as well.
2007-10-02 (first published: 2003-08-15)
39,141 reads
2007-10-02 (first published: 2002-06-20)
15,465 reads
This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5
2007-10-02 (first published: 2001-05-01)
10,939 reads
We're pleased to announce that Robert will be writing for us each month - generally on stored procedures, but occasionally on a different topic. This article discusses how nesting stored procedures works and how to use @@NextLevel. Good reading! If there is a stored procedure topic you'd like to see covered, add a comment to the article or email us at articles@sqlservercentral.com
2007-10-02 (first published: 2003-05-23)
53,627 reads
One of the seeminly more popular enhancements in SQL Server 2005 to T-SQL is the PIVOT operator. There have been quite a few articles, but new author Peter Larsson decomposes in detail how you can perform this operation with previous versions.
2007-10-02 (first published: 2006-06-12)
76,042 reads
Query Analyzer is a great tool for developing SQL code. There are a number of little tricks that can greatly increase the amount of work you can do with very little effort. This article starts looking at some of the features of this tool.
2007-10-02 (first published: 2003-01-07)
70,321 reads
It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. Raj Vasant brings us a look at some of the information that you can get by directly querying the system tables and explains what is stored in a number of them, including gathering information about computed columns.
2007-10-02 (first published: 2005-06-13)
39,765 reads
SQL Server 2000 Reporting Services is becoming a more and more popular reporting option everyday. However, the disaster recovery plan for this add on is not a simple backup and restore since there are multiple pieces and servers usually involved. However the DBA may be responsible for the entire system. Mike Pearson brings us a look at some of the scenarios that you need to consider and what you might need to prepare for disaster recovery of SQL Server 2000 Reporting Services.
2007-10-02 (first published: 2005-01-06)
29,313 reads
Steve Jones has been working with SQL Server for 10 years. Join him for a stroll down memory lane.
2007-10-02 (first published: 2002-05-23)
5,786 reads
The SQL Server 2000 security model is not the best one of all the RDBMS platforms and requires some work to secure properly. One of the practices that is recommended is removing the builtin/administrators group from accessing the SQL Server. New author Kathi Kellenberger shows us some of the pitfalls she encountered when removing this group from her servers.
2007-10-02 (first published: 2005-01-12)
30,118 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Still Wins
Comments posted to this topic are about the item DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers