how many types of store procedre in sqlserver 2000?

Answer Posted / dinesh sharma

Their Are Two Type Of SP
1)System SP
2)dbo (DataBase Owner) mean User Defined SP

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is blocking? : Sql server database administration

492


Explain indexed views and partitioned view with their syntax.

670


What is the difference between clustered and non-clustered indexes in ms sql server?

474


Distinguish between nested subquery and correlated subquery?

537


What is rtm version in sql server?

516






Explain differentiate between a having clause and a where clause?

505


What are group functions in query statements in ms sql server?

541


How to create sub reports?

192


Do you know what are the restrictions that views have to follow?

612


How to get a list of all tables with "sys.tables" view in ms sql server?

540


How exceptions can be handled in sql server programming?

534


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

530


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

519


Explain magic tables in sql server?

537


A trigger can reference objects outside the current database? State true or false.

542