I'm sure it's faaaaaar too late to be useful, but I just came across this and figured I'd add my 2 cents. (note I didn't test it, and I'm curious...

Go me! I'm denser than usual, it appears. Thanks.

Admin: yes. There's 30 servers and a couple hundred databases I'd like to cover. Anything that requires clicking is, honestly, not...

Nice to see someone else working on DDL auditing via XE. Is it possible to get a copy of the code without the application? I can see how...

Okay, so is the example I gave aligned? The index is on a different filegroup, but still using the same Function. So technically it meets the criteria in...

Powershell for a decent bit of it. ...

That is _awesome_. Many...

(nevermind - forgot to read subsequent pages)

And? I'm reading the post looking for advice. And responding a year after you....

Honestly, step 1 is the hard part. The rest is a BULK INSERT or BCP of the file. I'm using Log Parser with success.

Was wondering the same thing, so spent a couple hours digging and came up with this. Not valid for all prod environments, but for regular transactional it should work....

Just making sure: 32-bit SQL, correct? I've not gotten it to work on x64.

I'd try something like this...

USE [msdb]

GO

DECLARE @jobId BINARY(16)

EXEC msdb.dbo.sp_add_job @job_name=N'start regsvr',

@enabled=1,

@notify_level_eventlog=0,

@notify_level_email=2,

@notify_level_netsend=2,

@notify_level_page=2,

@delete_level=0,

@category_name=N'[Uncategorized (Local)]',

@owner_login_name=N'sa', @job_id = @jobId OUTPUT

select @jobId

GO

EXEC msdb.dbo.sp_add_jobserver @job_name=N'start regsvr', @server_name...

I don't have anything, but remember that you can probably set up a SQL Server job to run on startup that run your regsvr command. That's not a fix,...

Check and make sure WMI is running properly. We were having a similar issue, and after restarting the server (not just the service) it worked. WMI appeared to...

Logshipping is definitely a worthwhile thing. I created some ultra-basic scripts (since I don't have the enterprise edition of SQL Server) that do the equivalent thing (look on comp.databases.ms-sqlserver)....