Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag SQL Server 7 Rss

Search for any content tagged sql server 7

<< Newer    Items 41 to 60 of 941    Older >>

Altering a column on a Replicated Table

SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.   Read more...
By Paul Ibison 2007/11/30 (first published: 2005/01/19) | Source: | Category: replication
Rating: |  Discuss |   Briefcase | 35,412 reads

Monitoring on a Budget

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this  Read more...
By Bert Carles 2007/11/19 | Source: | Category: monitoring
Rating: |  Discuss |   Briefcase | 9,088 reads

SQL Server Job Scheduling

The scheduling system in SQL Server is quite flexible and powerful, but can be confusing at times. Peter He looks at some of the advanced options you have in automating the various jobs on your server.   Read more...
By Peter He 2007/11/16 (first published: 2006/03/08) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 37,859 reads

Reverse Engineering Alias Data Types in SQL Server 2000 - Part IV

In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).  Read more...
By Yakov Shlafman 2007/11/01 | Source: | Category: sql server 7
Rating: |  Discuss |   Briefcase | 1,625 reads

Migrating SQL Server 2000 DTS Packages Across Environments

Many of us still have SQL Server 2000 DTS packages running throughout our environment. New author Owais Bashir Ahmed brings us an interesting technique for moving those packages between servers that might come in handy as you continue to work on these packages in SQL Server 2000.  Read more...
By Owais Bashir Ahmed 2007/10/09 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 6,112 reads

Replication Statement Delivery Options - Part 1

Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean.   Read more...
By Andy Warren 2007/09/24 | Source: | Category: replication
Rating: |  Discuss |   Briefcase | 4,118 reads

Changing Service Credentials

One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.   Read more...
By Additional Articles 2007/09/21 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,315 reads

Monitoring Disk Space and Sending Alerts with TSQL

Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring!   Read more...
By Haidong Ji 2007/09/14 (first published: 2003/08/13) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 50,982 reads

Capturing Missing Information From SQL Profiler

While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need.   Read more...
By Solomon Rutzky 2007/09/06 | Source: | Category: monitoring
Rating: |  Discuss |   Briefcase | 9,459 reads

Removing the Builtin Administrators - Some Pitfalls to Avoid

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.   Read more...
By Kathi Kellenberger 2007/08/10 (first published: 2005/01/12) | Source: | Category: security
Rating: |  Discuss |   Briefcase | 29,482 reads

Server Farm Reporting - Part 2

Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.   Read more...
By Mark Tierney 2007/08/06 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 2,798 reads

Using Non-Standard Port for SQL Server

Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.   Read more...
By Additional Articles 2007/08/03 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 2,980 reads

Beginning SQL Server - Logins and Users

Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security.   Read more...
By Steve Jones 2007/08/03 (first published: 2004/09/02) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 41,103 reads

Bookmark Lookups

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.   Read more...
By Randy Dyess 2008/07/18 (first published: 2005/05/30) | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 37,157 reads

SQL Server Security: Pros and Cons of Application Roles

Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.   Read more...
By Brian Kelley 2008/07/25 (first published: 2003/08/27) | Source: | Category: security
Rating: |  Discuss |   Briefcase | 39,995 reads

Pop Rivett and the Expanding Log

When your database transaction log is out of control, there is only one man who can tame it.   Read more...
By Additional Articles 2007/07/06 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,475 reads

Updating AS/400 Linked Server Tables from SQL Server

One of the strongest features of SQL Server is the ability to connect to disparate data sources and perform queries across multiple sources. New author Basu Hullur brings us a technique that he used to update data on the AS/400 in a much quicker way than previously.   Read more...
By Basu Hullur 2007/07/06 (first published: 2006/04/05) | Source: | Category: distributed queries
Rating: |  Discuss |   Briefcase | 42,561 reads

Maintain DTS packages in SQL Server 2005

Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.  Read more...
By Additional Articles 2007/07/05 | Source: SearchSQLServer | Category: dts
Rating:  Rate this |   Briefcase | 4,492 reads

SQL Server 2000 SP3a Support is Ending

Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.   Read more...
By Press Release 2007/07/05 | Source: | Category: news
Rating: |  Discuss |   Briefcase | 3,193 reads

SQL 2000 DBA Toolkit Part 1

SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys.   Read more...
By Michael Coles 2007/06/22 (first published: 2006/04/13) | Source: | Category: security
Rating: |  Discuss |   Briefcase | 30,346 reads
<< Newer    Items 41 to 60 of 941    Older >>