I'm sorry for the typos.The database file and log files are accessible.So what should i do now? Please guide me from here.

The database abd log files are accessible.So what should i do now? Please guide me from here.

Thanks.

I dont have a backup either.Can i take a backup now?

Thanks.

My disk is not full and there is lots of space available.what should be the other reasons.

What option should i select in this case(full backup of master and msdb)

1.Append to media

2.Overwrite existing media

Thanks for the info.

And one more question is that what would be the best data type to store the data of chapter_notes.And how can i have the same format in my database as...

I am running some stored procedures (sround 10) to calculate the summary of the data.And in those summary sps I am using lots of temp tables.

And the queries i am running are...

Thanks.It worked really well.

I'm sorry emp_name in the above query is a varchar datatype.

Thanks.

IF @alpha='0'

 BEGIN

  SELECT @sqlstmt='SELECT  a1,a2,a3,a4,a5, a6,a7, a8

     FROM #emp_temp order by ' +@col_name+' '+@orderby

 END

ELSE

  BEGIN

  SELECT @sqlstmt='SELECT  a1,a2,a3,a4,a5, a6,a7, a8

     FROM #emp_temp WHERE emp_name like '''+@alphabet+''' order by '

thanks for ur help

Hi

Thanks to all of u peole for helping me in this issue.

Hi i have one more question, with the above query I am getting the values in @C variable.Then how to get the reast of the columns for that...

Thank u very much.It's working fine.