There are some ideas around about using affinity mask (which is effectively what you do in EM) but I've never needed to change it. There is a lot of noise...

Note:

Restricting SQL to certain CPUs (by "affinity mask") does not affect the licensing required.

The CPUs must be not visible to the OS and unavailable for the OS: disabled in...

It may prompt you to shut down the other instance and SNMP etc...

depends on the OS and patch level...

SP3 is buggy, hence SP3a was released.

This problem is unrelated to whether it is SP3 or Sp3a

On one server you have "computed columns" and that is the issue, as per...

Joe Teck - yes, most of us can install SQL.

Personally, it's been 5 years since I used "autorun" on a CD to install any part of SQL.

In fact, used a...

The first post says 16Gb RAM.

And a different name of poster.

So, which server config question should I try and answer?

I guess you are not using 64 bit... just checking because AWE and /3GB have no meaning then...

So 32 bit.

I guess you're on Windows 2003 with 16GB RAM.

Question for all:

Does SQL...

So associate your rows on column "code". No need for triggers...

UPDATE Table SET DESCR  = (New Value) WHERE Code = (Unchanging Value)

Why DTS? Overkill for this.

It's a simple CSV to just parse each row commas

Just use BULK INSERT off an UNC path which solves any issues about ftp and file location, as...

As you have described it, your only link between rows is non key columns.

There is key field to identify the "child" rows linked to the "parent rows"

This breaks all manner...

INSERT (table) EXEC sp_who

Just need to work out your table DDL

Once in your table, query to group on dbname and count(*) etc...

A trigger for each operation.

Insert is quite straight forward

For update and delete, you'd need to extract the primary key for the modified/deleted row and use that to drill to your...

Full logs EVERYTHING as it happens.

Bulk-logged reduced logging for some operations such as bcp, CREATE INDEX, SELECT INTO (see BOL for full list) as theyhappen. Bulk operations are then fully recorded...

the contents of the text file usually let you know what is happening...

UK for "resume"

Latin: "Curriculum Vitae"