Gosh, that seems like a lot of code to move the newest file from one place to another. Here is how you would do the same in PowerShell:

$SourceFileSpec = "H:\"

$DestinationFileSpec...

How ironic. You're client is conscientious enough to do a penetration test yet they will not accept advice on not running a website using the sa Login. Wish them luck...

One would...

That's how I would...

SSMS 2012 can go against SQL 2008 R@. I think the setting is in the same place in SSMS 2008 R2. I was just pointing...

Yes. In SSMS 2012 go to Tools > Options > Query Results > SQL Server > Results to ... and increase the...

pervasive

medized (6/23/2013)

---

Dear folks,

I have been browsing the web looking for some help regarding the following issue. I am currently performing an web application penetration test, and I had come accross...

Jeff Moden (6/15/2013)

---

I like the idea of not having to concatenate lines or use long unreadable lines so I do thigs like the following...

DECLARE @Cmd VARCHAR(8000);

SELECT @Cmd = '

echo...

Writing a PowerShell script and kicking it off using powershell.exe from a SQL Agent CmdExec Job Step would be another option here. The backflips you're having to perform using xp_cmdshell...

Can you switch from OLE Automation (sp_OA procs) to SQLCLR and COM interop? The .NET Framework being a managed environment you probably won't have any issues with hung in-process dlls.

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql = @sql + 'GRANT INSERT, SELECT, UPDATE ON ' + QUOTENAME(OBJECT_SCHEMA_NAME(object_id)) + N'.' + QUOTENAME(name) + ' TO [YourRoleName];

'

FROM sys.views

WHERE...

This might help you start learning how to connect to databases on many different instances using SSIS:

http://thesqldev.wordpress.com/2013/03/23/iterate-over-databases-using-ssis-part-2/%5B/url%5D

Green

nakache (6/20/2013)

---

i fixed my code to support the "problematic" gmail which strips any CSS styling...

and as you say "keep it simple" , so NO bcp, NO xp_cmdshell ,NO Blat =...