Thanks for the correction, Hugo. Moving too fast today.

Not sure why you would disable a clustered index then. Perhaps it was included to keep consistent syntax for all indexes? Seems...

It still isn't quite clear. The exact error and exact steps are needed, but you can debug this yourself as well.

run a trace on the 2000 server and watch what...

That makes more sense. I'm not familiar with terminal services licensing, but can you have 2 or 3 terminal servers under the same licensing? Is it by CAL or is...

ETL loads is one reason. It can be faster to load without indexes...

It's not quite clear what you mean, or what you did for access.

What did you do to grant access.

When you say he gets an error, do you mean he...

My apologies. I think I cut and pasted the drop in the wrong spot when this was proofed. It definitely ran correctly when it was tested.

I will award points back...

wolfkillj (6/14/2013)

You got close, Rod, and we'll give you a pass since you're not American.

Here's the lineup:

1st base: Who

2nd base: What

3rd base: I Don't Know

Left field: Why

Center field: Because

Pitcher:...

First, you probably should have someone else responsible for setting this up or working with you. Encryption is serious business and if you lose keys, you lose data. Microsoft...

There is a percent complete column, where you can get the progress. In terms of the rate, you'd have to just watch this and calculate something.

SELECT

db.name,

...

Do you have lots of free space in your databases?

In terms of the object, what's the way that it's structured? Is the row size significant compare to page size? Fill...

#1, why use tempdb? It's like you are trying to make this more complex first instead of getting it working.

Do it WITHOUT ANY PATH first. Get the backup working correctly.

Then...

Roll forward - transactions committed in the log, but not written to the data files are pushed there.

Roll back - uncommitted transactions are undone from the data file.

Visualizations are a great place to start, but not sure they're often good for decisions. Better to dig in further to the data itself and verify with the details. however...

You could use encryption in SQL Server 2008 to encrypt the data before it's exported to the file. however if you are attaching a file dropped on your file system,...

If your master key is not protected by the service master key, you need to open it. Since I don't know how you configured your encryption piece, you may need...