Viewing 15 posts - 4,981 through 4,995 (of 7,168 total)
As far as I know you need to reformat the disk.
December 27, 2011 at 11:53 am
I have had a perfmon counter log capturing several counters, one of which is Available Megabytes. I can show that the number remains steady through the PLE drops and...
December 27, 2011 at 11:29 am
Thanks, that helps. I have heard memory leaks in SQL Server itself are extremely rare at this point, however paranoia prevails at times so I am investigating. The consensus of...
December 27, 2011 at 9:40 am
You could certainly do that. Either way, whether SQL Agent or Windows Task Scheduler, I would favor PowerShell over VBScript in every conceivable use case.
December 22, 2011 at 10:04 pm
Perry Whittle (12/22/2011)
opc.three (12/22/2011)
Sure...but how would you copy the file (without xp_cmdshell)?Via a VB script ran as a SQL agent job step!
OK 😛
December 22, 2011 at 9:47 am
Perry Whittle (12/22/2011)
personally i find this easier to create the path
exec xp_create_subdir 'G:\somepath\mynewfolder'
or
exec xp_create_subdir '\\myserver\myshare\mynewfolder'
If the folder doesn't exist it will create it 😉
Sure...but how would you copy the file...
December 22, 2011 at 8:47 am
Sachin Nandanwar (12/22/2011)
Cant you just write a 4 line code VBscript in a batch file to create a folder and schedule it using windows scheduler ?
Just about anything would...
December 22, 2011 at 7:24 am
BTW, IMHO stands for In My Humble Opinion
PS BTW stands for By The Way
December 21, 2011 at 4:15 pm
I would strongly advise against trying to write a file from within a trigger. A more sound approach would be to:
1. Create a staging table to hold the data you...
December 21, 2011 at 4:14 pm
A more reliable way to find machines than using NET VIEW is to select directly from Active Directory. This post has a nice script I refer to from time to...
December 21, 2011 at 2:19 pm
Ed.Watson (12/21/2011)
December 21, 2011 at 1:06 pm
I can recreate the issue using the "Server Installation Settings" facet. I can use the ExecuteWql function using the "Server Information" facet however @EngineServiceAccount is not a property of that...
December 21, 2011 at 1:04 pm
There is no need to use xp_CmdShell here. You can do this using PowerShell directly from within your Job. In SQL Server 2008 a PowerShell job step type is available...
December 21, 2011 at 10:23 am
I think the OP may mean Triple DES which is typically abbreviated TDEA, not TDES.
You may be comparing apples to oranges but I cannot say for sure because I do...
December 21, 2011 at 9:50 am
Viewing 15 posts - 4,981 through 4,995 (of 7,168 total)