I created a user called development in sql server 2005 and make it a member
of datareader,datewriter and ddladmin role. now I created a proc under that
development account. however when I try to exec that proc, its give a
permission denied error. How come? it was able to create proc, but not
exec, its there something I have to do?
typo error... ...First Proc should be p1 and not p3 ... > exec p1 ... >> Over night we take a copy of various live SQL databases onto another SQL ... >> I connect to the live databases using linked servers. ... (microsoft.public.sqlserver.programming)
Re: Strangeness in PROC-land ... //STEP1 EXEC PGM=IEFBR14 ... It complains about the second PEND because you can not nest PROCs inside ... instream data inside a PROC.... But the JCL error is on the second PEND ... (bit.listserv.ibm-main)
Re: SQL Variable USE. ... I then exec the proc like so: ...SQL server will decide where to put it on ... > it from the database level settings.... (microsoft.public.sqlserver.programming)
Changing the step name in a procedure by using a parameter ... Naming each step for PROC A is easy, but all the steps generated by PROC B will have the same name. ... We haven't found a way to reference the condition code of a step within a procedure within a procedure. ... //X&MSR.A EXEC ... ... For IBM-MAIN subscribe / signoff / archive access instructions,... (bit.listserv.ibm-main)
