Comments
Sort by recent activity
Unfortunately, I don't have access to the code. This is a 3rd party application and the vendor is unable to tell us what changes are made to the master database. It appears to be all data inserts, but unfortunately it doesn't appear that SQL Data Compare is able to read/compare data in the "sys" objects.
At this point, it seems my only option is to dig through the trace and see what queries were run. / comments
Unfortunately, I don't have access to the code. This is a 3rd party application and the vendor is unable to tell us what changes are made to the master database. It appears to be all data inserts...
I did have a trace running and it appears that only custom error messages were added to the sys.messages table. Here are a few snippets of what I've found in the trace so far. Ultimately, I just need to make sure that the system databases weren't affected in a way that might have a negative affect on the other application databases on this instance. --drop custom error messages
declare @dropsql nvarchar(max)
set @dropsql = ''
select @dropsql = @dropsql + 'exec sp_dropmessage @msgnum=' + cast(message_id as nvarchar) + ' ' + char(13) from sys.messages where message_id between 50000 and 70000-1
exec sp_executesql @dropsq
select @x=count(*) from sys.messages where message_id = 50100;
if (@x=1) exec sp_dropmessage 50100
exec sp_addmessage @msgnum=50100, @severity=16, @msgtext=N'parameter cannot be null: <%s>'
/ comments
I did have a trace running and it appears that only custom error messages were added to the sys.messages table. Here are a few snippets of what I've found in the trace so far. Ultimately, I just ...