Whenever I suspect the IO system to be unreliable, I move all DB stuff that is on it !

No doubt.

I wouldn't take the risk of down time or losing data...

Well, could be someone of these users is locking some critical data, blocking everybody else from processing their stuff.

Attached you can find my SP_dba_whoblocks sproc which I use on all...

did you check for (b)locking in your sqlinstance ?

DanMaxic (12/13/2012)

---

Hello Guys,

Please dont try use master.sys.xp_cmdshell, becouse of security reason it might be blocked.

u can use the DMV dm_exec_connections to get the info:

SELECT TOP 1 local_net_address FROM...

just a very primitive tip: Start small !

Start building your disaster recovery project with a very small scope, not that critical to business activity.

Only read the headers of the...

Red Gate should indeed fix ALL refs it has to this wonderful resource !

1) Grant deserves it ! :smooooth:

2) The topic deserves it ! :kiss:

3) many people are looking...

Guess what was the first script my win-admin produced using powershell: A nice GUI :hehe:

A wpf window requesting user input.

Just like I did, he started off with...

Del Lee (12/6/2012)

---

Gotcha on the date formatting. I've implemented that, thanks.

Not sure why we are concerned about SQL Injection on this, though. I'm doing a straight INSERT. ...

Thank you for the feedback !

Keep in mind you will - sooner or later - hit localization problems because you convert stuff to...

Looking at your code a bit more in detail ... :blush:

Why doesn't it hit a syntax error ??

IMO for your code to work it should be something like this :

$cmd.commandtext...

of course - to get started - you can always use this catch block

catch {

write-host 'Catch block' -BackgroundColor Yellow -ForegroundColor Black

Write-Host $_.Exception.message -BackgroundColor Red -ForegroundColor...

I use SQLPSx sqlpsx.codeplex.com , just for convenience 😀

[HashTable]$SprocParams = @{}

foreach ( $c in $RecordFields ) {

$SprocParams.Add($c.Name , [string]$CurrentRow.$($c.Name) )

}

$rc = Invoke-StoredProcedure -connection "Server=$TargetSQLServer;Database=$SQLDb;Trusted_Connection=True;Connect Timeout=5;Application Name=$Global:ApplicationName;Workstation Id=$env:COMPUTERNAME;" -timeout 5...

+1

I liked the first edition 🙂

can't wait to devour this one :w00t:

actually .... nothing !

it only exports sqlplans and consumption data ( as stated in the query to be run by the script ).

( I must have misinterpreted your previous replies...