Does someone have an answer for this?

Output to file or text doesn't work. But I will dig some more. Thanks a lot for explaining this to me. Much appreciated.

I see what you mean thanks. These are config info for several applications and you are right, they don't have to displayed.

But is there any way I can display it...

Hi,

if it is only going to display 8000 chars, what is the point of using a column that can have more than 8000 chars?

Am I "select"ing it wrong?

RM

Hi,

I am able to insert more than 8000 characters. but when I select after converting to varchar, it chops the values.

For example, if you run the blow, you will see...

Great. Thank you

DBCC CHECKDB(master) is running for last 7 hours.

What do I do in this case? Is it possible to build this from scratch?

Thanks I am going to try that.

There is one more database on the same instance. if the master DB is corrupted, will the other DB work?

Thanks guys. I will give these a whirl..

Thanks a lot for your reply

Thanks a lot for explaining this to me. Great.

Thanks.

But Why should the index be scheduled to run if every write operation is written to the index at real time..