That depends entirely of the life preceding death... -- Ich bin Joachim von Hassel, und ich bin Pilot der Bundeswehr. Welle: Erdball - F104-G Starfighter

Because they can :-D. Doesn't bother me because I don't worry about popularity contests and I think no one here cares about the voting other than on articles! :) Yes, I program in VB, but only to feed my addiction to a warm place to sleep and food to eat! Visit my Code Project blog (Mobile Audio project)[^]

The EU has directives in place on this and our company was one of the three behind ISO14001, about impact of manufacturing on the environment. The tigress is here :-D

Marc Clifton wrote: Almost makes me wish the responses were at the top of the article page, not the bottom! Wouldn't that be what the rating was design for :) Of course it helps if you are not the first one readying it... Rocky <>< www.HintsAndTips.com www.GotTheAnswerToSpam.com

We were using their advance plan ($9.95/mo, SQL 2000 inclusive) for about a year and didn't have any problems, support was also very good. I have been warned about the "unlimited bandwidth" thing too, but we had anything from 5GB to 40GB per month and everything was working fine. I think that they would probably suggest moving to a dedicated server if you would be getting too much traffic. Anyway, I can only recommend their service. Rado Radoslav Bielik http://www.neomyz.com/poll [^] - Get your own web poll

Thanks for the help. I redefined the method as static and had to remove the lock code. Can you explain what the lock command does? Regards, Eric C. Tomlinson Yes, I program in VB6, but only because I use it to fill my addiction to having a dry place to sleep and food to eat!

Yes, as Elbert said, it is possible. I wanted to add that, like classes, you should actually declare public properties that reflect private fields in your structure. This not only gives you a chance to validate input (always a good idea) but also to invoke delegates if necessary since properties are just getter and/or setter methods. You can still do it with fields, but it's quite a bit more difficult. Microsoft MVP, Visual C# My Articles

I used to keep one of those really thin sleeping matts that you can roll up under my desk for just that situation. Divert the support line to your mobile, set ringing volumn to max and your all set for a good days sleep.

This is what I finally determined that would work. Wish things like this were easier.

I know what you mean...I remember getting that feeling maybe about 10 years ago...hope we get that more often and still value it. Regards, SRT

So basically read the drive to determine/set the type of disk. I suspected this but was hoping you could query the system about it after insertion of the disk. I'm going to override the autoplay for certain types of files. Thanks again Heath for the short sweet answer and the good point in the correct direction. Regards Eric C. Tomlinson No comment, Mr. Senator

If that function is a direct cut-and-paste from Enterprise manager, there's a bug in it: "Server: Msg 245, Level 16, State 1, Procedure RuntimeSort, Line 10 Syntax error converting the varchar value '/' to a column of data type int." **Edit** I see the problem. You have DATEPART() + '/' DATEPART returns an int, which you are NOT casting to a varchar. So, when you try to add '/' to an int, it tries to auto-cast the slash into an int, and the function bombs. To answer your original question, however, the proper method of defining the formula is dbo.RuntimeSort(date1, date2). You MUST provide the object owner, as well as the object name, and ALL parameters. UDF's on SQL Server 2000 don't support default parameter values like stored procs do. Grim (aka Toby) MCDBA, MCSD, MCP+SB Need a Second Life?

Thank you Heath this was extremely helpful. No comment, Mr. Senator

I'd go with Heath on this. As a little tip, if there is anything in the documentation that I don't quite understand I build myself a little demonstrator application (5 minutes work) to test my interpretation of the documentation. That way I can see if it works the way I think it does or not, and if not I now have a test platform to work from to see exactly how it is working. I hope this helps. "You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar Coming soon: The Second EuroCPian Event