Also note there are lots of scripts on this site that people have shared to do this: http://www.sqlservercentral.com/search/?q=copy+backup+files&t=s&sort=relevance

Please post new questions in a new thread in the future.

In this case, you would have to perform some more debugging. One common cause is that the account running xp_cmdshell...

I hate in place upgrades. They are asking for problems if there is an issue, and that could happen. If you must, then you need to go to sP2.

I much...

Not as much fun though. Plus, Grant maybe learned from me. He doesn't drive enough to make it worthwhile.

Congrats, Ray. You win.

I'll sort prizes this week. I'm thinking

1st - $100

2nd - $50

3rd - $200

Sound good?

Apologies for the delay. I agree the wording was sloppy and misleading. The parens are not required, and I've noted that in the answers.

Points awarded back

1. Yes, you need git installed. You can install any version. I've used TFS Git, but installed from the open source git repo[/url].

2. Any path will work. This just needs...

Well, for me, it was just getting away. Family vacation in Ireland for a week, walking, renting a car, enjoying another country with little computer time. My wife and I...

Good advice above. I would recommend either Ola's scripts or the Minion scripts[/url].

That's weird. Haven't seen that. But I haven't gotten dev from the main site before, so maybe it's hooked into a sales workflow of some sort.

They are different versions as...

David.Poole (12/20/2016)

---

There are so many dimensions to "realistic" test data not least that data has natural hot spots. It's difficult to come up with test data that truly simulate...

Fried, but from being overseas for two weeks.

Got back last night, get the lineup set and things look good. If only Mr Rodgers, Mr. Ajayi, and Mr. Crabtree had shown...

Note that the primary key is unique to all records, so you can't say that the ID is the primary key.

You can say that the ID + UserID (or name)...

Weird. I'd think that you should be able. No matter what the spacing of the objects in the file.

Maybe try a reindex that might move things around and then...

Eirikur has good advice. You want to reindex, but when stats might get out of date, or fragmentation gets high. Ola's scripts, or the Minion scripts[/url], can help you here.