SQL Server Performance Forum – Threads Archive
Compilation Issue
Hi Gurus,I’am back again where i got solution for most of my doubts and issues, this time i’am after a compilation issue of SP’s in sql server 2005.
If anyone tries to create a SP in SQL 2000 with reference to a object like table which is not existing in the DB it will get created and when you executes it at runtime u will get the error ‘Invalid object name <Table name>.
My problem is when i tried this in SQL Server2005 Standard(No Service packs) this error i was getting on creation of that SP, but now testing this in a SQL 2005 enterprise(SP2) its behaving same like in SQL2000 error is generation only at runtime.
Is this anything related to precompiled plan of SQL Server?? or is there any server based setting to confugure server to capture this error at the time of creation of SP. Regards
Mat
http://sqlserver-qa.net/blogs/perftune/archive/2007/05/08/stored-procedures-performance-issues.aspx
http://sqlserver-qa.net/blogs/perft…-optimizer-reuses-for-better-performance.aspx
http://sqlserver-qa.net/blogs/perftune/archive/2007/04/27/recompile-all-the-stored-procedures.aspx
..shoud get you more information. Another feature in SQL 2k5 is exception handling http://www.sqlservercentral.com/columnists/rVasant/exceptionhandlinginsqlserver2005.asp
And you can look into TRY..CATCH also for more information.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>