There is a difference between doing server side validation and worry about the error messages. I agree with Steve - just map the sql errors to your own message. With...

No idea. I've only got SQL2K installed, I emailed Jon Winer to see if he had any ideas, he has done quite a bit of work with FTS. Are you...

I like your first solution, the one where you concatenate the 'drop table' with the table name - quick and dirty, but effective.

We'll have to agree to disagree about cursors,...

Hey LenE,

Sorry that no one responded to your final comment, and thanks for letting me know.

As far as the indexes, you may be right, but really it depends on how...

Just tried, it didn't save out when I saved as a VB file, I don't see it in the object model either? Weird.

Andy

Im glad we could offer some comments then. I hope you'll visit again, we manage to have some interesting discussions!

Andy

You can include use ? in your passed command.

Andy

Thanks to all for their comments so far. I can see where "better" tools might help, but I'd still vote against. Mindy, your comment about not being able to "borrow"...

Paul - Im not sold on DTS, even though I use it a lot for moving data around. I think at some point you hit the wall and have to...

Using a view is usually a good way to package something like this, but achieving it can be fairly difficult. If you have only one child record, then a simple...

A geeky thing indeed! Now there are 2 of us, are there more who'd like to join this rebellion?

Thanks for the feedback!

Andy

Use of identity columns (or any other contrived key) certainly has it's foes - and I'll agree that each side has it's proponents. What I tried to do..and evidently failed...was...

Take a look at the datediff function, may give you what you need. If not, post more details of what you're trying to do, we'll try to help!

Andy

You could look at using instead of triggers in SQL2K to avoid the overhead of rollback. If you're doing your validation on the client, is it really critical that your...

Basically you have to add a login using sp_addlogin, then add the user to the database using sp_grantdbaccess. After that you need to add the user to whatever roles may...