Thanks.

I fixed the problem by myself.

Thanks a lot.

The "Use page locks when accessing the index" option.

If unchecked it, the index re-ogranization would fail.

But I don't understand why by default :

(1)This option is checked when we create a...

Thanks your replies.

I fixed the problem.

Yes, in fact, we are using T-SQL REPLACE UDF, however, I want to know if I use CLR, will it be faster ?

I think as our existing UDF only do...

Thanks a lot.

Thanks.

My server was infected by virus before.

Although we had installed Anti-virus program, I think maybe the "Microsoft Search" service has been corrupted by the virus permantently.

Dear Torsten,

Thanks.

I resolved the problem by myself.

It was because the Web server was made by just cloning but not a proper install.

The problem was fixed by : uninstall MS DTC...

I am a Chinese and living in Hong Kong.

Dear Mark,

It worked.

You are very brilliant.

Thanks a lot.

Are you US citizen ?

Dear all,

Please see my attachment file as the web site cannot display an XML file properly.

Dear Mark,

My example was quoted from Microsoft's Web site :

http://msdn2.microsoft.com/en-us/library/ms191268.aspx

But you said : "Your XML doesn't show up, also I think WITH "tablename" will only pick up...

I fixed the problem by myself.

The cause was : there is a space character at the end of the database name, for example, the db name should be "ABC", but...

Dear jeff.williams.3188,

What you said seems correct.

I found all my SP1 2005 servers have the yellow Maintenance Plan icons while all the SP2 machines have the red icons.

Thanks a lot.

Dear Steve,

My Maintenance Plans can work properly but I just want to know the actual meanings of the icons.

Up to now, I haven't found any Microsoft official documents talking about...

Hello, please open my attached Word documents, then you can see SQL Server will assign different icons to my Maintenance Plans (I have several servers).

I want to know the exact...