create and attach data base

Hi, i want to create a database with out the LOG file I did not find a way to do that, I want to create database in 2 ways

1. With CREATE DATABASE command.

2.Attach an exsiting MDF file.

is there any way i can do that, my problem is that i'm creating the data base on my local computer the using sp_detach_db to detach the DB files, then trying to attach DB files from remote computer on the LAN that i dont have write premmsion on, but then i get an error from SQL server saying:

"[Microsoft][SQL Native Client][SQL Server]Unable to open the physical file "\\lab11\sqltest\pppSignaling_log.ldf". Operating system error 5: "5(Access is denied.)"."

what can i do to solve this problem?

thanks ishay

More about storage in network path in SQL Server can be found here:

http://support.microsoft.com/kb/304261/en-us

Generally spoken, this is not supported.

HTH, Jens Suessmeyer.

http://www.slqserver2005.de

Cover sheet orientation question

I have a report with several subreports. Each subreport is in landscape
format and so is the main report. I need to be able to attach a cover sheet
to the report that is portrait in orientation. Is this possible? The report
is rendered on-the-fly to pdf and emailed to the requestor.Hi,
I have the same problem, is any body got solutions for the below problem.
Thanks in advance for the helper.
Regards,
Anitha
"Chris Stewart" wrote:
> I have a report with several subreports. Each subreport is in landscape
> format and so is the main report. I need to be able to attach a cover sheet
> to the report that is portrait in orientation. Is this possible? The report
> is rendered on-the-fly to pdf and emailed to the requestor.