You're missing an END on the case

SELECT isnull([PAID],'NO') as [PAID] ,

CASE WHEN isnull(a.[Refill Sales ID],0) = 0 then 'No Refil'

ELSE...

Should be possible with a case statement. Something like this (partial code only)

SELECT ...

CASE WHEN [Refill ID] IS NULL

THEN 'No REFIL'

...

Could you post the entire error message please? The title gets cut short.

No backup? Why not?

Gone as in deleted from the operating system? how did that happen?

Do you have a recent backup?

How many log files did the database have?

Was the database detached cleanly from...

Download the 180 day demo of SQL server if you don't have access to a SQL server and get familiar with management studio. The only way you're going to pass...

If I know absolutely, for...

Add to that a full backup after switching back into full recovery mode. After truncating log you have no point-in-time recovery untill you take a full/diff backup.

Actually the restore of last backup should...

Depends. I've seen some cases where the slightly less accurate plan was better than a recompile of the entire proc (SQL 2000). On 2005 with statement level recompiles, would probably...

Yup, though you can still get a stats-based recompile from the temp table, sometimes even more than once.

The main advantage I've seen for table vars is that they don't cause a stored proc to recompile.

As for number of rows, it depends what you're going to do...

Perhaps you could run profiler for a while and filter on the application name. I'm not sure 100% what appname reporting services uses, but it should be fairly easy to...

SQL doesn't have an equivalent to the Oracle RowID.

What are you trying to achieve?

And the process does exist? If you run sp_who2 <Spid> does ti return a row?

Are you sysadmin on that server?

Has the problem been around since the rebuild of the server...

Depends why it's suspect. Check though the error log, see if you can find an entry in the log saying that SQL is marking the database suspect. It should give...