Hello Lowry,

kb933508, kb933097...

Its a little bit confusing and not very clear.

We will see what we will apply... not very "confortable" with all that.

Best regards.

Carl

Thanks Mohammed,

What SQL Bug number, in this hotfix, do you think is related to what we are living here?

Best regards.

Carl

For the Rebuild Indexes job we have this output (poping when we go to see the maintenance plan generated SQL):

Rebuild failed for Index 'idx1'.  (Microsoft.SqlServer.Smo)

------------------------------

For help,...

Good idea! Never thought of it. I will tell my boss...

I'll wait for you to implement it first and tell me how it goes...

Thanks Steve and what about the possibility to resume what was began before the "crash"?

Here is the answer posted by a Microsoft SQL Server member of the "Storage Engine - Accces method team":

I finally found the problem: It is only that the SQL Server Browser service was not running...

Nothing was listening on UDP port 1433 to give the dynamic port allocated (3416)...

Hello Muhammed, Yelena,

I had mention in the first post that I had done a test using named pipes and it worked:

osql /S\\sql5\pipe\MSSQL$gcrm\sql\query /E

It is obviously the same thing if...

Hello Muhammed... what do you mean exactly?

Regards.

Carl

It worked.

It would involve a lot of modification in the code of our application... But nothing would ensure we are not reading something that is in the process of being...

What is more confusing is...

If I run the query done by proccess ID 112 (without commiting) and than I run the query done by process ID 87, it is ok.....

Hello Francis,

Thanks for your input...

Process 122 have an IX on the table (TAB) which does not forbid another process having an IX lock on the same table (TAB).

Try to QUERY one of your...

Thanks Mohammed,

You are rigth : Using old system table (now views on SQL Server 2005) work the same way as SQL Server 2000 for naming resolution.

Maybe we won't have the...

You can also use an alias no the client side.

Carl

My complain is not about creating a maintenance plan but maintaining it .

We can have more than one hundred databases on a server.

We may need...