SQL Server 2008 How to return Errors to web pages for development

since have moved sql server 2008 r2 server have not been getting detailed errors sql server on development asp pages. sql server use return detail error if stored procedure missing parameter or column did not exist. blank page no information directing me source of error. there missing? have through options in management studio have found nothing. tried nothing relating problem.

maybe there system stored procedure raises errors globally?

 

sql server 2008 r2

microsoft sql server management studio             10.50.1617.0
microsoft analysis services client tools                  10.50.1617.0
microsoft data access components (mdac)           3.86.3959
microsoft msxml                                                     2.6 3.0 6.0
microsoft internet explorer                                     8.0.6001.18702
microsoft .net framework                                      2.0.50727.3625
operating system                                                  5.2.3790

could compare database options , server configuration see if different?  server configuration:

-- server configuration  -- assuming remote linked server    select c.name, c.value_in_use, rc.value_in_use   from master.sys.configurations c -- new server     left outer join           remote.master.sys.configurations rc -- old server     on c.name = rc.name  where c.value_in_use <> rc.value_in_use  

for database configurations can scan results

declare @dbname nvarchar(128) set @dbname = n'yourdbname' select n'local' as server, * from master.sys.databases where name = @dbname union all select 
n'other', * from remote.master.sys.databases where name = @dbname order by name, server

this have scan scrolling results sidewise looking differences.

just start.

rlf

SQL Server  >  SQL Server Tools