I'm of a similar opinion. I think much of what we use, should be, and is in many cases, a tool. A commodity. The closest analogy I can think of...

Try the dotnetnuke framework. Pretty complete, we use it for Database Daily and it's got lots of add ons.

http://www.dotnetnuke.com

Please contact the person in the post above if you are interested.

I agree that the server name in a linked server doesn't have to match, but it gets confusing quickly if it doesn't. It's one thing if you have 5 or...

I agree with Brian. You may be able to do some sort of repair, but likely there is corruption on that box. I might take it offline ASAP to be...

Does it happen from every client that accesses the server or just one?

Sorry, lacked creativity this day, but since I'd just used this function, it was a nice one to me. I'll ask Imceda if they wouldn't mind posting the documentation.

I agree with that. Outside of my banking sites and the place that prints business cards with an ActiveX designer, I think pretty much everything works with 1.0.

I think we may agree to disagree here. I have searched numerous places on the web for the definition of a query and the results are all over the board,...

The answer has been changed to dbo and points awarded back.

When you're sneaky

Darius,

Somewhat correct.

The point is that the idea that you'd go chanding things, fixing bugs, etc. to make it work better is a fallacy. There might be a few people...

You can periodically cycle the logs without rebooting. sp_cycle_errorlog or something like that will work. I had a server that never went down and we had the same issue, so...

correct, you do need to drop the assembly, but not the function.

Thanks for the reference above.

Very nice Frank. I'd be willing to work on your code if you need help