Suspect that Antares is correct.

agree with Frank. Don't do it. Why do you need to know?

When you say PD and PT at the end of file, do you mean 2 lines that are repeated for everyone or two lines for each user?

If there'd the same,...

Joe,

If you run this interactively, does it return more data? Is the limit 71 total or per database (so 71 x no of databases)?

In EM, just change the name of the database in the dialog box.

It has been corrected. That was a typo.

Interesting on the comments. Since some things are multiline, like a dscription of a proc, the /**/ is handy so you aren't editing around --s all day.

My tendancy is to...

Or perhaps go back to school and choose a new field?

Nice comeback.

Where are you located? In winter, I'd head for Colorado (I live there) to ski or maybe the northwest. Ever been to Whistler?

If you want sun, then I like the...

I think replication could help here. Is this bidirecitonal synch?

The other thing might be to bulk pull a bunch of the data into the parent server and stage it, then...

What other operators are you using? Do you have the same indexes on all three tables? It's possible there is a bug here. The distributed views are a 1.0 feature...

Definitely don't want that. Good advice to your boss, though I'd check a few backups and restore them on another server or this one as a test.

Are you writing to...

First, you really need to apply the service packs. Lots of bugs and issues are fixed in them. Sp3a is the latest.

From there, definitely more details are needed.

Also, are you initializing a new file? Might be a disk filling issue, though I doubt it.

I'd check to see that something else hasn't been scheduled to run at the...

Not sure what esqlc is, but can you do this:

EXEC SQL EXECUTE aek_proc1 :p1, :p2 OUTPUT, :p3 OUTPUT, :p4 OUTPUT;