How can I check that? Thank you

Thank you,

How can I found out if fragmantation happend if there is no way in which we can say that when the index fragmentation will reach 50%.

Thank You,

Thank you so much,in my code I have listed fragmantation =50 then rebuild, how often what it get to 50 and how whould I know how often job rebuild indexes....

This someone created code and I will be removing it.

Otherwise is the code ok?

This is what I understand:

1.Checking on any errors for the database.The Check Database Integrity task performs internal...

Here is the error:

Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed. Unable to start execution of step 1 (reason: line(1): Syntax error). ...

I get this error when I view job history.What othet way to vie the error?

When I run my maintance plan,get error message:The package execution failed. The step failed. How can I fix it.Thank you

no I don't have log file set up for plan

I am running maintanse plan

Thank you everyone for your help, I just ran it and got error message:

Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed.

Any idea why?

for the system temp needs to be included too?

Thank you so much. So for re build index I am using:Reorganize pages with default amount of free space (I am not selecting anything else right?) and for all...

Thank you,but can you please help me with those

Check Database Integrity (should I include indexes?)

Shrink Database(do I need to do it?, if yes I have limit 50 mb and ...

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Base_CatalogHP". The conflict occurred in database "database1", table "dbo.Base_table1", column 'id'.".

I get this error. I am trying to copy table from...

I just re created table and I am ok,bit can't add data, what I need to do in order to insert data,should I disable a key and then re create...