>>I spent some time in MSDN T-SQL forum and for me now writing VFP SQL query takes a bit of a time - writing SQL queries comes naturally.
>
>One other question, now that I have you on the line: Can I create a SP in SQL from VFP with SQLEXEC()?
>
>I tried something like this:
>
>

>TEXT TO lcQuery TEXTMERGE NOSHOW
>ALTER PROCEDURE [dbo].[UserHasAccess]
>	@tnCoID int = 0, 
>	@tcUsKey varchar(36) = ''
>AS
>BEGIN
>	SET NOCOUNT ON;
>	DECLARE @lcSQL nvarchar(max)
>	SET @lcSQL  = 'select CAST(COUNT(*) AS int) AS FXCount from ' + 'Payroll' + ltrim(str(@tnCoId)) + '..Roles' + ' where DelFlag = 0 AND roUsKey = @tcUsKey'
>	EXECUTE sp_ExecuteSQL @lcSQL, N'@tcUsKey varchar(36)', @tcUsKey
>END TRANSACTION
>ENDTEXT
>
>SQLEXEC(nConn,lcQuery)
>

Last line before ENDTEXT should be END (not END TRANSACTION).

Are you getting an error once you fixed this error? I think it should work if you have sufficient rights with your connection to alter SP.