Duplicate row using trigger

I have a database with a table that stores details about a computer base unit. This can be identified using a unique ID which is stamped on the top of each case.

Sometimes an old PC gets replaced with a new one, but the old monitor etc. are retained. It would be good to have a way of duplicating a row so that the records for the monitor etc. are updated to use the new unique ID. However, it would be good to have a copy of the old base units details copied into a record with its ID number.

I was thinking about doing this via. a trigger, does anybody have any better suggestions about how this may be done?

Thanks,
PaulU can use flag separate for identifying old and new.
depending on this u can use auto-incremented values each time.

it will be better if u can send me some sample data so that i can give u a better suggestion.

dumb question

Just bought a new computer, and want to install vb express. There is an icon in my system tray for Microsoft SQL Server Service Manager ver. 8.00.2039. Does this mean that I won't have to install SQL Server Express? I can't find anything in the Add/Remove programs that shows any version of SQL Server that was pre-installed.

thanks

richard

Hi Richard,

You have SQL Server 2000, probably MSDE. You will want to have SQL Express for tight integration with VB Express. I would go install SQL Express from http://msdn.microsoft.com/vstudio/express/sql/download first, then install VB Express. VB Express will offer to install SQL if it isn't already there, but it is the RTM version, not SP1.

Mike

dtswizard login problem?

Hey, i'm trying to use the dtswizard.exe program in MS SQL Server Express 2005 to move a database from one computer on my home network to another.

- Both SQL servers are using Windows Authentication.

-I've turned off all firewalls

-I've done all the Surface Area Config stuff and enabled both types of remote connections

But i'm still getting a "Login Failed for user 'BASEMENT/Guest'. (Microsoft SQL Native Client)" error.

Any ideas?

Thanks!

There is no DTS in Express and why are you using the guest account SQL Server's guest account is off limits to human users because SQL Sever services use it. Problems with the guest account can make your SQL Server shut down. And in one network the normal way is to register one with the other so you can manage both in one place. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

|||

There is a DTS, it's just hidden (C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe).

Is there some documentation somewhere for how to do this register thing??

|||Try to add the BASEMENT\Guest account to the SQL logins on both SQL2000 and SQL Express.|||

I'm not using SQL2000. Both computers are on express...

|||

Sorry for misunderstanding, but you can try the same thing on both SQL Express. You can download Management Studio Express to manage your SQL Express Servers:

http://msdn.microsoft.com/vstudio/express/sql/download/

|||

Ya i have that already. I can see both SQL servers through that. But when i try to access the remote one i get a "login failed for user" error. They're both using Windows Authentication, perhaps this is a problem?

|||

I tracked down the detailed error message, not much more help:

"Valid login but server access failure"

|||

There is no DTS in Express a lot of needed components is not in Express, you could use the eval version of the full one then buy the developer edition it is under $40. Try the link below for a full comparison of all SQL Server editions. Hope this helps.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

Ya it is, i'm using it as we speak.

Figured it out. Right click on the Management Studio (on the remote machine), right click on the database, pick permissions and grant them all to the public login. Not sure how secure this makes your database, but since it's just for testing anyway...