Right click on the server in SSMS and click on properties. you will get the Server Properties window. Choose security and it should show what you are set...

I have to admit I wasn't aware of that.. I assume you are basing that on this statement: "SQL Server Management Studio 2005 can read and modify CE 3.0...

You'll need to provide more details about the EXEC sql task. As I read it you want to take its output and write it to a flat file. ...

I agree, sounds like homework.. Google it, BING it.. There are your answers..

CEWII

Did you not understand what was posted at:

http://www.sqlservercentral.com/Forums/Topic803085-148-1.aspx

CEWII

Since the reason it is used tends to be so that there is a unique value for the record it is very normal to make it a unique index, often...

I have had exactly the same problem for exactly the same reason..

CEWII

Then service broker sounds pretty good..

CEWII

I'm sorry, I think you have done everything I would have done.. There is nothing else that would be obvious..

Sorry man..

CEWII

I have to agree. I call it the hammer and nail principle.. When all you have knowledge of is SQL you think every problem should be solved with...

It is stored in the registry in the instance specific registry, the Key is AuditLevel. On my machine for SQL 2008 Express is at:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQLServer

0 = None

1 =...

And you are using the SQLClient and not the oledbclient? Then that is wierd..

CEWII

You might be able to re-apply a service pack to resolve this.. Not sure though.

CEWII

IS it an ADO.NET or OLEDB connection string.. It makes a difference..

CEWII

I really must caution you on this method. If server b is not available, or that database on server b is not available, or there is a network problem...