I figure out the problem...

This is in SQL Server 2000

No one have same issue before?

I figure out the answer.

Great! Thanks Aunt Kathi!

I used the Database Maintenance Plan Transaction Log Backup.

While the Recovery Model is Full

I know that.

That is my last full backup @ 1:00 AM

Then, the transaction log backup @ 2:00 AM

it is a local server.

output                                                                                                                                                                                                                                                         

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

The system cannot find the file specified.

NULL

(2 row(s) affected)

Good eye, SQLBill.

I made a typing typo here.

I manually run the script from Query Analyzer that have a SA credentials.

I checked and run this: Xp_cmdshell 'dir E:\Scipts\FULLBACKUP.BAK'

output                                                                                                                                                                                                                                                         

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

 Volume...

I installed the SP2 CTP but the Database Services part is Failed.

What should I do to fix?

Thanks for the help Sergiy! You're the MAN!!!

YES, just plain sql stmt...

select * into #temp from basis

what's crytical?

You mean critical?

Nope, I created #temp from different table using into stmt.

e.g. select * into #temp from basis

ok, I created and populated the #temp table before the stmt I provided above.

they all in a script I run in Query Analyzer.

IN BOL, Temporary Tables

SQL Server supports temporary tables....

your question not related to my question 'coz

I'm asking why if I run exec(@sqlstmt) there is no output

instead of running the stmt:declare @cnt int SELECT @cnt = count(1) FROM...