Menu

Want to work with us? We're on the lookout for a UX/UI Designer and Digital Project Manager.

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.