Thank you very much for that explaination. Makes sense now.

No stored procedures? Then how do you program against the database?

I think somebody forgot to update the links [3] to [5]

A note from an european: After the twins were born, it has been 37.00 hours/week with one exception: the day I did a "Truncate Table" on my companys order table.

Best regards

Henrik

PS:...

Thank you very much, for these suggestions. I ended up "killing myself", and yes, there were stuff left behind on the server to delete. But I forgot what it was.

Just...

Thank you, Steve.

You mention read-only queries once or twice.

How would you go about creating a separate server for running reporting?

TIA,

Henrik Staun Poulsen,

Denmark

One advantage of the Sonasoft product is that it supports a mixed environment of SQL Server 2000 and SQL Server 2005. But the Sonasoft is a bit expensive.

Best regards

Henrik Staun Poulsen, MCDBA,...

Mike,

Thank you very much for sharing these functions with us. We have a SQL 2005 Server where the Levenshtein Edit Distance function may be useful. What are the chances...

I've seen this happen because a programmer had one "Begin Tran" too many.

When the user exited the program, all her changes were rolled back instead of commited.

I've had the same error message (guid should contain 32 digits). But not when moving packages, just trying to create a very simple Maintenance job.

It turned out to be cause...

I just had the same problem.

I had to enable DatabaseMail on the SQL Server Agent -> properties -> Alert System  (check the checkbox), and then restart SQL Server Agent.

It works now,...

Thank you very much for replying, but according to my BOL it has -1, 0 and 1 as values.

Where do you get your 0,1,2 values from?

TIA

Henrik

Great article, but I think you forget one thing:

What about xact_state() ?

I've seen somewhere (might have been BOL) that this code should work:

if (XAXT_State()) = -1 RollBack Transaction

But I'm uncertain...

Andy,

Thanks, I'm calling sp_add_jobschedule just above the sp_add_jobstep. But my question is probably not clear...

I'm after the contents of an envirronment variable, so that I can get the job to run at...

Thanks, but pkzip25 is not free? Is it possible to buy distribution rights?

I've looked at CNET and found 11 free tools. but couldn't see if they have a command line...