the rows affected can be removed by running the command "SET NOCOUNT ON" at the start of the SP.

As for the date/time issue, that is Excel taking the date and...

My only thought there is that your bat/ps1 file is not 100% identical to your command. To me it sounds like the bat file or ps1 file is not running...

I'm not sure what you mean by "moving onto the next table" but looking at your script, I suspect that your script is running and never ending, right? Your while...

I can only think of 2 reasons for this. First is permissions - are you using the same account to run the bat/ps1 file or are you changing accounts and...

Might just be me, but is sounds like you are trying to reinvent the wheel. What you are asking for sounds a LOT like a document control tool to me....

Just wanted to add that this isn't a "microsoft defect" as it is the job of the DBA to make sure things are properly sized. I wouldn't blame DELL if...

I think the only way to do this entirely in SQL Server would be with "REPLACE" statements (ie replace <br> with a newline character) and after replacing everything you want...

My first step would be to reach out to your IT dept to see what URL they are trying that is saying that HSTS isn't enabled and verify that the...

Quick google of the answer brought me to this blog post by Pinal Dave (super smart guy!):

https://blog.sqlauthority.com/2017/02/13/sql-server-fix-error-19456-none-ip-addresses-configured-availability-group-listener-can-hosted-server/

That tells you how to fix it, but to quote what he has in...

To add to what Grant said, I would also like to know why you think that is a "common database maintenance task"? My opinion, database maintenance tasks include things that...

I've not set something like that up before, but I'd try taking different things out of the equation. Can you query it without using powerBI? or is it slow if...

My first step would be to check the MS documentation - https://learn.microsoft.com/en-us/sql/relational-databases/replication/troubleshoot-tran-repl-errors?view=sql-server-ver16

But in your specific use case, I think you are stuck between a rock and a hard place. If...

To play Devil's advocate, I would say it really depends. If you are currently employed, what does your employer use? I know at my workplace, we are not using SSAS...

We have a policy at our company that the C# code must call stored procedures to get or manipulate any data. It gives us better tuning opportunities and allows us...

I agree with Jo Pattyn - this looks like a duplicate of that other question and my advice is still the same. If you want to track changes, you need...