Hi David,

Thanks for responding.

I'm using DBCC SHRINKFILE only because the LOG file has never been backed up. Initially, I plan to shrink the LOG file once a month before backing...

thanks stevefromOZ, i c ur from brissy, same here

Hi, thanks for the reply. I realize that sql and access have different syntax for sql statements. but i just need to export them somehow 'coz like i said there...

found the solution, here ofcourse, just needed to use the OUTPUT parameter of sp_executesql.

i knew it'd be something that simple!...:-)