Alternatively, you can bypass sys.sql_modules all together and use OBJECT_DEFINITION.

CREATE VIEW MyView

AS

SELECT 1 AS Col1;

GO

SELECT OBJECT_DEFINITION(OBJECT_ID('MyView'))

corey lawson (9/8/2016)

---

Hmm... I kind of like the XML-based splitter method, if only because part of the process is it can throw out the data in the output tableset as...

I was talking about the triggers themselves. I had a situation a few years back...

The pros are that SQL Server Replication is stable and reliable...

Ditto everything Drew said. We'll need more info to help you.

Perhaps something like this (I did a few permutations based on my best guess of what you need).

SELECT...

Sorry I almost missed this.

Yes, I was saying that using MIN seemed...

That means the service is either failing to start and crashing. That's something a DBA or Server Admin would have to look into. A service failing to start or crashing...

Adam Sandler (9/1/2016)

---

Thanks Alan - I suppose this is something I should get the local network / support people to set up for me?

Any settings I can apply to make...

Can you provide an example of what you are getting as well as what you should be getting?

Adam Sandler (9/1/2016)

---

Basically I have jobs on a server, which I dont control or the hardware its on. I have jobs like backups running. If agent isnt running, the jobs...

Everyone has touched on this but the most important thing to understand is: the only way to guarantee that results are returned in a specific order is with an ORDER...

I...

but I'm learning using DAX/PowerPivot/PowerBI. (gotta start somewhere!) and then I watched Brad Gall's presentation on Analysis Services. It's not a new video, but it made me wonder... if you...

I don't have enough Postgres experience to say how it compares to SQL Server but if you know what you're doing you can make a search-intense workload move pretty quick...

np!