Could you explain a bit about why you would do this?

Andy

I think you'll have to update sysjobhistory, I know of no built in proc to do it (though it might be there somewhere!) Not sure I'm thrilled with the idea,...

Views are very similar - really just a way to encapsulate a select that you'll be re-using a lot. Also tends to get used in those cases where there are...

Try select SERVERPROPERTY ('edition') for the edition, select SERVERPROPERTY ('numlicenses') to get the licenses, and select SERVERPROPERTY ('licensetype') for the license type.

Andy

As I recall it's a lot of work. You need to BCP it all out, generate scripts for everything, then drop db and device, then put it all back together....

Just to be on the safe side, please do not post entire code to MS procs. Paul if you still need it let me know.

Andy

We'll have to work on some links, I dont think we have much if anything. Not everything will convert, or even make sense to convert. Forms don't get moved, SQL...

If you're going to take the time to build the match key, index it. I keep mine in a separate table along with primary key it goes to. Nice narrow...

Try dbcc shrinkfile with the emptyfile parameter. This removes any data and tells SQL not to use the file further. You can then remove it.

Andy

That's a good start. But potentially you have the situation I mentioned earlier, the key somehow already exists on the subscriber and you're trying to insert it again - that...

Isn't Interdev loosely typed? Try declaring as variant.

Andy

Have you set a reference to the ADO library?

Andy

I've not seen a bug about this, have you checked MSDN? How/where are you checking for the duplicate key?

Andy

Can you post the DDL for the proc?

Andy

This might help:

http://www.sqlservercentral.com/columnists/awarren/introductiontoadothecommandobject.asp

Andy