Hi All, I am trying to run this query on my database and I am getting an error Incorrect syntax near the keyword 'JOIN'. USE IVRCallCenterTest Go SELECT * FROM dbo.OutputPromptItem WHERE SegmentId=7198 JOIN dbo.OutputPrompt ON dbo.OutputPromptItem.PromptId=dbo.OutputPrompt.PromptID Go what is wrong with my code ? Thanks in advance

hi Vani, the examples in these pages are just talking about a SQL Server database that is local on the same hard drive but how to connect to a database on a URL Thanks

Hi All, I want to connect to a SQL Server database saved on URL database name fc000xststsql01.IVRCallCenterTest server address http://ma001xsicmw91/IVRControllerAppProd/Home/ what would be the connection string I will use in web config file ? Thanks

Hi All, I am using office 2007 interop DLL to create an Excel sheet in c#.NET. when I tried to test my app on a machine with office 2003 installed I get an exception because of the version number of the DLL . How can I determine in runtime what version of office is installed and then load the appropriate interop DLL for that version ?

Hi All, How can I extract the properties of Visio XML files .VSX ?