What account is running your SQL Server? Is it local system, local service, network service or a domain user?

Getting an access denied error tells us that SQL Server does...

You are going to have to identify what you mean when you say it doesn't work. The query is fine written the way you have it, however - running...

This is telling you that the account running SQL Server does not have access to the drive and/or folder. It is a permissions issue and once you correct the...

Yes, you continue and it will only uninstall the instance and components that you have selected.

Take a look at using SQLCMD mode instead - where you can then use a variable for the database name. You can review this article to see how you...

Yes - I missed that...sorry, you do need a column that is going to be unique to build the indexed view.

There is nothing that states that a clustered index must be a primary key or unique. You can create your clustered index on whatever columns you need.

I am not aware of any native tools that will allow you to do that. However, check out: http://www.hyperbac.com/ which does allow you to do what you are looking...

If you have a system that is only accessed during business hours, say from 7am...

Looking at your plan, I don't see that you are checking for the level of fragmentation on your indexes. If you are not doing that, then you are reorganizing...

In addition to what Steve has stated, why do those databases need to stay on the 2000 instance? Can you move them to 2008 and leave them in 80...

What kind of values exist in the DataValue column and what is the actual data type for that column? Why are you trying to convert/cast that value to a...

I would add SLA's to the list of items to consider.

If you have systems that are generally only needed/used during business hours, you really don't want to comingle them with...

Michael Valentine Jones (2/11/2010)[h]I was aware of that potential problem, and that is why I used the REPLACE to remove the - characters from the date to change it to...

On the query I provided, did you change the table reference back to your original table? I modified it to use a temp table instead. Here is the...