587 reputation
210
bio website meltondba.wordpress.com
location Montgomery, AL
age 35
visits member for 3 years, 9 months
seen Feb 10 at 3:29

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


Feb
8
answered Power shell script to fetch disk space on all servers in timely intervals
Feb
5
comment Power shell script to fetch disk space on all servers in timely intervals
This script looks familiar. You should give credit as to where you got it from unless you wrote it. Up to you.
Dec
24
comment How to protect SQL Server from Hackers
If this question is about Windows firewall then it should be moved the SF.
Jul
16
awarded  Revival
Jan
17
comment SQL services wont start due to incorrect drive letter after windows restore
If you reinstalled windows, why not reinstall SQL Server? Trying to manually repair SQL Server can bring up problems down the road. It is best to do fresh install of SQL Server and then restore your databases (both system and users).
Dec
31
comment SQL Agent Powershell Job Failing with Non-Admin Proxy
I only ask that because the permission problem might be with the command you are performing, not just executing the script itself. If you put a test script in place that just calls Get-Process or something does that run succesfully?
Dec
31
comment SQL Agent Powershell Job Failing with Non-Admin Proxy
Just to make sure what is the first line in your script?
Dec
28
comment SQL Agent Powershell Job Failing with Non-Admin Proxy
How are you calling the script within the Job Step?
Dec
28
comment SQL Agent Powershell Job Failing with Non-Admin Proxy
The script that you want to execute from SQL Agent has to be accessible by the service account that the SQL Server Agent is using. So if you want the script to reside on your system, seperate from the SQL Server instance, the account has to have access to your system and the directory.
Nov
13
comment sqlcmd won't execute - Claims Native Client not installed properly
Cross-posted question from SO, has some good responses already for the problem: stackoverflow.com/questions/5083189/…
Nov
9
comment How can I connect to my ACT database to export data?
What version of SQL Server 2005 are you working with? The master.mdf is not the application database, that is a system database for SQL Server.
Oct
31
revised MS SQL Server DB version without restoring?
added 640 characters in body
Oct
31
answered MS SQL Server DB version without restoring?
Oct
15
comment Missing menu items for Azure SQL tables within SQL Server Management Studio?
Might check this question: stackoverflow.com/questions/4652665/…
Sep
23
comment Can only connect to sql server express 2012 via named pipes
Might look at this question: stackoverflow.com/questions/11278114/…
Sep
14
comment Getting network interface device name in powershell
Have you tried Win32_NetworkAdapterConfiguration
Sep
12
comment How can I uninstall SQL Server Express from Windows Server 2008?
SBS 2011 comes with Window Server 2008 Standard Edition.
Sep
12
answered How can I uninstall SQL Server Express from Windows Server 2008?
Jul
30
answered SQL Server Backup days
Jul
30
comment SQL Server Backup days
Screenshot of what the Action looks like configured: blogs.technet.com/cfs-file.ashx/__key/…