There are a lot of scripts out there that will allow you to use the msdb to auto-generate restore scripts, but what if you cannot access the msdb database. What is the easiest way to make sure I have the proper restore scripts on hand without relying on the msdb database?
2008-11-07
3,562 reads
In this whitepaper, you will see the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. You will also see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.
2008-11-07
5,110 reads
Yakov Shlafman brings back the world of the command prompt to make life easier for a DBA that must deploy a series of scripts to their servers.
2008-11-06
12,880 reads
Integration Services is a great system for performing ETL operations between databases. In this video we show how you can use Data Viewers to determine if you are correctly transforming data.
2008-11-06
2,068 reads
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
2008-11-06
776 reads
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
2008-11-06
574 reads
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
2008-11-06
539 reads
Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.
2008-11-06
4,328 reads
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set.
2008-11-06
2,392 reads
Exporting data from your database and building reports is easy with Reporting Services, but sometimes you need to use other sources
2008-11-05
18,165 reads
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
Comments posted to this topic are about the item Local Agents
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers