Restore via C# via Stored Procedure
jzelhart
Posts: 5 New member
in SQL Backup
In my connection string, we use a standard user that doesn't have rights to do the restore but inside the Stored Procedure, we user the LOGIN AS USER option to increase the rights.
I can run the Stored Procedure from SSMS without any issues. Both as sa and as the Standard User. But when I run it via the C# Code, I get Error Code 580 - Permission issue.
Anyone have any ideas?
I can run the Stored Procedure from SSMS without any issues. Both as sa and as the Standard User. But when I run it via the C# Code, I get Error Code 580 - Permission issue.
Anyone have any ideas?
