DavidL (2/1/2012)

---

Correct. The example I sent...

dinesh8804 (2/2/2012)

---

create table t1(marks int)

create table t2(comments varchar(10))

insert into t1 values(100)

insert into t1 values(200)

insert into t2 values('d')

insert into t2 values('i')

I have created two tables t1 and t2.i have different two...

If I'm not mistaken, both SQL Server Audit and Change Data Capture are Enterpise edition features. Or has that changed?

Standard edition and below, Output and/or triggers, possibly combined with...

Here's a sample with correct semicolons:

IF 1 = 1

BEGIN ;

PRINT 'Yep' ;

END ;

ELSE...

What difference? I don't see any differences in sp_trace_create, sp_trace_setevent, or any of the related functions. Maybe some more events/columns added that I'm just not seeing?

Anyway, I have...

Not enough for me to see a real pattern to it.

I think I'd need access to the actual server and database to really determine what's going on. I'd test...

Jack Corbett (2/1/2012)

---

Evil Kraig F (1/31/2012)

---

A robot DBA may not injure data or, through inaction, allow data to come to harm.

A robot DBA must obey the...

Steve Jones - SSC Editor (2/1/2012)

---

GSquared (2/1/2012)

---

HowardW (2/1/2012)

---

Is this guy annoying the hell out of anyone else?

Not sure whether to call it spam or not, but most of his posts...

L' Eomot Inversé (2/1/2012)

---

GSquared (2/1/2012)

---

HowardW (2/1/2012)

---

Is this guy annoying the hell out of anyone else?

Not sure whether to call it spam or not, but most of his posts wouldn't pass...

Looks like...

dinesh8804 (2/1/2012)

---

I have two tables.suppose i have table1 columns-Marks int and in table2 -comments varchar(10) and i have different no of rows in both tables.I want to combine and display...

That won't work, since...

Evil Kraig F (1/31/2012)

---

Jeff Moden (1/31/2012)

---

Brandie Tarvin (1/31/2012)

---

Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list....

Brandie Tarvin (1/31/2012)

---

Near the beginning of the month, my boss says "why aren't these files being removed from the Inbound folder? Add a task to this SSIS package that deletes...

I put the UDF through some simple unit-testing and it does appear to be deterministic, so I don't think that's the issue. (Had to confirm that, of course.)

In the...