i jst add the read write permission to the directory
..
and xp_saveXml is my clr stored procedure
[Microsoft.SqlServer.Server.SqlProcedure]
public static void xp_SaveXML(string XmlData, String Filename)
{
try
{
FileIOPermission(FileIOPermissionAccess.AllAccess, Filename)
PermissionSet(PermissionState.Unrestricted)
ps.AddPermission(fp)
File.WriteAllText(Filename, XmlData)
XmlDocument xmlDoc = new XmlDocument()
SqlPipe output = SqlContext.Pipe
xmlDoc.LoadXml(XmlData)
xmlDoc.Save(Filename)
}
catch (Exception ex)
{
SqlContext.Pipe.Send("Error writing to file " + ex.Message)
}
}
....
it i think related to mu assebly strong name problem .. . as my assembly created from clr stored procedure is not assigned a strong name ....uh i m jst thinking of that all i m not sure about all this
....
can u plz go through this..?
thanks for reply