Sreedhar Kantae

What SQL JOb's are running on 2005 Server

This script returns the information of all SQL Jobs that are running on the server with the latest status.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1.5 (2)

You rated this post out of 5. Change rating

2009-05-01 (first published: 2009-04-08)

1,617 reads

I heard someone say recently that you can’t change a primary key value in...

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

I do believe most people know about the ability to backup your SQL server...

Quick one I hope in case I'm heading off in entirely the wrong direction!...

Hi everyone I am looking at the size of my db on disk (ie...

Comments posted to this topic are about the item Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096

But then deleted the code and couldn't remember. Is there a way to check this?