May 21, 2008 at 12:26 am
This is a situation I haven't handled before.
I have a stored procedure which uses a column of a table. Unfortunately, the table exists, but the column does not. Still when we create or alter it, it shows 'completed successfully'.
Also, when this script is executed on another server, it gives the respective error, correctly.
Is there any database option or setting which has been tampered or changed by mistake.
Your helpful suggestions are welcome. Thanks in advance.
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
May 22, 2008 at 2:39 am
Someone please help.....this is critical.....if you want any other additional information to solve this, please ask......
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
May 22, 2008 at 5:28 am
I have cross checked the database settings for ANSI_WARNINGS, ANSI_NULLS,ANSI_PADDINGS and others, but they are same for both the databases, and are set to OFF..........still the difference.....can you tell me why?
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
May 23, 2008 at 12:42 am
Help.....Help.Help.......
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
May 23, 2008 at 2:10 am
looks like sp you are writing has got logical errors and their is no way tsql will pick them. you need to look at your logic.... 😉
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 23, 2008 at 2:20 am
Hi
is it deferred name resolution ?
"Keep Trying"
May 23, 2008 at 8:22 am
Script the proc and the table definition, and post them, please.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply