Hi, Look at OPENQUERY() in the SQL server BOL, second topic (T-SQL reference)

If you have the linked server set up, you should be able to call the sproc using ORACLE's...

What shows up in the IIS logs?  Is the IIS machine the same as the SQL server?

Anything is possible, I suppose.   I would still check things along the way from point A to point B.  The easiest place to look is on the SQL server, so...

Ya tengo mucho hambre.  Gracias, Cesar.

Another thing would be to try:

SET XACT_ABORT ON

before the update. 

Can you perform an insert using a different client and the same ODBC DSN that you are using in the linked server?   (suggesting perhaps a linked table in access)

Also, have you...

I would trace the SQL server with profiler.  That way you can see the exact SQL statements that are running on that server.

I would carefully inspect the tables that are...

Hello,

The Hexadecimal error returned by OLEDB (0x80004005) is 'Access Denied'  which could indicate a permissions problem.

Does the user have permission to insert data?

Can you try specifiying the columns explicitly in...

I like to chew on the network cable that connects the Websense "server" to the network.  Can't get to the link...

I'm all over the Gardetto's snack mix.  That keeps me...

Also, you can confirm what is happening at the time of the failure using the profiler.  My guess is that it will be a CREATE INDEX statement.

jg

Edwin,

You have approximately 1.5 times the size of the database available for the log file.  There is probably nothing wrong with SQL server.  You likely just need more disk space. ...

Okey doke.  Perhaps the latest SP is not the answer.  Hopefully it is not.

Now, what was the size of the data file(s) and the size of the trans. log file(s)...

Edwin, build 194 is service pack *none*.  I'm not sure that is the problem, and perhaps Mr. Uddin has something specific in mind, but I would think you should be using at least SP3...

Hi Edwin,

That is the O/S version.  Win2003 SP1.  Mohammed is asking for the SQL server version.

Do a select @@version from Query analyzer on the servers and report the results.

IIRC, when...

As long as there is at least *some* beer, then we're OK.