Windows 10 IoT Core doesn't support SQL Server natively, no.

It does appear someone is writing an article about it here[/url] however their latest post doesn't have the answer yet...

Robin35 (12/9/2016)

---

Thom A (12/9/2016)

---

Correct me if I'm wrong, but are you instead saying that this particular login should always be assigned specific permissions whenever you create any and all databases...

SQL itself isn't great for creating a dataset and putting it into an attachment to email. You could put it into an inline html table, which the msdn page on...

Correct me if I'm wrong, but are you instead saying that this particular login should always be assigned specific permissions whenever you create any and all databases on an instance,...

Robin35 (12/9/2016)

---

Hello,

i'm trying to create a login and assign permission to login so that it should be able to assign any kind of permissions on any databases on that instance.

I'm...

Noticed this after I posted, note the edit 😉

Try to keep your code, when posting, in IFCode tags, it makes it much more readable for other users.

I've also changed your date formatting, as for me '11/20/2016' would mean...

OP psoted this in a different topic i was subscribed to, seems to be related to this topic, rather than the one he posted in:

v.razaghzadeh (12/9/2016)

---

Hi

Thank you so much...

kevaburg (12/9/2016)

---

When I understand the procedure...

As Ed said, I think I understand what you're after, but the DDL and sample data is the key here. Well done though on posted your code you have, and...

Didn't even notice that. The query still doesn't have any fields returned from [font="System"]wtprod.epmbuildrule[/font] or [font="System"]wtprod.epmreferencelink[/font], so they can still be taken out of your CROSS JOIN.

I still can't...

Looking at your query plan, the join you have to PK_WTPart is your big cost, with just under an estimated 4 Million rows at around 9kb each. That's about 34...

There are buttons on you Report Data pane to do this. They look like Up and Down Arrows.

Doh!!! :pinch:

Repeat of post http://www.sqlservercentral.com/Forums/Topic1841367-2799-1.aspx under different account?

Try to keep one topic per questions 🙂 😎