error in connecting database

Question

hie guyz
i have problem in connecting service based database in windows forms.
when i click it its shows me the error
connections to sql server database require sql server 2005expres or 2008 express to be installed and running in the local computer
i dont know how to solve this error i have installed sql server2010 express from the website
but the error is not going
i am using windows 7.
but when installing whole package of vs2010 in windows xp doesent gives me such error only in windows 7 i am facing this problem

Answer 1

Nice,
This answer is helpful for me.

Answer 2

Thanks for reply. My question is how to find stored procedure which are related to particular table. Well, i have found the solution. SELECT DISTINCT sp.name as StoredProcedureName FROM syscomments scomment INNER JOIN sysobjects sp ON scomment.id=sp.id WHERE scomment.TEXT LIKE '%BannerStatistics%'

Answer 3

if you are looking for all sp used in specific DB you can use

select * from sys.objects where type='p'

or i am missing something