The 10-20 minute thing is why I had to split my Audit Logs article in two.

I've found salary.com is a reasonable approximation of what I find jobs listing for. Keep in mind that averages vary wildly by geography, and that some areas may offer...

Setting up the "free version" (Microsoft Sharepoint Foundation) should give you a playground to start getting familiar with Sharepoint, I'd think.

Keep in mind that varchar(max) can be 2 Gig of data. That's approximately 2-billion characters. A standard novel is about 1,000 characters per page, so you're looking at...

Yes, that's usually pretty easy to set up.

Are you running into a problem with your trigger? Or are you just not sure where to start?

Are you familiar with using the Ouput clause in Updates?

That's where I'd start. You can see the before-and-after of the rows affected, and work out what part of the...

What do you have the max text output set to in Options in SSMS?

I guess my take on it would be: What do you want for in-depth? Are there subjects you'd like to see, possibly authors you'd like to see them by?

But...

SwayneBell (7/4/2011)

---

I...

Ah! I get it now.

No, there doesn't appear to be an option for that. The closest would be under Query Execution options, "Disconnect after the query executes".

Syed Jahanzaib Bin hassan (7/4/2011)

---

the leaf level will be Col1,Col2

the leaf level will be same too as...

Permissions on tables shouldn't matter.

Try connecting using that login. Should be blocked.

I may be missing something.

Why not just replace:

and c.[Status] != 2 and c.[Status] != 3

...

Since I probably won't be on the site over the weekend (very busy weekend and holiday planned):

Happy 4th to all y'all 'Mericans!

Happy "Good Riddance to America Day" to you Brits.

Have...

MuskaanGoyal (6/24/2011)

---

I have already applied cell level encryption. But I don't want DBA to see the definition or modify any object. We are blocking DBA access for the security of...