Dugi is correct - it is best practice to grant least privileges - though I rarely manipulate permissions per user. It usually makes more sense to grant to a...

msarikas (6/2/2010)

---

The screen didnt let me add the xml column to the include part of the nonclustered index.

So I scripted it out then added it manually, this created the index.

Is...

If you mean you created a PRIMARY XML index, then yes, you still get a...

Fillet-o-Smurf

Lamp-spanner

Certainly looks that...

Please post the full INSERT statement that prompts the error, and the CREATE TABLE statements for the tables involved.

There have been a number of bugs around linked servers, many of...

Hey Oleg,

Log files are initialised with zeroes...

You could see it as the perfect dead-pan response 😉

I don't think that's the case here since 'The Leader' long since made my blacklist...

luissantos (6/2/2010)

---

I build my script simplifying the data for testing, but in my table ML my primary key is MLSTAMP and the field DOSTAMP is the primary key of the...

I'm intrigued to see how you have Chinese characters in a non-Unicode source file.

Could you provide a small sample file for us to experiment with?

Just a few rows and the...

Well I've read that a couple of times now, and I'm still not *absolutely sure* if a DR mirror server requires a server licence or not.

I can quite see that...

There seems to be a rash of questioners that absolutely refuse to provide anything like enough detail to give a half-decent answer.

Honestly, it's like pulling teeth on some active threads...

Very good, and I broadly agree with what it says. I just have a slight worry that its conclusions only really...

He made a bit of a mess of the quote tags :pinch: 🙂