Viewing 15 posts - 9,316 through 9,330 (of 59,078 total)
Hi, I am trying to use a text file to exclude a list of things.
WHY a text file? Without additional information here, I don't see the merit in...
May 10, 2019 at 1:04 pm
1. when I create an index in a table or views, is there any good way to konw (or evaluate) the index is necessary and correct?
Yes. It...
May 10, 2019 at 12:44 pm
Thanks, ZZ. What you wrote have been my findings, as well. I'm amazed the MS hasn't made PowerShell easier to use from SQL Server. I'm also amazed that they have...
May 10, 2019 at 12:22 pm
The four biggees (there are certainly more) that I can think of are...
May 9, 2019 at 1:47 pm
I'm hoping that's not actually a bad thing. 😉
Being able to turn the software off that's trying to keep your work device "safe" doesn't seem "safe". ;)...
May 9, 2019 at 1:19 pm
I didn't mean to be flippant with my response it just seemed like there was a lot of work being put into what seemed like relatively simple folder clean...
May 9, 2019 at 1:01 pm
2012
I know you didn't originally get the answer you wanted and we had a little fun with it but that's no reason to destroy your original post. That's also...
May 9, 2019 at 1:47 am
In case anyone else comes up against this problem, the solution for me was to make sure my destination was set to bulk load the table. In other words,...
May 9, 2019 at 1:45 am
It WAS working for me before on both places it is no longer working. I've not made any security level changes in FireFox or Chrome, either.
Maybe a...
May 9, 2019 at 1:42 am
Thanks, Sue. Thanks for confirming what I was seeing. As a bit of a sidebar, I don't even know how to do attachments on this site since the migration.
May 8, 2019 at 6:57 pm
Something is seriously wrong with my connections to SSC... I don't see any files attached.
@sue... are you seeing any? This might be associated with the same problem as me not...
May 8, 2019 at 6:45 pm
Totally agree with the XP_CmdShell thing. Of course, if you do that, you don't need PowerShell to begin with. Just create the file deletion commands directly from MSDB...
May 8, 2019 at 6:39 pm
p.s. I'm not 100% sure but I don't believe they've disabled the ability to turn ANSI NULLs off yet in 2017. It has been an advisory for many years, though. ...
May 8, 2019 at 6:21 pm
Heh... and people wonder why I hate case sensitive code. 😉
May 8, 2019 at 6:14 pm
I noticed in the article you linked to, SSC Guru, that SQL 2017 will not allow you to set ANSI NULLs off. If that is the case, how are...
May 8, 2019 at 6:10 pm
Viewing 15 posts - 9,316 through 9,330 (of 59,078 total)