roger.plowman (6/20/2016)

---

I would have thought the lack of a GO after the GRANT would have left permissions unchanged for the final SELECT. This is something I've run into with SQL...

Try fn_dblog

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

For both, you'll need to provide code. I'm not sure why #1 wouldn't return something without more detail.

For #2, are you sure this fires? I'd add logging code to your...

I agree with Scott. Don't worry about this.

Luis got it.

Essentially the online version of TFS. Has VCS, build, release, work tracking, etc. It's really slick, and I like it. It's the equivalent of TFS Server 2015 Update...

Well, my navigations through the world of VSTS are complete, or at least, working.

As much as I like the system, finding information and understanding exactly what's happening is hard. I...

chris 24158 (6/17/2016)

---

The latest series of posts you enjoy so much from Microsoft says:

I can’t emphasize this patch enough. There is a MSVC, runtime library patch needed by...

Start here: http://www.sqlservercentral.com/stairway/110890/

It's not really query and find the data, it's automatic partitioning, moving data to another instance of SQL Server. There's a difference, and it's a valuable tool to have.

I just...

Do you mean just have Firstname in the query without knowing it's below Recipient/Customer?

No. The path is the path. In the Nodes, you've set the top level for that...

XML is case sensitive.

This should help you get moving

SELECT

t.b.value('(MsgID)[1]', 'NVARCHAR(1000)') AS MSGID

, t.b.value('(MsgTime)[1]', 'NVARCHAR(1000)') AS MsgTime

,...

GSquared (6/15/2016)

---

This can turn into a complex question. The rule-of-thumb that I try to follow on things like this is: The more clever the solution has to be, the...

Yes and no. I'll be doing some content here to explain how this works and how you can use it, but I'd encourage you to play with it in a...

Take it Keith. Should be short and easy.

Cheers, and glad it worked. Sorry I didn't think of it 🙁