Filestream error

Topics: Database Publishing Wizard
Nov 15, 2006 at 9:28 AM
I'm getting this error when I try to create my scripts, Error: FileStream will not open Win32 devices such as disk partitions and tape d
rives. Avoid use of "\\.\" in the path.

Here is the command I am using:
C:\Program Files\Microsoft SQL Server\90\Tools\Publishing>SqlPubWiz script -C "Data Source=DEVLX\SQLEXPRESS;Initial Catalog=BlackOpus;Integrated Security=True" con.sql
Nov 15, 2006 at 7:12 PM
Hi ckim06 -

I believe the error you are seeing is due to the fact that the name "con" is a reserved filename in Windows. Try naming your SQL file something else and see if the error continues.

http://blogs.msdn.com/oldnewthing/archive/2003/10/22/55388.aspx has more information on this quirk of Windows. :)

Thanks,
alex
Nov 15, 2006 at 8:40 PM
Hey, that worked great! Thanks! Great product.