Glad we could help. Thanks for the followup, but pls post in the original thread.

Steve Jones

steve@dkranch.net

Not sure MS likes this, but an intersting workaround. Thanks

Steve Jones

steve@dkranch.net

Not sure what you mean? Which records added by the user? In sysusers?

Steve Jones

steve@dkranch.net

If you read my series on Version Control, you will see that I have everything in flight. If a developer is testing something and hasn't scripted it or let me...

Yes and no. In v6.5, it is easier to work with the system tables, but it can be tricky. Is there a reason you don't do a restore?

You can...

Not a bad idea. One I hadn't thought of, especially since most databases only have a single target app. Might be easier to find them that way, though they'd be...

Views tend to be across tables, so a prefix doesn't matter. Personally, I like having the names of the objects associated with the table, next to the table in an...

You msy indeed have to set it twice, but you only do that when you code. The time to set this in code is pretty small. You could also write...

disageee with Andy on this one, but if you choose the DB, make it a separate DB from the data. Easier to backup and manage. Like the filesystem since you...

The package will run if it is run from a machine with the SQL2000 tools. The client tool DLLs are the ones that have these tasks. If you save the...

I've had luck with mapping drives under the SQL User and them being there when the server starts. I think the UNC method is safer, however.

Steve Jones

steve@dkranch.net

Only gotcha is you need to use the WITH MOVE option if there is any physical path difference.

Steve Jones

steve@dkranch.net

I'm not sure these are stored except in the compiled code.

Steve Jones

steve@dkranch.net

Intersting idea. Not sure I like this over my method :), but it's worth a look. Nice way to obfuscate things if you are delivering code to a customer as...

Not sure if any tools do it, though I suspect DBArtisan from Embarkadero will do this. Be easy to write a script to handle this based on table changes though.

Steve...