Cap24. Mssql proceduri stocate built-in

March 29, 2010

1) Procedurile stocate sp_addtype si sp_droptype

2) Procedurile stocate sp_help si sp_helptext

3) Procedurile stocate sp_depends si sp_helpconstraint

4) Procedura stocata sp_key (PRIMARY KEY):

5) Procedura stocata sp_fkeys

6) Procedura sp_helpdb (afiseaza marimea si locatia fisierelor din bd) si procedura stocata sp_spaceused

7) Procedura stocata sp_helptrigger -afiseaza informatii despre triggeri

8) Procedura stocata sp_who si kill

9) Procedura stocata sp_lock (afiseaza informatii despre locks din bd)

10) Procedurile stocate sp_password si sp_addlogin:

sp_addlogin si alte proc.stocate:


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: