Thanks Gila.

I myself felt it's not a good idea.

Can you eplain in detail the plus and minus of it.

Or any link for the same.

So that I can explain it in...

Yeah, I got your question now. I have never tried that way. Don't think you can directly access oracle database from SERVER1 this way.

Probably you can create temporary tables/Views in...

Gud question. I was bit confused between Principals and Securables.

I need to configure linked server between SQL server and Oracle database.

I don't have Oracle client installed in SQL server.

Can this be established in the following was?

Step1: Configure linked server...

I din't get the importance of this question. It's a simple question on Group By.....!!

Din't get your question. Can you pls calrify a bit more.

Depends. I do work in dotnet as well. Hence it...

Dear All,

Problem is solved.there was only on user table and it was listed among many system tables. Hence I din't notice.

Thanks.

Thank you all.

Wel, I am using IE7 only.

Think it's our network problem. Will catch our network guy n see.

Fine. Very gud.

Mostly I do everything using script only than SSMS.

Santhosh Nair.

thara.jacob (8/26/2009)

---

Hi All,

I have a problem. I have 2 sql servers running in two seperate locations. i created the backup from the first one and try to restore it in...

Sorry...Duplicate post because of Network issues.

Thank you "TheSQLGuru, GSquared, John Mitchell, Ken Simmons".

I was expecting such replies. Now I will look into all the options you said and will revert.

Thanks once again.

Good question.

I am able to understand why snapshot cannot be created on TEMPDB. But don't understand why it has been prohibited for Master and Model (Though it's not necessary to...

Hi,

Thanks for your replies.

But am not asking abt DB Diagram. Infact am pretty familar with that. Am talking abt Data Dictionary only. At present it's somthng like this.

1st sheet of...