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;

I use Bill's method. There really isn't a good integration anywhere. The thing that I'll do when files get big is kill the older versions within the file since I've...

Not clear, can you log into both nodes manually and execute the job? Curious if it works manually and fails when schedules or always fails.

Thanks to everyone for their support and comments. The three of us really appreciate it.

Last year, 2003, was Vol 1, this year, 2004 was Vol 2 and Vol 3 is...

Part 2 coming Thursday, so keep an eye out for that. Thanks for Wes for this comparison.

Try this: http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24