Viewing 15 posts - 91 through 105 (of 972 total)
Eric M Russell (10/6/2015)
Symantec Endpoint Protection
Web Attack: Malicious Website Script
Redirect 16...
October 6, 2015 at 1:58 pm
Verify the OS permissions for SQL Server and SQL Server Agent service.
They specifically need "Replace a process level token" to allow you to deploy to the SSISDB catalog.
October 5, 2015 at 8:02 am
I can probably tackle this rather quickly. I already did part of this for a client last week, minus the alerting it was just to capture failed logins.
September 25, 2015 at 1:43 pm
Well Tue code you pasted in is missing the closing bracket of the loop. If that is not in the script.
September 17, 2015 at 8:09 pm
Remove the "[parameter]" unless you are going to set any advanced parameter attributes. This is likely why the ParameterAttribute data type is being forced and errors.
September 17, 2015 at 7:43 pm
If your variable is passing in a string, meaning when I set the value of the variable I wrap it in single-quotes, then there is no need to put the...
September 17, 2015 at 8:08 am
Depending on what version of SQL Server 2012 installation media you have access to it can include an option to install BI Tools, but the version of Visual Studio it...
September 12, 2015 at 9:30 am
The link to SQL Saturday that Grant provided includes his Twitter handle. You can hit him on Twitter and just link to this post for reference.
September 1, 2015 at 9:37 am
vsamantha35 (8/31/2015)
Thank you. Again, just checking if there is a script which can script out all the Linked servers for a SQL instance at 1 go?
Yes that process can be...
August 31, 2015 at 12:08 pm
I have never seen a method that allowed for you to pull that password as you can with logins. However, I did come across this post where someone figured it...
August 30, 2015 at 6:45 pm
Well I can duplicate your issue when I restore the full, leaving the database as NO RECOVERY and then attempt to restore the differential backup.
So I recovered the database again,...
August 24, 2015 at 11:03 am
IIRC if you want to restore a database with a differential you would add the full AND differential files into the device window of the GUI. It has to see...
August 23, 2015 at 5:26 am
Just a note, and strictly personal preference with a bit of just best practice...use of "Add-Member" is a PowerShell 1.0 way of doing it. In 2.0 and higher you can...
August 23, 2015 at 2:00 am
deploying multiple scripts in different servers in parallel using multi-thread?
In PowerShell 3.0 you can utilize PowerShell workflows to run multiple task "in the background" to execute and run. I would...
August 23, 2015 at 1:26 am
If you pass the username and domain in the usual format DOMAIN\User (and have the password of that user), then yes you could. It requires you to run PowerShell.exe under...
August 23, 2015 at 1:10 am
Viewing 15 posts - 91 through 105 (of 972 total)