2^127 is a really big number. What are you counting that you would ever need that many distinct...

I haven't done this for a while, but I think 1) disable the Agent/Job and then 2) Stop the agent if it is currently running.

The schedule(s) should not be able...

Depending on your budget, there are many consulting companies that will do guide you through this or do it for you (yes, mine is one of those).

Read the "Data Warehouse Toolkit" by Kimball and Ross. It should give you a much better idea where to start and what kind of questions to start asking your...

Have you tried deleting from each of the individual child tables first? How fast did that run?

The activity monitor in SSMS can help, but since it doesn't have deltas, you may find it difficult to use for this purpose.

Something to get you started:

CREATE Procedure spHugeTable_IncrementalUpdate( @RowsPerBatch int )

AS

Update HugeTable

Top (@RowsPerBatch)

Set {columns to change, ...}

, UpdateCol = 1

Where UpdateCol=0

Now write a SQL Job that...

I feel obliged, for the sake of accuracy, to point out that although your co-workers steps for adding a column to a table bear an eerie similarity to the scripts...

GSquared (3/27/2008)

---

Joe creates an order in the Orders table: CreateBy = "Joe"

Bob updates the order and changes the price incorrectly: UpdateBy = "Bob"

Sue updates the order and changes the ship...

Unless you want to rebuild/reload all replication data on the subscriber, you will have to store the change information somewhere. You can stop the distribution agents and then the...

There are some limited modifications that you can make to the table definitions through the Replication Management interfaces (GUI & sys Procs), however, for the most part you will have...

Try following the instructions in the error message?

Michael's solution also works for me on both Sql2000 & 2005:

SELECT TOP 1 *, Cast('' as VARCHAR(48)) as [schemaname]

INTO #sysobjects

FROM [dbo].[sysobjects]

DELETE FROM #sysobjects

INSERT INTO #sysobjects

EXEC('USE [master] SELECT *,...

You could just use the veiw defined in this article and do a SELECT on it WHERE NAME={your table name}, : http://www.sqlservercentral.com/scripts/tables/62545/

SW_Lindsay (3/26/2008)

---

No, it's dymanic SQL. I am getting the database file information from a given database.

SELECT FI.[filename] FROM master..sysaltfiles FI Inner Join Master..sysdatabases DB On FI.dbid = DB.dbid...