Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert trigger on Sharepoint database table

Status
Not open for further replies.

Arsi4061

Programmer
Nov 12, 2004
3
US
Hello,

I have created a trigger on the UserData table of MS Sharepoint Portal Server. It is supposed to insert info into another SQL server database within the same server when new information is inserted in the UserData table. My trigger has been tested and it works on databases not using Sharepoint to enter information.

This is the error I get after I click "Save and Close":
The list could not be added because the length of the fields was too long. Please shorten the new entries or remove some fields from this list.

Not all the information entered through the sharepoint site is going to be inserted into the second database. At first I thought it might be the length of the fields given at design time to the second database, but once I fixed that, it did not make a difference. I still receive the same error. If anyone can help me solve this problem I would greatly appreciate it.

Thanks,

Arsi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top