Can't qualify table name

[CrystalTool]

Crystal 10

I'm using a command within a report that writes its results to a table. (Server SQL1 is production; SQL3 is development.) It works as long as the data location is SQL3 and it writes the table to SQL3. But when I try to run the report with the command on SQL1, and write the table to SQL3, I get: "The object name 'SQL3.contact.dbo.' contains more than the maximum number of prefixes. The maximum is 2."

When I try to SELECT * FROM SQL3.contact.dbo.tablename, that's fine. But statements like INTO and DROP TABLE give the qualifying error. Note that I do have write privileges on SQL3.

Any thoughts?

 

[synapsevampire]

Assuming a command means that you're pasting in sql, why not share the sql being used and the type and connectivity of the database?

-k

 

[CrystalTool]

Yes, it's an SQL command. Let's assume we're logged into SQL1.

SELECT * FROM employee_table
INTO [SQL3].area51.dbo.test_table

We think the problem is there needs to be a link between the servers.

 

[synapsevampire]

That may be true.

I'm guessing that you're using sql server? I'm guessing because I asked for this type of info and you promptly ignored it.

Good luck.

-k