I removed the parameter from the SP and executed the SP (declare local variable and assign value instead) and it ran fine. I got the results in about 7 minutes. I tested this change in one server and I am testing it in other servers now. I will let you know. Thanks.
A table variable only exists during the run of the process that created it as is immediately destoryed at the end and any pages in tempdb associated with it are freed. Basically each time the procedure completes execution the object is immediately destroyed.So unless the stored procedures that create them are looping back on themselves […]
Hi, I am not an experienced guy in SQL Server. Please help me to solve my problem. I can connect through Static connection to SQL Server without any problem. Eg, Enterprise Manager or Power Builder etc. But when I connect through Query Analyzer or ODBC I getting the following error. ODBC: Msg 0, Level 16, […]