Thank You very much! 🙂

Kalyani,

He was mentioning the below 3 things :

* Enable remote connections on the instance of SQL Server that you want to connect to from a remote...

Kalyani,

I understood what you were saying.Thanks for the scenario you were mentioning. Pretty much similar to the Oracle Archive logging Architecture.

I have 2 more questions here.

How many Virtual...

Hey Kalyani,

I have enabled the remote connections in my Surface Area Configuration but still the Error persists!!!!

Hi George.

Can you pl provide me the link??

It would be a great help!

Thanks.

Thanks Kalyani!

Coming back to my question, the BUILTIN\Administrators has been removed

from my SQL Server and you are saying that -E switch takes windows

authentication and since the user belongs to...

Hi Guys,

You right on!

It worked out very well.

Two more doubt in this topic.

First one, as Abhay was mentioning using the sqlcmd -S -E,

what is the use of -E. it...

Hey Abay,

I have done a big blunder man!

This is what i have done. Actually , i was doing trail and error on SQL Security.

First thing, My SQL Server is not...

Thanks Guys!

Hi Abhay,

Excellent!!!

Thanks a lot. it worked fine.

But again when i am try to connect using sqlcmd , am getting an Error.

Do you have any idea on that?

Am attaching the...

Thank You!

Thanks Hans!

I got the answer

SELECT

a.CoolectionID,

a.dmid,

a.gradeid,

a.facilitycode

FROM collection_test a

where

not exists (

select 1 from Grades where orgid=a.facilitycode

and a.gradeid in (select gradeid from grades where orgid = a.facilitycode )

)

and not exists

(select 1 from organization...

Thanks Dude...