Viewing 15 posts - 616 through 630 (of 39,717 total)
Did you run it as a batch or line by line?
As a batch, this doesnt' work.

August 16, 2024 at 5:36 pm
Time is THE most valuable resource.
When my third child came along, I gave up watching whole football games...
It's funny, similar to me. Stopped watching many sports when they were...
August 16, 2024 at 4:01 pm
I do wish more devs were secure by default, even if that limits options or prevents upgrades of existing code. I'd like to see them refactor the code and use...
August 15, 2024 at 2:24 pm
Crazy that there are still 3rd parties being included in modern code with this issue.
August 14, 2024 at 5:00 pm
A lot of people want to do things themselves, or they don't necessarily trust others for advice. Certainly some cultures also pit people against each other, so they won't help...
August 13, 2024 at 3:05 pm
If you watch the video, there are a lot of telemetry things. I don't think they send any video, but these stores might not have great bandwidth anyway.
August 12, 2024 at 6:18 pm
Thank you for this article. I am struggling with a much, much smaller problem. I am pulling the log data from one SQL Server to a central database. The...
August 9, 2024 at 6:37 pm
At present we use cloud provider specific solutions for logging, metrics and traces.
...
In terms of tooling we are interested in https://www.honeycomb.io/ which was founded by Charity...
August 9, 2024 at 6:34 pm
Not sure what I was thinking. Points awarded back and the answer changed so there are just 2 to pick
August 5, 2024 at 2:32 pm
Learning is a bit part of my life. Neat to see my kids still trying to learn things, post uni.
For me, would have to be basketball or baseball. Enjoyed both...
August 5, 2024 at 2:50 am
I saw a note to try: sp_replrestart here: https://www.sqlservercentral.com/forums/topic/the-process-could-not-execute-sp_repldonesp_replcounters
Also: https://repltalk.com/2010/02/19/the-process-could-not-execute-sp_repldonesp_replcounters/
August 2, 2024 at 4:36 pm
First, SQL Server doesn't do anything with prompting. That's SSMS or your IDE. Everything submitted to the SQL Server instance is code. If you are in SSMS and use the...
August 2, 2024 at 4:33 pm
Not in query analyzer. Might have been in Enterprise Manager, but I can't remember.
August 2, 2024 at 4:09 pm
Have not used this in a long time, but examples don't show quotes: https://learn.microsoft.com/en-us/sql/tools/ssbdiagnose/ssbdiagnose-utility-service-broker?view=sql-server-ver16#examples
August 1, 2024 at 10:38 pm
Viewing 15 posts - 616 through 630 (of 39,717 total)