Menu

Want to work with us? We're on the lookout for digital experts.

We're hiring

Updates sysmessages table

Web Bureau


27 July 2011 by Web Bureau

Updates sysmessages table with new data imported into another table :

 

 

SP_CONFIGURE 'ALLOW UPDATES', 1

GO

RECONFIGURE WITH OVERRIDE

GO

INSERT INTO sysmessages (error, severity, dlevel, description, msglangid)

SELECT   error, severity, dlevel, description, msglangid

 

FROM    sysmessages2$

 

SP_CONFIGURE 'ALLOW UPDATES', 0

GO

RECONFIGURE WITH OVERRIDE

GO

Grow your businessStart a project with us today.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.