I have realize that what I wrote on the past post have some misspells. Sorry for that it seems that I was writing English thinking in Spanish. But what I...

After going to the link server PROVIDER options and enabling Allow Inprocess

now whe can run openquerys usign the link server wich was the problem.

But how could I ron...

My problem with the SQL2000 was solved but now I have a problem with alinkserver to ORACLE.

Is giving me this error:

Msg 7399, Level 16, State 1, Line 1

The OLE...

Dude!... that's it. Why?

I, just ran the INSTCAT.SQL on the sql2000 server and it still gives me the same error.

OLE DB provider "SQLNCLI10" for linked server "myserver" returned message "Unspecified error".

OLE DB provider...

Is it safe to run the instcat.sql?

it seems to touch a lot of stuff.

OLE DB provider "SQLNCLI10" for linked server "myserver" returned message "Unspecified error".

OLE DB provider "SQLNCLI10" for linked server "myserver" returned message "The stored procedure required to complete this operation could...

well, yes I supposed.

I'm using the Server Type option as SQL Server.

I just found out that that it works on another DB on the same server (sql 2005) but not in the first one I tried...

It gives me the error

Msg 102, Level 15, State 1, Line 31

Incorrect syntax near '('.

I understand that is on the:

sys.dm_db_index_physical_stats (DB_ID()

But no matter what parameter I pass to the DB_ID...

Thanks!

Thanks dude! Gracias!

What does “stall” means in this context?

I’m from PR and cannot find a translation that makes sense.

Any help will be appreciated.

FJM

Thanks!!!

I’m trying to run this t-sql but it gives me this error:

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 9

Incorrect syntax...