It looks like you are actually trying to do TWO inserts at one time. Can't do it that way.

1st: do the INSERT that uses the SELECT:

Insert into openquery (LPUSA01,'select client_number,client_name,bill_to_name,account_exec_name,invoice_number,invoice_type,cast(invoice_date...

There seems to be another problem also.

You are doing an INSERT. What is the purpose of the SELECT?

An INSERT is done one of two basic ways:

1. INSERT INTO tablename ()

...

As someone else said...this is just plain wrong.

cast(invoice_date as char(8000)),cast(invoice_due_date as char(8000)),

A datetime value is at the most 22 characters (1234-67-90 23:56:89.123). Change those values. If it doesn't return...

Is it an Access database or a SQL Server database? Your information says it's an Access FRONT-END and a SQL Server database. An Access front-end is the forms that are...

How do you get the 3 in this line?

2 3 'row1-2 'row2-2''

-SQLBill

What happens if you click cancel, then open a connection via file? Does it work fine?

If so run this and let us know the results:

SELECT Serverproperty('ProductVersion'),

ServerProperty('ProductLevel'),

ServerProperty('Edition')

That will show us what...

Now MY answer would be that the one using IN would work faster. Why? Because the first one would fail for a syntax error.

Jurriaan asked about this...

WHERE <> = (X...

What account are you using to log into SQL Server and use Enterprise Manager? Does it have SQL Server sysadmin privilege?

-SQLBill

Congrats on resolving the issue and posting the solution. In the future it may help someone else who uses Documentum and SQL Server.

-SQLBill

Another thing.....did you create any applications? If so, might they be running using your login/password?

Again, stop the SQL Server Agent service. See if the problem continues. If it stops,...

For updating, create a trigger that when an update occurs, it also updates the created_date column (or whatever name you choose).

I suggest that instead of calling it Created_Date, you use...

Run this from Query Analyzer:

SELECT ServerProperty('Edition'),

ServerProperty('ProductLevel'),

ServerProperty('ProductVersion')

and let us know what it returns.

-SQLBill

Open enterprise manager, right click on the group (default group is SQL Server Group) and select New SQL Server Registration.

-SQLBill

Are you doing this remotely or on the server itself? Somethings you cannot do in Enterprise Manager remotely. Anything that affects the server itself, usually has to be done...

Also, don't install the Client Tools on their system. That way they shouldn't have Query Analyzer available. And if they aren't an admin, they shouldn't have the ability to download...