Posted by Greg D. Moore \(Strider\) on 02/20/07 19:23

"Goog79" <rachellara1979@gmail.com> wrote in message
news:1171995280.013209.191390@v45g2000cwv.googlegroups.com...
> Hi everyone,
>
> first time here, so I'm sorry if this has been covered already ages
> ago. :(

The stored proc itself looks fine.

But it's the .NET Framework that's giving the error. You may want to look
to a newsgroup that focuses on NET for more help.


>
> I am trying to learn T-SQL and Stored Procedures and bought the book
> on these topics by Djan Sunderic, Publisher McGraw Hill/Osborne. I'm
> already stuck on my first Stored Procedure and getting error messages
> that I cannot understand. I've already tried Google and Microsoft
> online to no avail. I do have the .NET Framework on my system and use
> it for programming in C# sometimes and by the looks of the error, it's
> something to do with that? Please note I am only using SQL Server
> Express.
>
> Here is the first Stored Procedure:
>

> The error in its entirety is this:
>
> Msg 6522, Level 16, State 1, Procedure ctrd_DDL_PROCEDURE_EVENTS_vb,
> Line 1
> A .NET Framework error occurred during execution of user defined
> routine or aggregate 'ctrd_DDL_PROCEDURE_EVENTS_vb':
> System.UnauthorizedAccessException: Access to the path 'c:
> \server_login.log' is denied.
> System.UnauthorizedAccessException:
> at System.IO.__Error.WinIOError(Int32 errorCode, String
> maybeFullPath)
> at System.IO.FileStream.Init(String path, FileMode mode, FileAccess
> access, Int32 rights, Boolean useRights, FileShare share, Int32
> bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String
> msgPath, Boolean bFromProxy)
> at System.IO.FileStream..ctor(String path, FileMode mode,
> FileAccess access, FileShare share, Int32 bufferSize, FileOptions
> options)
> at System.IO.StreamWriter.CreateFile(String path, Boolean append)
> at System.IO.StreamWriter..ctor(String path, Boolean append,
> Encoding encoding, Int32 bufferSize)
> at System.IO.StreamWriter..ctor(String path, Boolean append)
> at VbTriggers.Triggers.trigger_DDL_PROCEDURE_EVENTS()
> .
> The statement has been terminated.
>
> Can anyone assist please? :(
>
> Many thanks in advance,
> Lara

>--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

[Back to original message]