Steve is talking about the MSX administration in SQL 2000.  It works very well for centralizing your maintenance plans and all Job Agent functions.  On a test server, just Right-click...

Normalizing the table is most likely the appropriate choice for your situation.  As indicated, you can then create a view, scalar function, or custom aggregate function to put the data back...

In the where clase you have scalar functions like nullif(b.samplename,'') is not null and also in your joins with the isnull(c.sectionid,0) = isnull(f.sectionid,0).  These force table scans because SQL has...

I have a Vaio UX that I bought when they first came out.  I came with XP and the "Vista Capable" sticker, so I figured I was in goos shape...

Although John's approach will work, I would probably try to avoid using the sp_OACreate procedure and instantiating file system objects in a procedure.  This is a SQL2000 way of solving...

If you take the SQL within the conditional statements and put them into sub-stored procedures being called by the main procedure, they will get individual cached execution plans.

You have a lot of opinions coming at you, but I will add another one anyway.

I would avoid calling an SSIS package directly through the CLR.  It is correct that...

I have used transactional replication pretty extensively and have had very few instances of any data loss.  I have most often found problems in the way replication was configured.

To get around that, you are probably going to have to use a script component.  With a script component, you can get all of the records into a recordset in...

Be careful of your terms.  A database snapshot and a snapshot replication, and a mirror are all specific terms and your post is a bit confusing because of this.  I...

"Text" and "Image" data types do not act the same as other data types.  They are stored quite differently, you cannt use them in a group by, they do not appear...

There are a lot of ways to do this, but using a lookup is what you were already thinking, so let's go with that.

Create your lookup as you would normall...

Ok, I'll take a stab at this.  Log into the server with the credentials your job agent is running under and try to execute the package without the job agent. ...

Ok, I actually have deployed the report builder in two different production environments.

First, after the first experience, I was willing to do it again.  It was not horrible.  The first...

It's interesting that you assume that another server is a fixed, one-time cost.  This is clearly not the case.  Assuming a new server is $5k (where are you getting this...