Hi,

Yes. thats correct

Hi Eddie,

Thanks for your immediate response. Just to...

Yes the query will constantly run to examine what processes are running, why at particular time a particular stp was running slow OR if there was any blocking session then...

Only ABC is getting stored in the table in my case. Blank gets stored for second. Though the value in the rest of the columns matches.

The databases are on the same server and same login. In fact i checked the both database quoted_identifier properties and its false. Then i set to true in which the...

wouldn't that introduce loop back problem. I have implemented suggestion 1 by Kevin.

Thanks all

Hi,

I tried to run the above mentioned cursor independently in T-SQL query and found below error

Executing SQL directly; no cursor

A severe error occurred on the current command. The result, if...

Hi Lowell,

Thanks for replying. However i am not sure if settings of ANSI_NULL or ANSI_PADDING exists in C++ (as my colleague informed me). Hence how the comparison can be done....

Also I found irrational behavior. in some instance it is creating the table but when inserting into the same, it gives error as invalid object table name. In this case...

On giving default schema as dbo or others in login properties window--> user mappings, following error pops up

" The DEFAULT_SCHEMA clause cannot be used with the Windows group or with...

the default schema is un-defined hence by default it should be dbo.

Thanks Gail. By login through local admin account, I could connect and unlocked the SQL logins.