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

Greg has the three ways to do this. #1 is the quickest way in a disaster, but #3 makes more sense since packages become corrupt and you wouldn't want to...

I heard this in a NetIQ lecture a couple years ago as well. There are two things at work. One is the fragmentation problems as well as the greater likelihood...

Age and treachery will always defeat youth and exuberance.

It would be nice to see photos, but not everyone wants that. Many people don't want to be recognized, so we don't...

Not sure, might try http://www.justsqlserverjobs.com/. I'd guess you're less expensive than Denver. I'd say avg $70-75k here.

http://www.microsoft.com/sql/2005/

No good one I know of. There are some white papers here (http://www.microsoft.com/sql/2005/) and lots of Webcasts this week from Microsoft (see http://www.databasedaily.com)