Thank you for your notification I have three questions :

1- What do you mean by full backup in OS level?

2-Should I have maintenance window for using sharepoint in...

thank you for your notification..

yes, I am using sql server 2014 instance

I really wish that our friends in this forum , FIRST READ CAREFULLY THE QUESTIONS AND THEN ANSWER.

Yes, in design mode I want to add a column, I said it is error because it does not add a column really, It wants to save my table as...

Yes, Exactlty , I want to add a column , of course I have created my table before , an it has data , but now I want...

Thanks alot

Thank you but again there is a error "invalid parameter 1 specified for dateadd!"

No, i am sure that in Table2 only i have two records for each "Filenumber"

thanks alot for your notification.

i want all of filenumbers.

thanks but i want the records after that Max(ID), with all of their fields

Filed1 Field2 Field3

1 A ...

thank you i understand what are you saying but there is another problem, and that is: maybe maybe operator send null or ' ' , so i have to...

ok, Course_Name if column name , so i wroteit correctly:

Else (freetext(Course_Name,@VarCourse_Name))

but there is syntax error

what is the udf?

thank you for your notification but again i have that message:

Incorrect syntax near the keyword 'freetext'.