Comments
Sort by recent activity
I've got a lot of SCA PowerShell scripts that I use that I can add. It would be a useful resource. I like the idea of the rollback scripts. / comments
I've got a lot of SCA PowerShell scripts that I use that I can add. It would be a useful resource. I like the idea of the rollback scripts.
I have a assigned a local windows user account to run the service. It looks from what you say, as if SQL Clone will only work if all the resources, SQL Server and network, are within a Windows Domain. Is that correct? / comments
I have a assigned a local windows user account to run the service. It looks from what you say, as if SQL Clone will only work if all the resources, SQL Server and network, are within a Windows Doma...
I get the formatter to work happily if I comment out the '--At WSLSource;' so I reckon the bug is there. It isn't your source which seems fine. I have put an entry in sys.servers for WSLSource to test this.
GO
CREATE TABLE tmpRptInvoiceHistory
(
BookingNo INT,
ReportDate DATETIME
);
GO
DECLARE @sql VARCHAR(MAX);
SELECT @sql = 'Select 1,''1 Jan 2008''';
INSERT INTO tmpRptInvoiceHistory(BookingNo, ReportDate) EXEC(@sql); --At WSLSource; / comments
I get the formatter to work happily if I comment out the '--At WSLSource;' so I reckon the bug is there. It isn't your source which seems fine. I have put an entry in sys.servers for WSLSource to ...
Yes, the problem is getting it in one file. If you are handy with PowerShell, you can automate the process to do several databases on one server in one go. I give a link to an article I wrote to show how to do several databases on one server. As far as I remember, it is possible to extend the code to do several servers but each server would be written to a different 'site'. I hope that wouldn't matter! https://www.red-gate.com/hub/product-learning/sql-doc/how-to-document-multiple-sql-server-databases-using-sql-doc-and-powershell / comments
Yes, the problem is getting it in one file. If you are handy with PowerShell, you can automate the process to do several databases on one server in one go. I give a link to an article I wrote to sh...