Viewing 15 posts - 1 through 15 (of 320 total)
As you mentioned, if we need to setup some test data, we'll have to do that inside the code called by the CLR... AND remember to roll this back.
August 19, 2022 at 10:16 am
September 24, 2018 at 11:21 am
Not much as far as I know.
We just log a few details we think relevant, that's all.
For the rest, we use the built-in reports
September 24, 2018 at 8:40 am
September 18, 2018 at 2:27 am
"Unfortunately", we don't seem to have much updates going through the system now...
Would the output still be useful?
September 17, 2018 at 5:03 am
I'll do that next week because I have just created another log file (on a different drive) and shrank the original (which I'll delete when it becomes inactive).
September 14, 2018 at 9:30 am
I was "assuming" pages are entirely copied to the log (before and after)
For the columns, here it is
CREATE TABLE ... ( [FactDPRetailerMonthlyId] INT ...
September 14, 2018 at 8:46 am
There is a Clustered Index on a composed Primary Key plus a non unique index on a timestamp (Datetime)
September 14, 2018 at 7:41 am
VERY helpful (as usual!)
July 20, 2018 at 5:38 am
If you have this off hand, could I ask the syntax for a single project, please?
July 20, 2018 at 5:24 am
Now, I think I understand the Publish side.Once I have a dacpac file, I can publish it through SQLPackage.exe or Powershell. I think that aspect is fine.
July 20, 2018 at 3:12 am
Thanks for your help folks, it was indeed that user having removed access to admin users (BuiltinAdminsAreServerAdmins) and it was fixed by amending the ini file
June 13, 2018 at 10:13 am
June 9, 2018 at 2:01 am
June 8, 2018 at 8:42 am
>> Eric, did you run SSMS as administrator ON the server itself? or on your workstation?
On the server itself
June 8, 2018 at 4:24 am