If anyone here knows the ins and outs of fn_dblog, perhaps you'd like to take a look here.

kiran.rajenimbalkar (11/16/2016)

---

Hi Sir,

I found one of the solution when i did r&d,

SELECT Operation,[Transaction ID], [Begin Time], [Transaction Name], [Transaction SID]

FROM fn_dblog(NULL, NULL)

WHERE [Transaction ID] = '0000:535604c2' --(Use your Transaction...

Unless there...

^^^ this.

It's specific data, not more waffle, that is being requested.

Sangeeth878787 (11/15/2016)

---

Hi,

I am not into DBA, but I got a task to create view/table to display all the jobs live status to display to Non Technical Team. Could any one...

Robert Frasca (11/15/2016)

---

Create a new table based on the node, with new columns based on the elements dynamically. In this example, a new table called Log with columns: datetime, ms,...

spin (11/15/2016)

---

Hi

it's a strange one.

I have a 64 bit VM (Server 2012) with 32 bit Sage ODBC which isn't working in SSIS. I can see the data in preview...

Robert Frasca (11/15/2016)

---

My objective is to shred it and store the data in tables dynamically. If that isn't possible then I guess I'll be forced to hard code for certain...

Without using VARIANT (SQL_VARIANT_PROPERTY(@number, 'Precision')), how...

Robert Frasca (11/15/2016)

---

I haven't ruled anything out but I'm not sure how Xquery can help me when I don't know what is in the XML at the time I'm trying...

Robert Frasca (11/15/2016)

---

Here's my scenario. I have a table that looks something like this:

CREATE TABLE [dbo].[Logs](

[rowGUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[lngClassID] [int] NOT NULL,

[DateTimeUTC] [varchar](20) NOT NULL,

[lngSessionID] [int] NOT...

Have you tried running in 32-bit mode?

sqlfriends (11/14/2016)

---

Yes , that was posted by me.

But I donot like to use recursive CTE, it is slow.

And I wonder if there are any other suggestions.

Thanks

Here is the...

Brandie Tarvin (11/14/2016)

---

AGGGGGHHHHHH!

I don't know if I'm having a language barrier issue with this vendor rep or if this person is truly this clueless.

VendorRep: Make sure to restore this copy...

sqlfriends (11/12/2016)

---

I have a truantday table that has students who has absent, each row is one student, one truant day starting from beginning of school year to current date.

I would...