I got error message

When I ran below stored procedure, I got error message.

create procedure pro_log
as
declare @Execution_String varchar(255),
@logfile varchar(112)
select @logfile = '\server_name(Ffolder_namelog_name'+convert(varchar(8),getdat e(),112)+'.log'
Select @Execution_String = '(F):Mssql7Binnisql -S server_name -U user_name -P password -d datebase_name -q"procedure_name" > ' + @logfile
Print @Execution_String
Execute master..xp_cmdshell @Execution_String
return
GO
exec pro_log

************************************************** *************************
Mssql7Binnisql was unexpected at this time.

(1 row(s) affected)
************************************************** *************************

Any body can please tell me what is meant by above error message?

[Gary Andrews]

Try removing parens around the drive letter F. See what happens!


------------
at 10/26/00 2:23:43 PM

When I ran below stored procedure, I got error message.

create procedure pro_log
as
declare @Execution_String varchar(255),
@logfile varchar(112)
select @logfile = '\server_name(Ffolder_namelog_name'+convert(varchar(8),getdat e(),112)+'.log'
Select @Execution_String = '(F):Mssql7Binnisql -S server_name -U user_name -P password -d datebase_name -q"procedure_name" > ' + @logfile
Print @Execution_String
Execute master..xp_cmdshell @Execution_String
return
GO
exec pro_log

************************************************** *************************
Mssql7Binnisql was unexpected at this time.

(1 row(s) affected)
************************************************** *************************

Any body can please tell me what is meant by above error message?

[Jim W]

Also, change the F: to F$. UNC won't like F:.


------------
Gary Andrews at 10/26/00 2:57:39 PM

Try removing parens around the drive letter F. See what happens!


------------
at 10/26/00 2:23:43 PM

When I ran below stored procedure, I got error message.

create procedure pro_log
as
declare @Execution_String varchar(255),
@logfile varchar(112)
select @logfile = '\server_name(Ffolder_namelog_name'+convert(varchar(8),getdat e(),112)+'.log'
Select @Execution_String = '(F):Mssql7Binnisql -S server_name -U user_name -P password -d datebase_name -q"procedure_name" > ' + @logfile
Print @Execution_String
Execute master..xp_cmdshell @Execution_String
return
GO
exec pro_log

************************************************** *************************
Mssql7Binnisql was unexpected at this time.

(1 row(s) affected)
************************************************** *************************

Any body can please tell me what is meant by above error message?

Thank you for your reply.

I have tried without parens around the drive letter F, I got another error message which I list below.

************************************
The network name cannot be found.

(1 row(s) affected)
*************************************

I checked that I gave the correct server_name.

Thanks.


------------
Gary Andrews at 10/26/00 2:57:39 PM

Try removing parens around the drive letter F. See what happens!


------------
at 10/26/00 2:23:43 PM

When I ran below stored procedure, I got error message.

create procedure pro_log
as
declare @Execution_String varchar(255),
@logfile varchar(112)
select @logfile = '\server_name(Ffolder_namelog_name'+convert(varchar(8),getdat e(),112)+'.log'
Select @Execution_String = '(F):Mssql7Binnisql -S server_name -U user_name -P password -d datebase_name -q"procedure_name" > ' + @logfile
Print @Execution_String
Execute master..xp_cmdshell @Execution_String
return
GO
exec pro_log

************************************************** *************************
Mssql7Binnisql was unexpected at this time.

(1 row(s) affected)
************************************************** *************************

Any body can please tell me what is meant by above error message?

After I changed F: to F$, I got the error message which I list below:
********************************
Access is denied.

(1 row(s) affected)
********************************
I used sa as user name and correct password. Please help!

Thanks.


------------
Jim W at 10/26/00 3:25:07 PM

Also, change the F: to F$. UNC won't like F:.


------------
Gary Andrews at 10/26/00 2:57:39 PM

Try removing parens around the drive letter F. See what happens!


------------
at 10/26/00 2:23:43 PM

When I ran below stored procedure, I got error message.

create procedure pro_log
as
declare @Execution_String varchar(255),
@logfile varchar(112)
select @logfile = '\server_name(Ffolder_namelog_name'+convert(varchar(8),getdat e(),112)+'.log'
Select @Execution_String = '(F):Mssql7Binnisql -S server_name -U user_name -P password -d datebase_name -q"procedure_name" > ' + @logfile
Print @Execution_String
Execute master..xp_cmdshell @Execution_String
return
GO
exec pro_log

************************************************** *************************
Mssql7Binnisql was unexpected at this time.

(1 row(s) affected)
************************************************** *************************

Any body can please tell me what is meant by above error message?

[Gary Andrews]

It appears to me that progress on the problem is being made.

I am not an expert. But here is my take on the problem at this point.

"Access denied" is a Windows NT message indicating that a permission which is
needed is not held by the process being ran (ISQL for instance).

Step One.
---------------

It is my understanding that SQL Server is having the cmdshell executed on its behalf
USING the permissions associated with the account that SQL Server is executing under.

This account (the SQL Server account) needs to have NT admin rights, I think.

After adding admin rights, then stop and start SQL Server
so that it will gain access to the admin rights.

Step Two
---------------

Using EM, click management folder
Right click SQL Server Agent
Select properties
Click "job system" tab

There is a frame at the bottom which says "Non sys-admin job step proxy account"

Uncheck the box labelled "Only users with ........"

Try executing stored procedures again.

Best Wishes!!!





------------
at 10/26/00 3:28:21 PM


Thank you for your reply.

I have tried without parens around the drive letter F, I got another error message which I list below.

************************************
The network name cannot be found.

(1 row(s) affected)
*************************************

I checked that I gave the correct server_name.

Thanks.


------------
Gary Andrews at 10/26/00 2:57:39 PM

Try removing parens around the drive letter F. See what happens!


------------
at 10/26/00 2:23:43 PM

When I ran below stored procedure, I got error message.

create procedure pro_log
as
declare @Execution_String varchar(255),
@logfile varchar(112)
select @logfile = '\server_name(Ffolder_namelog_name'+convert(varchar(8),getdat e(),112)+'.log'
Select @Execution_String = '(F):Mssql7Binnisql -S server_name -U user_name -P password -d datebase_name -q"procedure_name" > ' + @logfile
Print @Execution_String
Execute master..xp_cmdshell @Execution_String
return
GO
exec pro_log

************************************************** *************************
Mssql7Binnisql was unexpected at this time.

(1 row(s) affected)
************************************************** *************************

Any body can please tell me what is meant by above error message?