Viewing 15 posts - 421 through 435 (of 1,988 total)
ZZartin wrote:You can explicitly deny write access to his specific login.
Wouldn't that also (badly) affect his rights in GP?
Yeah the deny on his personal login would trump...
May 17, 2019 at 7:21 pm
You can explicitly deny write access to his specific login. You could also create a SQL login with read only access and use that for his ODBC connection instead of...
May 17, 2019 at 7:11 pm
It sounds like someone reseeded the identity to a lower value, you should probably check who actually has access to do that in production.....
May 14, 2019 at 8:47 pm
The the identity will start to break when it catches up with where the values actually are(if it's not already breaking) although check ident should fix it.
May 14, 2019 at 7:40 pm
It's possible someone deleted some values out of the middle of the identity then reseeded it. Or if you don't have a unique constraint on that column someone might have...
May 14, 2019 at 6:51 pm
I'm still curious, though. Is there a way to call your good line of PowerShell from a stored proc OR a job other than using xp_CmdShell or a PoSh job...
May 9, 2019 at 10:53 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 up. ...
May 8, 2019 at 8:11 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 backup...
May 8, 2019 at 2:51 pm
Why are you trying to do this in SQL, this is something that's extremely trivial in powershell, as in 1 line of code.
(Get-ChildItem -Path ("C:\Test\*.txt") | Sort-Object -Property LastWriteTime -Descending...
May 7, 2019 at 4:07 pm
Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me?
I encountered this code...
May 2, 2019 at 1:44 pm
I only asked the question on here to see if it could technically be done, I did not ask for your opinion on the inner workings of my company....
April 30, 2019 at 3:54 pm
That seems like it would be over kill if you don't need real time replication just for reporting and an etl job would make more sense. But if you do...
April 25, 2019 at 5:40 pm
Why are you trying to add the header in SQL? There's an option in SSIS in the flat file connection to add a header row with column names.
April 19, 2019 at 7:07 pm
Tell your boss or manager or whatever but make sure you have a good understanding of actual impact before you do. That conversation can have a very different tone if...
April 18, 2019 at 2:28 pm
Keep in mind if that CTE returns more than 1 record you might get some unexpected results.
April 15, 2019 at 8:48 pm
Viewing 15 posts - 421 through 435 (of 1,988 total)