Sounds strange if this started happening if you just moved your SQL Server.

It sounds like a common system table blocking problem. Like there was some permanent Exclusive lock on one...

And:

--------------------------------------------------------------------------------------------------------

-- CREATE TEMPORARY TABLE TO STORE INFORMATION ABOUT FILES

--------------------------------------------------------------------------------------------------------

Create table #FileInfo

(

 AltName NVARCHAR(20)       -- Alternative name

,FileSize NVARCHAR(11)      -- Size of file (bytes)

,CrDate NVARCHAR(8)         -- File creation date (YYYYMMDD)

,CrTime NVARCHAR(6)         --...

...which means you either manually have to save a trace table every time you want the stats, schedule a trace to run for a certain time period per day and...

How did it actually go with the 'review board'? Did it ever start and if it did, are they awake when they read through these questions?

What do you mean by: If your server crashed and you need to recover uncommited transactions to a point in time (roll forward), you won't be able to.  This is...

Sounds great!

I hope it works. Please let me know if there are any problems.

//Hans

Hmm. Are your jobs so great otherwise that you havn't thought of changing them?

There are lots of SQL DBA positions to be filled where you do not have to deal...

I recommend you to dig into the partitioning in SQL Server 2000 directly!

Short Flow:

Determine HOW you want it partitioned. Let's just talk horizontal partitioning now.

Say you have something like a...

But if you want to move your data from C to E with no DB downtime, you do as mise13 says. With the...

Partitioning is good in SQL Server.

You follow the rules for PARTITIONED VIEWS in BOL and after a bit of playing around with them you will notice that probably it's...

...or why not setup a service that executes different actions when files are created/modified/deleted?

It is enough to be Admin of the computer. I.e you can connect the share in any valid way. Ex: Net Use with valid credentials...

Those are by far the most...

Well. I guess if you are admin on all client machines you could easily write a WMI script that run a SILENT install on every client machine. But I guess...

Could it be that you have locks in your system? That your DTS can't execute because it is waiting on locks to be released from important objects?

Nice display Adam Machanic