Bobby Heid
bheid at sc.rr.com
Sat Mar 13 08:39:14 CST 2010
Hi John, I still mostly use SSMS, but you can step through sprocs from VS2008. IIRC, under server explorer, find the sproc and right-click. Then I think there is a debug menu item. This lets you step through the sproc. I was playing around when I found this, so not sure if I remember correctly. But yes, I think you can do a lot against SQL via VS2008. Bobby -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, March 12, 2010 5:58 PM To: Sqlserver-Dba Subject: [dba-SQLServer] Using Visual Studio with SQL Server 2008 Is anyone completely replacing SQL Server Management Studio with Visual Studio 2008? Is that possible? I am in VS2008 a lot these days doing C# stuff and it would be awesome if I could just stop using SSMS. I would love to be able to step through my SP and UDFs with a debugger, watch variables and the like, but I just don't know how. Is anyone doing this? -- John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com