SQL Server Security

Results 1 to 2 of 2

Thread: SQL Server Security

  1. #1
    Join Date
    Dec 1969

    Default SQL Server 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 Repost??

    Both of these look like a repost of your earlier thread:<BR><BR>http://www.aspmessageboard.com/forum/databases.asp?M=357608&T=357608&F=21&P=1<BR><BR>re posting so soon after the original is frowned on..<BR><BR><BR>Can you post your stored procedure in your original thread?<BR><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