Viewing 15 posts - 1 through 15 (of 4,468 total)
I don't think you could have task scheduler open up SSMS and execute a job through SSMS but you really don't necessarily need to do it that way. You could...
October 15, 2020 at 3:26 pm
A couple of places to check - in the job, edit the step that executes the package and check the Package tab where the login can be specified and on...
October 12, 2020 at 6:05 pm
I've gotten the error on configuration issues before but it doesn't mean that's the issue. And you are right - there is little information on it and on some of...
October 5, 2020 at 7:18 pm
DTC is supported with Express but from the error it looks like the service isn't running or you haven't configured DTC - or both. Ensure the service is running. For...
October 1, 2020 at 11:59 pm
You don't have the error anymore so it's hard to say. I have seen it come up when statistics were out of date and that would be my first guess...
October 1, 2020 at 9:49 pm
Those connection errors could be firewall, could be proxy related...could be a lot of things. In terms of SQL Server, there were some issues with connectivity on Linux and I...
October 1, 2020 at 9:34 pm
You don't want to run them together to compare them the way you are comparing them though - it's just not accurate. And you want to be sure you really,...
October 1, 2020 at 9:31 pm
If you wanted to look at doing this programmatically, you could use the Web Services API. There is an article up here that walks through how to do that:
September 30, 2020 at 4:10 pm
You need to create an account first. Try using this link to start creating an account:
September 29, 2020 at 12:17 pm
Execution plans and the stats can look just like what you are seeing when you use option fast. And if you run the different queries together and see the costs...
September 29, 2020 at 3:19 am
Have you seen this post - old and not the same but similar so may be worth looking at the RegSrvr.xml file :
September 28, 2020 at 6:44 pm
You'll probably have to dig in a bit more before anyone comes up with some ideas on the issue. I'd check the MSdistribution_history and MSrepl_errors tables in the distribution database....
September 24, 2020 at 11:30 pm
There is no supported procedure to change those - dropping and recreating with the updated information is the supported method. I would guess you could hack the system table to...
September 24, 2020 at 10:22 pm
If the history isn't available in sysjobhistory you'd have to do something like find old backups of msdb that would have the history and restore them on a test, dev,...
September 24, 2020 at 5:55 pm
You can skip the first part and just install SP3 and the latest CU for SP3.
September 24, 2020 at 5:35 pm