I have none!

What SQL Server version and SP are you running?

Did you create the maintenance plan via the wizard?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

okay, a brainteaser for lunch time.

What does the job do?

Who owns it?

What steps are taken?

The steps are taken as which db user?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

The first mail came in right now. Also the site seems to be faster now.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Stupid question, but is the job activated?

Any entries in the job history?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

For this purposes I strongly suggest trying to follow open source code from mysql and/or maxdb. Not easy to get an entry point, but great way to look behind the...

Not really

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, I do.

With writing your own extended stored procedure you only extend to functionality of SQL Server, not the built-in functions.

I see no chance for you.

What aggregate function do...

And hopefully some day I'll see the forest from the trees

http://www.sqlservercentral.com/columnists/glarsen/sequentialnumbering.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Learn each day something new!

Edited by - Frank kalis on 12/09/2003 04:38:13 AM

For me it isn't working at all right now

Frank

http://www.insidesql.de

http://www.familienzirkus.de