Can someone please walk me through the steps, or provide a link, to open a maintenance package that was created by the wizard in SMS using SSIS? I do not see how...

Started, Paused, and continued from the command line. Does anyone audit these questions before they are released.

Terry

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\tduffy>net start mssqlserver

The...

Agreed you should check for users first and then deal with them. You may be able to catch the error by evaluating @@error, but some things can not be caught

Terry

Query master.sys.procedures and examine the is_auto_executed (bit) value.

Terry

Reports relies on the new DMVs in 2005 and will not work with 2000

Terry

Actually, the save transaction syntax uses a savepoint name, NOT, the transaction name.

Syntax

SAVE TRAN [ SACTION ] { savepoint_name | @savepoint_variable }

Arguments

savepoint_name

Is the name assigned to the savepoint. Savepoint...

Nice article Steve.

If you mean SQL-DMO then try here for the object model.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con01_85f7.asp

Object model for DSO is at

http://msdn2.microsoft.com/en-us/library/ms134733.aspx

C or B should be considered correct. By setting the batch size to 1 (B) you are setting the transform to commit after each row(C).

Both interpretations rely on the transform...

If a dirty read on the select query is OK, open all the tables with nolock,or set the tranaction isolation level to read uncommitted. This will allow your updates to...

Use SQL native backup to disk, then use Veritas BackUpExec to tape. You should have no problems.

One thing though, you may want to consider some encrytpion of the files. Last time...

Database names, and names in most (all?) system tables are stored as the sysname datatype.

From BOL:sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and...

The code may have anticipated a rowcount returned first, moving to the second result set. Now that you removed the count, it is failing?

It's a guess, but I've seen this...

It has been a while, but the dbase driver in dts worked on older foxpro imports.

Terry

Depending on what you are doing, using linked servers can pose some significant perfomance challenges and licensing concerns. Do your homework. Also, consider replication as another alternaive.