Hi All,
I m creating CLR Integrated stored procedure in C# VS 2005

 Im using Streamwrite n creating text file in C drive.
Now in retriving date in data set.
writing data n text file using steam writer.
Now my code is getting build n deplyed
when i m executing through Management studio .procedure is getting executed Bt my text file is not getting created.
Cn any body help me.
plzzzzzzz
:((

I know this will sound silly, but you are checking on the right hard drive - I'm assuming it will be the C: drive on the server that it is trying to write to, rather than the C: drive on your PC (unless you happen to be running the server on your own PC, in which case they will obviously both be the same).

Other than that its likely to be a security issue, but in that case I would expect you to get an Exception, rather than the procedure running fine.

/- Sam Judson : Wrox Technical Editor -/

Hi ,
First of all thanks for reply.
Actually i m trying this code on Server machine itselt.
One more doubt i hv whether SQL Server supports System.IO Bcaz when i went into add reference on soln explorer i m not abel to get any of dll except System.Data,System.Data.sqlClint,OracleClient..... ..
 If nt
cn u suggest me i hv to retrive data n write that data frm sql n that data i hv to write in text file n File shoukd be created at runtime
regards,
Pady 123
:)

The System.IO namespace is core to the .Net framework, therefore most (if not all) of it is in mscorlib.dll. You can confirm this by looking at the "Assembly:" bit in the MSDN reference for each class.

You keep missing letters out of your words - I'm finding it very hard to read you posts. Please try to include all your vowels in future!

/- Sam Judson : Wrox Technical Editor -/

THANKS A LOT