Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to Debug a Stored Procedure?

Answer Posted / sivakumar

Steps for debugging stored procedure is given below
1.Open the Microsoft visual Studio
2.Select Server Explorer
3.Add Server
4.Select Database Where Procedure is located
5.Select Procedure for debug
6.Right click and select Step into stored procedure
7.Pass Parameter to that procedure
8.Then Do debug.

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what is fill factor and pad index?

940


Explain what is log shipping?

1073


What is the maximum size of a dimension? : sql server analysis services, ssas

1000


What are the steps to insert a table?

892


What is 2nf normalization form?

1049


wat wil hapn if we give the both read and deny read permission to user?

2061


Is ssrs support other database except ms sql server?

127


Do you know the different ddl commands in sql?

994


What do you mean by cardinality?

848


What is the definition for sql server 2000?

1040


How can change procedure in sql server?

986


What is failover clustering overview?

1021


What do you understand by replication in sql server? Mention the different types of replication in sql server.

893


Define inner join? Explain with an example?

924


Are semicolons required at the end of sql statements in sql server 2005?

932