How to list all stored procedures in the current database using ms sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Does full backup break log chain?

0 Answers  


I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,


Define Check points and End Points?

1 Answers  


can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  


Can we hide the definition of a stored procedure from a use?

0 Answers  






What is the advantage of sql server?

0 Answers  


what is blocking? : Sql server database administration

0 Answers  


What is the difference between varchar and varchar types?

0 Answers  


What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  


hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,


Categories