Here is a useful script from Paul S. Randal[/url], lists open transactions with plans and text

😎

SELECT

[s_tst].[session_id],

[s_es].[login_name] AS [Login Name],

...

Jeff Moden (8/25/2014)

---

BWAAA-HAAA!!! Me too!

I'll...

cbernardes (8/25/2014)

---

I am using the DTS wizard and having problems importing excel into an existing table.

Problem is that various column in excel are defined as double in the wizard but...

kaplan71 (8/25/2014)

---

Hello --

I have been monitoring the amount of time it takes for a Full backup to complete. The e-mail notification shown below provides an example of the current state...

Couldn't post this solution at the time because of a quirk in the forum, had to PM it.

😎

USE tempdb;

GO

/*

Item Location ...

jkalmar 43328 (8/25/2014)

---

Eirikur, with this test data the expected result set would be:

C1473045850 T1954 3730 ''

C1473045850 T1954 3731 ''

C1473045850 T1954 3732 ...

jkalmar 43328 (8/25/2014)

---

OK, let me try to get you guys what you need...

CREATE TABLE PRE_LOAD(

KitID varchar(20) NULL,

BatteryID varchar(20) NULL,

TestID varchar(20) NULL,

LBSTAT varchar(8) NULL

)

INSERT INTO PRE_LOAD

(KitID, BatteryID,...

Don't think this needs any explanation, too funny

jjturner (8/25/2014)

---

Eirikur Eiriksson (8/25/2014)

---

jjturner (8/25/2014)

---

Yes, apologies for the tacit generalization (backup ~ backup/restore)

So further to the point, I'm having this DEV recovery model switch over to FULL a number of...

Feel I'm starting to repeat my self on the issue:pinch:

Using the RFC-4180, commas and double quotes within a column/field/attribute are not a problem. The problem is more that many of...

jjturner (8/25/2014)

---

Yes, apologies for the tacit generalization (backup ~ backup/restore)

So further to the point, I'm having this DEV recovery model switch over to FULL a number of days after it...

Lynn Pettis (8/25/2014)

---

rwaring 96203 (8/25/2014)

---

I am definitely no expert, but in my (25-year) career I see a big difference between those who write books about coding versus those of us...

I think you've just scoped your investigation here, suspect that somewhere there...

sqldriver (8/25/2014)

---

That's pretty cool. I like the position column. I don't think you need the extra step with the prefixes, though. Their position (at least in my actual data) isn't...

rwaring 96203 (8/25/2014)

---

I am definitely no expert, but in my (25-year) career I see a big difference between those who write books about coding versus those of us in the...