Viewing 15 posts - 1 through 15 (of 42 total)
If you can use VS to import the data - why do you need to use the import wizard? BTW - the import wizard is not going to use a...
April 22, 2022 at 6:49 pm
Technically yes, I can open them in Visual Studio, but I cannot use this option at this time, as I am connecting to an Excel *.xlsx file, but unfortunately I...
April 22, 2022 at 2:05 pm
To the first point, there's a good reason you can't kill a ROLLBACK -- because that could corrupt your db.
To the second point, that should be a...
April 18, 2022 at 6:58 pm
Actually, overall, this is one of the best places I have worked. I have been remote long before COVID. I won't find anything close to the salary anywhere near where...
April 18, 2022 at 6:45 pm
Please understand, I am not trying to be rude here, but we have done all that analysis and presented the evidence to the 3rd party team as to the causes...
April 18, 2022 at 6:21 pm
We have something like that running that captures all queries being executed on the server.
April 18, 2022 at 4:38 pm
My apologies, but I "mostly" understand.
To a team that only knows the name "DB1" to which to push the data, we would do the following:
1). Create two databases. DB2, DB3.
2). ...
March 30, 2022 at 5:08 pm
Phil:
"So there's no chance that one of the files could contain bad data?"
To answer that question, I cannot say there will "never" be bad data, but as long as this...
March 28, 2022 at 5:23 pm
I understand the risk. This is a stop gap until I can rework the SQL Job to avoid it. The reason it would fail is due to server load and...
March 28, 2022 at 5:06 pm
We get files that need to be imported daily into our SQL Server because we do not have direct connections to import the data. The import of each file is...
March 28, 2022 at 2:48 pm
Jeff:
Thank you for that. It provides some of the information, but I guess what is really needed is a way to tie those logs to a certain user / login. ...
March 3, 2022 at 7:42 pm
Thank you everyone for all the help / suggestions but I found the issue. For some odd reason, my "main" table didn't have the correct column counts. I counted numerous...
November 11, 2021 at 10:33 am
I have not thought about that, I was just going by record counts shown for each table. I will look into this and see if I can find anything along...
November 8, 2021 at 5:41 pm
Phil:
I understand and just very appreciative of all the help you always provide.
October 20, 2021 at 11:10 am
Phil:
After playing with that query, I notice it gives me all the "Step_Names" as being "(Job Outcome)" and the Job_Descriptions are all of the job itself, but not the step...
October 19, 2021 at 5:50 pm
Viewing 15 posts - 1 through 15 (of 42 total)