Stored Procedure Security

Results 1 to 2 of 2

Thread: Stored Procedure Security

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedure Security

    I am having problems running a stored procedure that I wrote in T-SQL. The stored procedure can run and creates about 20 tables when I invoke it within Query analyzer by using the Exec command. However, when I use it within ADO (VB), I am having problems creating about 10 of the tables. I know that the SP works so can this be a &#039;rights&#039; issue? Please note that I am the DBA because I work for a fairly small company. <BR><BR>Thanks <BR>

  2. #2
    Join Date
    Dec 1969

    Default *** 4th Repost ****

    Same problem..<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts