Stored Procedures...!

[Sybase123]

Hi Derek/Nag,

Can you explain about below mentioned stored procedures.


sp_add_qpgroup
sp_add_resource_limit
sp_externlogin
sp_addobjectdefs
sp_autoconnect
sp_autoformat
sp_checknames
sp_checkreswords
sp_chgattribute
sp_copy_qplan

Regards,
Sybase ASE

[Nagendra]

Request you to go through these System SPs in the Sybase manuals and ask specific questions.

Thanks,
Nag

[Sybase123]

Hi Nag,

I have gone through Sybase manuals but i am not understanding about those mentioned stored procedures in above. Moreover I was tried with those mentioned SP's on my local ASE server i haven't got anything.

Please can you explain about those SP mentioned in above if you are free.

Thanks in advanced.


Regards,
Sybase123.

[DerekAsirvadem]

(11-29-2011 04:17 AM)Sybase123 Wrote:  I have gone through Sybase manuals but i am not understanding about those mentioned stored procedures in above.

Ok. Let's take an example, sp_add_qp_group (slight correction to the name, but that is a minor issue). I looked at the manual. It seems pretty straight-forward to me. I have attached the manual entry for the proc. What exactly do you not understand ?

Quote:Moreover I was tried with those mentioned SP's on my local ASE server i haven't got anything.

Now that is hard to believe. You executed a stored proc, and did not get anything at all ? No output; no error message; nothing ?

Is your computer connected to the network ? Try sp_who, does that produce output or an error message ? If not, you are not connected.

If you have difficulty interpreting the output, post it here.

Quote:Please can you explain about those SP mentioned in above if you are free.

Sure. I am happy to answer specific questions, if you look at my responses, you will see they are quite detailed. This is a forum, not a place for tutorials. I am not prepared to provide discourses, or synopses. I can't speak for Nagendra or anyone else here, but I suspect they feel he same. Read the manuals, then ask specific questions.

[Sybase123]

Hi,

Thanks for your reply..

[dvdanurag@gmail.com]

Probably you may check on

www.wiki.sybaseblog.com



--Sybanurag--