I'm assuming you don't want the user to be a member of ddl_admin?

Have you tried dropping the index and recreating it?

We use a 3rd party tool called Remedy.

We use this when we get requests from the business, developers etc as well as the 1st line support team who log calls...

Agree with the above comments.

Also, sit down with the business sponsers and discuss the data that needs to be migrated.  Define the data in Excel so you can then build...

Is the UserID column supposed to be unique?

You mention that the odds of it happening are phenomanal, but the possibility is always there unless the column is defined as unique.

It...

I'd follow John's advice.

However, for reference, job information will be stored in the msdb database.

Real tough situation when you feel the director or upper management is on terms with your manager.  Fortunately, I've never been in such an environment.

However, I have presented solutions to...

Or, if you prefer to do it from Enterprise Manager, you can run the Maintenance Plan wizard.

Is the schedule enabled?  If you look at the properties and go the the schedule tab, is the enabled box checked?  That's caught me out before.

I would also ask as to why you would want to generate a script on a daily basis?

I must admit I have not done any sql development for quite a...

Take the comment back about buffer cache hit ratio and memory.....I'm reading things that don't exist in your posting!

The Cache Hit Ratio counter indicates how often cached queries are being...

How do the performance counters stack up to the new server?  Do the disks show signs of increased performance?

Buffer cache hit ratio of 61% for a prolonged period would show...

I'd not create more filegroups than necessary.  I'd create enough to logically group the associated tables and that would be it.

As for the number of files, I was at Microsoft...

Is the database definately read-only?

Is there any maintenance, such as reindexing, defragging?

Any bulk inserts?

Also, monitor the physical size of the data & log files and also the percentage used through...

Your using index tuning wizard on SQL2000.  All I can say is your brave!

Personally I wouldn't touch it...As your new to SQL Server,...