Viewing 15 posts - 31 through 45 (of 136 total)
Startup option -n
Does not use the Windows application log to record SQL Server events. If you start an instance of SQL Server with -n, we recommend that you also use...
March 9, 2018 at 12:50 pm
Is it possible that the database it was selected to run against has been renamed or removed? Try opening the job step and reselecting the database you want and rerun...
March 8, 2018 at 2:59 pm
If it's not the backup, there's probably something else running that's preventing a timely connection. One option you might try is creating a new job to run the package and...
February 27, 2018 at 3:26 pm
February 27, 2018 at 9:11 am
You should really post in the area of the forum appropriate for the version of SQL Server you're running. You've posted this topic twice and neither time has been in...
February 26, 2018 at 2:58 pm
You can check the default trace if it happened recently enough. This query (stolen from RedGate) will work.
SELECT TE.name AS [EventName] ,
v.subclass_name...
February 23, 2018 at 11:16 am
February 23, 2018 at 6:48 am
February 22, 2018 at 3:04 pm
February 22, 2018 at 2:29 pm
It's interesting to me to hear how other people start, so I'll do my part to keep this thread alive...
I had zero intention of being a DBA, but...
February 22, 2018 at 2:26 pm
So the job ran every time up until 2/21? And you confirmed that the job wasn't already running at that time? Is the schedule for the job enabled (disabling the...
February 22, 2018 at 1:53 pm
When...
February 22, 2018 at 1:30 pm
Nevermind... this was dumb 🙂
_________________________
We're on 2016 right?
Using the sample table.SELECT REPLACE(FORMAT(CAST(column1 AS FLOAT),'N0'),',','|') FROM dbo.MyTable
February 8, 2018 at 2:37 pm
Here is the code I am trying:
...foreach($RowDelete in $resultsDatatable)
{
echo "Inside For...
January 4, 2018 at 8:44 am
December 19, 2017 at 8:41 am
Viewing 15 posts - 31 through 45 (of 136 total)