Is there a facility in the Server Studio or the SQL ... Business Intelligence Development Studio to create forms for input or browsing data? In the web environment I use ASP but what about on the desktop here? I have heard inklings that you can use Access as sort of a front end that connects to the SQL server ... What are the best ideas for input forms etc for end users in SQL Server R2- What the!

you can enter/change data in sql server tables with SSMS, but if you want to use it as a data entry form for users, no there is no builtin tools. but for browsing data you can use SSRS ( SQL Server Reporting Services ), and SSRS has its own forum which you can ask questions there: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/threadshttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com

Thanks! Well maybe in a few more versions SQL Server will get it together.- What the!