Indian currency note recognition using matlab code. Whenever i execute any stored procedure, it just display the message ‘ could not find the stored procedure (name)’. I am displaying here a simple query of stored procedure for better understandCREATE PROC PRO2 @FirstName char(15)=NULL, @City char(15)=NULLASSELECT. FROM PERSONSWHERE FirstName LIKE ISNULL(@FirstName,FirstName)+’%’AND@City LIKE ‘%’+ISNULL(@City,City)+’%’GOEXEC PRO2 @FirstName=’h’,@City=’lt’even i do this query to assure its existence ‘sphelp pro2’ this works and shows me its contents. I think there is a problem in schema but i cont understand this term clearly.
Msg 50000 Level 16 State 1 Line 70 Hours
Plz help me out for this!
SalPari on Wed, 15 Feb 2017 12:14:51Hello,When i execute the below procedure i am getting an errorexec XYZ.sys.spaddlogreaderagent @joblogin ='domain user', @jobpassword ='password', @publishersecuritymode = 1, @jobname = nullThe error i am getting is:Msg 50000, Level 16, State 1, Procedure spaddjobstepinternal, Line 255The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.Msg 3931, Level 16, State 1, Procedure spMSaddrepljobunsafe, Line 376The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction.Please help!!!Thanks,Sal.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |