Posted by Goog79 on 02/20/07 18:14

Hi everyone,

first time here, so I'm sorry if this has been covered already ages
ago. :(

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:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE ap_Hello
AS
BEGIN
SET NOCOUNT ON;

SELECT 'Hello world'
SELECT * from dbo.EqType
END
GO

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

[Back to original message]