Activity overview
Latest activity by dtaylo4
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 ...
Compare master database sys tables
I recently had a software installation that required access to the system master database because of data inserts that were required. This is the first time I've come across this requirement and a...